java.lang.UnsatisfiedLinkError: Can't find library db2jdbc (libdb2jdbc.so) in java.library.path

Hello,

I am trying to run my standalone java application in a unix box through a shell script.  There is no WAS(websphere application server or a webserver involved). I get the following error while the main method attempts to make a database connection to DB2:
Class ConnectPool: Function getDatabaseConnection java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't find library db2jdbc  (libdb2jdbc.so) in java.library.path
java.library.path=/usr/lpp/java/IBM/J1.3/bin/:/usr/lpp/java/IBM/J1.3/bin/classic:/usr/lpp/db2/db2710/lib:/clocal/java/mqm/java/lib:/usr/lib
Exception in getConnectionjava.sql.SQLException: No suitable driver.

The shell script is as follows:

#!/bin/sh
export CLASSPATH=/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/activation.jar:\
/usr/lpp/servlets:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/db2java.zip:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/dccommon.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/ibmjsse.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/jsse.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/servlet.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/xerces.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/smtp.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/xml-apis-2_5_0.jar:\
/usr/lpp/cicsts/ctg/classes/ctgclient.jar:\
/usr/lpp/cicsts/ctg/classes/ctgserver.jar:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/recjava.jar:\
/usr/lpp/java/IBM/J1.3/lib/ext/recordio.jar:\
/clocal/java/jaf/activation.jar:\
/clocal/java/javamail/mail.jar:\
/usr/lpp/servlets:\
/usr/lpp/db2/db2710/classes/db2jdbcclasses.zip:\
/usr/lpp/db2/db2710/classes/db2sqljclasses.zip:\
/usr/lpp/db2/db2710/classes/db2j2classes.zip:\
/usr/lpp/db2/db2710/classes/db2sqljruntime.zip:\
/usr/lpp/servlets/com/dcx/restricted/slsmkt/compdb/qpartret.properties\

export JAVA_HOME=/usr/lpp/java/IBM/J1.3
export LD_LIBRARY_PATH=/usr/lpp/db2/db2710/lib:/clocal/java/mqm/java/lib
export LIBPATH=/usr/lpp/db2/db2710/lib:/clocal/java/mqm/java/lib
export STEPLIB=TSYS.DSNLOAD
export DB2SQLJPROPERTIES=/usr/lpp/websrvw/WebSphere/server/properties/db2sqljjdbc.properties

/usr/lpp/java/IBM/J1.3/bin/java com.dcx.restricted.slsmkt.compdb.RMU_UPS_ShippingBatch_Main

This is urgent. I would really appreciate if you could point me to right direction.

Regards
Jignesh
JigspatAsked:
Who is Participating?
 
objectsConnect With a Mentor Commented:
put libdb2jdbc.so in one of the directories in java.library.path
0
 
nagwani1Connect With a Mentor Commented:
make sure libdb2jdbc.so is in PATH variable
0
 
JigspatAuthor Commented:
That works. Thank you very much.
0
All Courses

From novice to tech pro — start learning today.