Very Computer

our app uses the db2 jdbc driver and we constantly are getting this
error when it is trying to create a connection or load the driver. I
have looked all over the place for the answer, and have c:\program
files\ibm\sqllib\bin\db2jdbc.dll in the LD_LIBRARY_PATH,
java.library.path, PATH etc etc. Where exactly do I need to do, where
exactly do I need to make a configuration change to get the JVM to
find this dang thing?

java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in
java.library.path
 at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
 at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAcces
sorImpl.java:39)
 at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstruc
torAccessorImpl.java:27)
 at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
 at java.lang.Class.newInstance0(Class.java:306)
 at java.lang.Class.newInstance(Class.java:259)
 at org.openmrm.core.data.Database.loadDriver(Database.java:238)
 at org.openmrm.core.data.Database.initialize(Database.java:139)

Anyway, have you tried quoting the reference to db2jdbc.dll in
LD_LIBRARY_PATH or using the short name for the path?

ie. LD_LIBRARY_PATH=%LD_LIBRARY_PATH%:"C:\Program
Files\IBM\SQLLIB\bin\db2jdbc.dll" or
LD_LIBRARY_PATH=%LD_LIBRARY_PATH%:C:\Progra~1\IBM\SQLLIB\bin\db2jdbc.dll.

--
Garfield A. Lewis
DB2 UDB Development,
IBM Canada Laboratory

Quote:> Hi,
> Running DB2 8.0 on win2k with Tomcat 4.0.6. Starting tomact from the
> command line via bin/startup

> our app uses the db2 jdbc driver and we constantly are getting this
> error when it is trying to create a connection or load the driver. I
> have looked all over the place for the answer, and have c:\program
> files\ibm\sqllib\bin\db2jdbc.dll in the LD_LIBRARY_PATH,
> java.library.path, PATH etc etc. Where exactly do I need to do, where
> exactly do I need to make a configuration change to get the JVM to
> find this dang thing?

> java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in
> java.library.path
>  at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source)
>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>  at

Quote:> sorImpl.java:39)
>  at

Quote:> torAccessorImpl.java:27)
>  at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>  at java.lang.Class.newInstance0(Class.java:306)
>  at java.lang.Class.newInstance(Class.java:259)
>  at org.openmrm.core.data.Database.loadDriver(Database.java:238)
>  at org.openmrm.core.data.Database.initialize(Database.java:139)

drivers are in db2java.zip and db2jcc.jar files (read classpath here) if i'm
not wrong.
I don't think people need to reference the db2jdbc.dll file in some path
variable.

Maybe tomcat uses some of those servers.xml files... ?

Anyway, i'm pretty sure tomcat has some doc on the topic. (configuration,
jdbc, jca, etc.)
I think the preferred way to get a connexion is to use a datasource.

PM

Quote:> Hi,
> Running DB2 8.0 on win2k with Tomcat 4.0.6. Starting tomact from the
> command line via bin/startup

> our app uses the db2 jdbc driver and we constantly are getting this
> error when it is trying to create a connection or load the driver. I
> have looked all over the place for the answer, and have c:\program
> files\ibm\sqllib\bin\db2jdbc.dll in the LD_LIBRARY_PATH,
> java.library.path, PATH etc etc. Where exactly do I need to do, where
> exactly do I need to make a configuration change to get the JVM to
> find this dang thing?

> java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in
> java.library.path
>  at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source)
>  at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>  at

Quote:> sorImpl.java:39)
>  at

Quote:> torAccessorImpl.java:27)
>  at java.lang.reflect.Constructor.newInstance(Constructor.java:274)
>  at java.lang.Class.newInstance0(Class.java:306)
>  at java.lang.Class.newInstance(Class.java:259)
>  at org.openmrm.core.data.Database.loadDriver(Database.java:238)
>  at org.openmrm.core.data.Database.initialize(Database.java:139)