[Squirrel-sql-users] DB2 Driver

[RP <xy...@ho...>]

OK, getting there exceptionally slowly!

I seem to have a whole bunch of java files for DB2 in

/usr/IBMdb2/7.1/java

and a bunch more in

/usr/IBMdb2/7.1/java12

There is a db2java.zip file (hence me not being able to find any
.jars!) that seems to be the correct thing. However, when try to
close the "add driver" section, having specified the .zip file in
the extraclasspaths, I get the following error:

"java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path"

Gotta love those Java errors!

A quick google shows lots of people having fun with all this, and
it turns out the solution was fairly simple... if very well
hidden. It all became clear when I tried running SQuirreL as the
DB2 user. Suddenly the error vanished. Fantastic! (Basically, any
user wanting to run SQuirrel also needs to the the db2profile
script within the db2 instance directory).

Hope that helps next time someone else as new to all this as me
tries to use SQuirreL and DB2!