alterTableOrEgo

How to quickly call a stored procedure in Spring

2012-02-01T03:49:00.001-08:00

If your procedure does not take parameters nor return any values (or you're not interested), do just that:

DataSource dataSource = getDataSourceSomehowMostProbablyFromYourSpringContext();

SimpleJdbcCall theProcedureCall = new SimpleJdbcCall(dataSource).withProcedureName("myproc");

That's it

Windows 98 SE under VMware Player

2012-01-28T11:38:00.001-08:00

What you need:

Win 98 SE CD (obviously...)
SoundBlaster PCI 128 drivers
some of the unofficial Win98 Service Packs (e.g. http://exuberant.ms11.net/98sesp.html or - I guess Polish only - http://www.softmania.pl/program-1252-nieoficjalny_service_pack_plus_dla_windows_98_se.html)
VMware Tools - windows.iso, take it from e.g. http://packages.vmware.com/tools/esx/5.0/index.html

Remarks:

do not use USB 2.0 - uncheck it in VM's settings. see http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1011734
install SB PCI 128 drivers to have sound working

Python 2.7 under Ubuntu Lucid

2011-11-18T03:18:00.001-08:00

The latest 2.x version available is 2.6.5.

1. Add ppa:pythoneers/lts PPA

2. sudo apt-get install python2.7

To add some more packages use eggs. E.g. download

http://pypi.python.org/packages/2.7/s/setuptools/setuptools-0.6c11-py2.7.egg

and

sudo sh setuptools-0.6c11-py2.7.egg

Use svn-clean safely

2011-03-12T09:12:00.001-08:00

That is, suppose you have some useful stuff in your project sources "root" directory, e.g. it looks like that:

frontend

backend

api

.metadata

some-makeshift-file-with-useful-content-you-do-not-want-to-be-removed

Now you want to use svn-clean script, which is a part of subversion-tools Debian package (see e.g. http://packages.debian.org/search?keywords=subversion-tools). If you invoke it like that:

svn-clean .

you'll lose your eclipse workspace and that useful file with a lenghty name. So:

find -maxdepth 1 -mindepth 1 -type d -name "[a-zA-Z]*" -exec svn-clean {} \;

How to resolve Subversion merge conflicts using kdiff3

2011-03-11T06:55:00.001-08:00

export SVN_MERGE=/path/to/the/script/below/mergewrap.sh

#!/bin/sh

# mergewrap.sh

kdiff3 $1 $2 $3 -o $4

Now let's merge something and wait until SVN client detects a conflict and asks you what to do - then choose "l" for "launch external tool to resolve conflict":

svn merge -c17218 ^/src/trunk

--- Merging r17218 into 'backend':

U backend/src/main/resources/default.properties

Conflict discovered in 'backend/pom.xml'.

Select: (p) postpone, (df) diff-full, (e) edit,

(mc) mine-conflict, (tc) theirs-conflict,

(s) show all options: l

When you are done with the merge, have saved the file and closed kdiff3, you are asked the same question again. Now you can answer "r" for "accept merged version of file". That's it.

They say you can also set merge-tool-cmd configuration property, but somehow it did not work for me. SVN_MERGE did.

Downloading JAR from Maven repository to local repo

2011-01-26T06:01:00.001-08:00

AFAIR there is no way to specify classifier (e.g. sources) and you'd better give the full plugin name as version 2.0 does not have that functionality, But quite useful sometimes to quickly have the dependency installed locally:

mvn org.apache.maven.plugins:maven-dependency-plugin:2.1:get -Dartifact=junit:junit:3.8.1 -DrepoUrl=http://download.java.net/maven/2

Installing JAR in a local Maven repo

2011-01-13T04:16:00.001-08:00

They say

mvn install:install-file -Dfile=<path-to-file> -DgroupId=<group-id> \

-DartifactId=<artifact-id> -Dversion=<version> -Dpackaging=<packaging>

so...

mvn install:install-file -Dfile=junit-4.9b1.jar -DgroupId=junit \

-DartifactId=junit -Dversion=4.9b1 -Dpackaging=jar

Adjusting PostgreSQL sequence

2010-11-05T14:48:00.001-07:00

Sometimes (hopefully not in production) you have "low" sequence values but "high" identifiers in the respective table. That usually results in primary key violation on an attempt to insert a new row.

So - if you really do not want to delete the data, you should make the sequence have those "high" values, ideally max(id_from_the_table) + 1.

In PostgreSQL it turns out to be much more elegant than in Oracle, where you can either come up with some PL/SQL FOR loop or use DDL ALTER SEQUENCE statements. The examples have been copied from

http://www.postgresql.org/docs/current/static/functions-sequence.html

SELECT setval('foo', 42); Next nextval will return 43

SELECT setval('foo', 42, true); Same as above

SELECT setval('foo', 42, false); Next nextval will return 42

How to convert a collection of MonkeyAudio (ape) files to Ogg Vorbis on Ubuntu 10.04

2010-10-10T07:46:00.001-07:00

OK, I have got some quite old backups of my audio CDs in APEs (created under Windows years ago). Would like to have them in Oggs of fairly low quality so that they do not take too much space. That page looks promising:

http://lossless2lossy.sourceforge.net/

It states you will need oggenc and MAC for such a conversion.

So...

1. For oggenc (a part of vorbis-tools)

sudo apt-get install vorbis-tools

2. And the MAC thingy? Well... seems there were some licensing problems with that and it is no longer in the official repos. So download it from

http://members.iinet.net.au/~aidanjm/mac-3.99-u4_b3-1_i386.deb

(as stated in http://aidanjm.wordpress.com/2007/01/26/using-monkeys-audio-ape-files-in-ubuntu/ which seems to be the root here, see also https://bugs.launchpad.net/ubuntu/+bug/119412 for the license problems discussion; even some PPA repo is mentioned there)

and install, e.g. by means of GDebi or

sudo dpkg -i mac-3.99-u4_b3-1_i386.deb

3. Download lossless2lossy:

http://sourceforge.net/projects/lossless2lossy/files/

4. Put it somewhere in your PATH (~/bin for example) and...

chmod u+x ~/bin/lossless2lossy-v1.21

ln -s ~/bin/lossless2lossy-v1.21 ~/bin/lossless2lossy

5. Convert the whole stuff, saving intermediary wav files to /tmp and not retaining them

lossless2lossy ogg vbr 1 ~/music/ape /tmp ~/music/ogg nosave

Quite recently support for MonkeyAudio has been added to ffmpeg - to be checked...

Eclipse Data Tools Platform - getting nicer

2010-05-14T05:31:00.001-07:00

Did not use to use it since it seemed inferior to more specialised tools. But I can see in Galileo (3.5 that is) it behaves much better and is suitable for many tasks involving just reviewing and/or editing data. Especially not BLOBS - haven't tried out the current DTP support for them though.

In preferences, under General/Data Manegement/SQL Editor on "General" tab you can set what "Execute current text" should mean. I do not like the default "Execute current line" but the other choices "between delimiters" and "between blank lines" are much better. Alt+s in SQL scrapbook and I have my query executed.

FlashGot-like download by means of wget in Opera under Linux

2010-05-04T21:33:00.000-07:00

To have Opera behave similar way as Firefox with FlashGot http://flashgot.net/ - that is, to have wget download files:

Edit ~/.opera/menu/standard_menu_1.ini file (note: Opera must not run!)
In section [Link Popup Menu]
add the following line:
Item, "Download by wget"="Execute program, "xterm +132 -e wget -P/home/username/downloads","%l""

Inspiration: http://www.linux.com/archive/feature/59457

How to get a value of an XML element from XMLType in Oracle

2010-05-02T14:00:00.001-07:00

EXTRACTVALUE method:
EXTRACTVALUE(XMLTYPE_instance,XPath_string) or
EXTRACTVALUE(XMLTYPE_instance,XPath_string, namespace_string)
e.g.

select extractvalue(details, '/SomeDoc/SomeDetail')
from SomeTable

How to get X.509 certificate from CMS/PKCS#7 signature

2009-06-16T12:45:00.000-07:00

openssl pkcs7 -in signaturefile.sig -inform DER -print_certs -text

Display a command result in new Xfce terminal window

2009-06-13T16:32:00.000-07:00

Sometimes you just want to display a result, as for ls:

xfce4-terminal -H -e ls

But sometimes it makes sense to display results continuosly, like for htop or elinks:

xfce4-terminal -e htop

How to get executable shell scripts from Subversion repository

2009-06-13T14:06:00.000-07:00

All you have to do is to set svn:executable property on the file

svn propset svn:executable on somescript.sh

svn commit

Especially important when done on Windows (SVN client should set this automatically if executable file is being added to version control on Linux)

Keyboard shortcut for "Add to version control" in eclipse

2009-06-13T03:00:00.001-07:00

I am really fed up with right-clicking and choosing "Add to version control". I defined a keyboard shortcut then.

Press Ctrl Shift L twice. On "Keys" preference page find "Add to version control", preferably using the relevant search box. When - "In windows". I chose "Ctrl+Shift+Alt+C" so that it won't interfere with anything (I hope).

End-of-line characters conversion between Windows and Linux

2009-05-22T01:41:00.000-07:00

Just started to work for a project where the majority of the people use Windows. Quick fix for ^M occuring in shell scripts:

sudo aptitude install tofrodos

and then

find . -name '*.sh' | xargs dos2unix -d

(could be with exec, but for a small number of files it does not really matter)

A cryptographic hash of an empty byte array does exist. Honestly.

2009-05-09T10:44:00.000-07:00

An hour or so spent and finally the reason found - no data. That test proves it in a way:


    @Test
    public void testNullDigest() throws Exception {
        MessageDigest md = MessageDigest.getInstance("SHA1");
        System.out.println(ArrayUtils.toString(md.digest(new byte[0])));
    }

The output:


{-38,57,-93,-18,94,107,75,13,50,85,-65,-17,-107,96,24,-112,-81,-40,7,9}

Exactly the same as the one I was getting. In particular, different from the expected one (suprise). I should make some constant ;-/

Quick search in Midnight Commander

2009-05-02T03:48:00.000-07:00

Just press Alt+s and then start typing the name.

Prune unnecessary log4j dependencies in maven

2009-05-02T03:32:00.000-07:00

If you want to use the newest log4j with maven build, you may notice a few dependencies you may not want to include if you just want to have plain ordinary logging without JMX or mail support.


<dependency>
 <groupId>log4j</groupId>
 <artifactId>log4j</artifactId>
 <version>1.2.15</version>
 <exclusions>
  <exclusion>
   <groupId>javax.jms</groupId>
   <artifactId>jms</artifactId>
  </exclusion>
  <exclusion>
   <groupId>javax.mail</groupId>
   <artifactId>mail</artifactId>
  </exclusion>    
  <exclusion>
   <groupId>com.sun.jdmk</groupId>
   <artifactId>jmxtools</artifactId>
  </exclusion>
  <exclusion>
   <groupId>com.sun.jmx</groupId>
   <artifactId>jmxri</artifactId>
  </exclusion>    
 </exclusions>
</dependency>

View all Subversion commiters

2009-04-30T05:14:00.001-07:00

Do you want to see everyone who checked something in to SVN repo?
svn log | egrep 'r[0-9]* ' | cut -f2 -d '|' | sort -u

Templates in Thunar (Create document...)

2009-03-24T08:21:00.000-07:00

Just put the template file in ~/Templates and that's it. Source

How to change the default WPS password in Websphere Integration Developer

2009-03-03T04:06:00.000-08:00

Here is the file
~/.eclipse/ibm.websphere.integration.developer_7.0.0_1741360425/configuration/.settings/com.ibm.wbit.runtime.core.prefs
and that context is to be changed:
security.user.wps_61=admin
security.password.wps_61={xor}PjsyNjE\=
For password encoding that entry might be helpful.
UPDATE: From now on you do not have to enter embedded WebSphere user/password every time you start WID. For Windows, the directory and file can somewhere in WID61\configuration\.settings\com.ibm.wbit.runtime.core.prefs. I think it could be in similar place on Linux, but that depends on your user's write rights to WID directory. I should have issued a proper umask prior to the installation apparently - but when you read installation docs few months after the installation, such things happen.

Oracle not starting after system reinstallation

2009-03-02T02:53:00.000-08:00

After formatting root partition and installation of Xubuntu 8.10 instead of Kubuntu 8.04 (but preserving /home) Oracle failed to start:
oracle[SID]: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
ERROR:
ORA-12547: TNS:lost contact

Enter user-name:

The solution was to install libaio1:
sudo aptitude install libaio1
Well, somewhat natural consequence of the decision not to automatically reinstall all the packages present in my previous Hardy installation...
http://forums.oracle.com/forums/thread.jspa?messageID=2797706&tstart=0

Splitting and joining large files

2009-02-27T12:34:00.000-08:00

cd /music/Pearl Jam/Ten
mkdir tmpoceans
# split the file
split -b 400k 07\ -\ Oceans.ogg tmpoceans/07\ Oceans.ogg.
# check the created parts
ls -1 tmpoceans
07 Oceans.ogg.aa
07 Oceans.ogg.ab
07 Oceans.ogg.ac
07 Oceans.ogg.ad
# split it back
cat 07\ Oceans.ogg.* > 07\ Oceans.ogg
# and play
ogg123 07\ Oceans.ogg

http://www.techiecorner.com/107/how-to-split-large-file-into-several-smaller-files-linux/

http://www.johnrockefeller.net/?p=195

Thunar - single click instead of the default double

2009-02-24T07:36:00.000-08:00

Edit/Preferences/Behaviour/
Single click to activate items

http://xfce.jakilinux.org/viewtopic.php?id=19

Subversion - repository URL of working copy

2009-02-23T12:53:00.000-08:00

That tiny script is useful when you've got a few branches and dir names do not reflect those in the repo, eg. branch1, branch2 vs http://oursvnrepo/importantproject/branches/{somefeature,anotherfature} (quite possible in large projects with frequently created branches). Yes, it could be a bit more elegant and discover when the parameter is not a directory, but anyway:
# !/bin/bash
# usage:
# svnpath - SVN repo URL for current dir
# svnpath dirname - svn repo URL for given dir
if [ -z "$1" ]
then
grep '//' .svn/entries | head -n1
else
grep '//' "$1"/.svn/entries | head -n1
fi

Other users' Oracle sessions

2009-02-23T12:22:00.000-08:00

select process, program, osuser, sid, serial#,
BLOCKING_SESSION_STATUS, SECONDS_IN_WAIT, lockwait, status
from v$session
where type = 'USER'
and nvl(osuser, 'nomycurrentuser') != 'mycurrentuser'

Where are Oracle trace files written

2009-02-23T12:21:00.000-08:00

select value from v$parameter
where name like '%user_dump%'
/

Useful SQL+ commands, part 1

2009-02-20T05:53:00.000-08:00

Useful for "reports"
set linesize 200
set pages 0 -- effectively switches off any headers
Useful for displaying long columns - not only LONG but e.g. XMLType
set long 10000 -- ... or so

Import Oracle dump into an existing schema

2009-02-20T04:09:00.000-08:00

First drop all sequences for a user:
declare
cursor cr is select sequence_name from user_sequences;
begin
for c in cr loop
execute immediate 'drop sequence ' || c.sequence_name;
end loop;
end;
/
Import dump file
impdp appadmin/password directory=dmpdir dumpfile=appadmin.dmp SCHEMAS=appadmin table_exists_action=replace
It uses non-standard directory dmpdir instead of the default one DATA_PUMP_DIR, to create it run sth like:
CREATE OR REPLACE DIRECTORY dmpdir as '/opt/oracle/dmp'
from an account with proper privs (CREATE ANY DIRECTORY, "/ as sysdba" has got it definitely)

Mocp output in Xfce panel

2009-02-20T03:34:00.000-08:00

Get Generic Monitor for the Xfce4 panel
sudo aptitude install xfce4-genmon-plugin # or equivalent
Create a script generating your output, e.g.
echo "mocp -i | egrep 'SongTitle|Artist' | cut -d":" -f2" > ~/bin/mocpinfo4panel
Add Generic monitor to Xfce panel and input the script name into Command field, probably also change label to "mocp" or "now playing" or "what I could listen to if I didn't forgot my earphones" (well, perhaps a bit excessive).