If you are using the "app" driver rather than the "net" driver, then I
believe the DB2 jdbc driver uses JNI to call native code.
On NT, c:\sqllib\bin needs to be in the system PATH.
On AIX, I believe that the LIBPATH has to contain /usr/lpp/db2_05_00/lib
directory and various other environment vars neet to be set before your
servlet runner is started up.
John Zerbe - Mellon Bank
Phone: 412-234-1048 E-Mail: [EMAIL PROTECTED]
> -----Original Message-----
> From: Sanjay Mahapatra [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, May 13, 1999 11:21 AM
> To: [EMAIL PROTECTED]
> Subject: JRUN : Strange problemloading JDBC driver
>
> Hi
>
> Last morning we deployed some servlets on JRUN.
>
> 1. I edited the jsm.properties file and added the jdbc driver named
> "db2java.zip" to the java.classpath variable.
> 2. I added my jar file containing the packaged classes including the
> servlet
> classes into the appropriate lib directory.
> 3. Everything worked fine- the servlets accessed the database, I tested
> things out and released the URL to users for comments.
>
> 4. Strangely enough, last evening the servlets could not access the
> database
> because of some problem loading the JDBC driver.... I got the following
> error as clipped out of our applications own LOG files:
>
> ### clipping from logs starts
> java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in
> java.library.path
> ### clipping from logs ends
>
> 5. This, inspite of the fact that the jsm.properties file was not edited
> since last morning - when everything it was working fine and we have not
> changed anything else.
>
> I wonder if some variable such as java.lib must be set. (?)
>
> 6. I looked up some documentation from JRUN and found some suggestion
> that
> the BIN directory "is where the JDBC driver libraries might be placed".
> But
> this has to do with the PATH rather than the classpath.
>
> Hope someone has a clue and has a moment to advice.... The clippings from
> the jsm.properties file containing classpath entries for my jar file and
> the JDBC driver db2java.zip are attached herewith for reference
>
> # jsm.properties file starts
> # JRun Service Manager Properties
> #
>
> java.args=
> redirect.stderr=true
> java.securitymanager=
> jrun.api21=false
> redirect.stdout=true
> admin.port=56492
> admin.bindaddress=*
>
> jrun.rootdir=D:/JRun
> java.path=D:\\JRun\\examples\\jni
>
> java.classpath=D:/JRun/classes;D:/JRun/jsm-default/classes;D:/JRun/lib/jru
> n.
> jar;D:/JRun/lib/servlet.jar;D:/JRun/lib/cfanywhere.jar;D:/JRun/instantdb/c
> la
> sses;D:/JRun/lib/jrunadmin/jrunadmin.jar;D:/JRun/jdk1.2/lib/rt.zip;D:/JRun
> /j
> dk1.2/lib/i18n.zip;D:/JRun/jdk1.2/lib/tools.jar;D:/JRun/lib/ariesservertes
> t.
> jar;D:/JRun/lib/aric.jar;D:/SQLLIB/java/db2java.zip;
> java.exe=D:\\JRun\\jdk1.2\\bin\\javaw.exe
>
> # jsm.properties file ends
>
>
> Thanks
>
> Sanjay
>
> __________________________________________________________________________
> _
> To unsubscribe, send email to [EMAIL PROTECTED] and include in the
> body
> of the message "signoff SERVLET-INTEREST".
>
> Archives: http://archives.java.sun.com/archives/servlet-interest.html
> Resources: http://java.sun.com/products/servlet/external-resources.html
> LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".
Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html
