Connecting to DB2

[terrysb]

I am having troubles getting a connection to my DB2 UDB 8.1 datasource with JBOSS 3.0.7. The error message indicates that the db2 driver cannot be registered:

no db2jdbc in java.library.path

I have tried all the previously suggested remedies such as:

rename db2java.zip to db2java.jar
place the above in the lib directory, etc.


Any other suggestions ?

Thanks.

[joelvogt]

which lib? jboss/server/default/lib?
If so, check the jar file doesn't have anything corrupted about it. Try downloading a previous version and see if you have the same issues

[terrysb]

The .jar is in server/default/lib.

I tried replacing it with another version but I am getting the identical error.

[haraldgliebe]

DB2's jdbc driver is a type 2 driver, that means it uses native code to connect to the database. To allow the driver to find it's dll, add <db2>\sqllib\bin and <db2>\sqllib\lib to your PATH (windows) or LD_LIBRARY_PATH (unix).

Regards,
Harald

[terrysb]

That's It !!!!

Many thanks. Jboss is happy talking to db2 now !