[Squirrel-sql-users] DB2 Driver
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
|
From: RP <xy...@ho...> - 2003-09-16 15:44:39
|
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! |