Solved

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

Posted on 2006-10-30
3
2,696 Views
Last Modified: 2007-12-19
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
0
Comment
Question by:Jigspat
3 Comments
 
LVL 2

Assisted Solution

by:nagwani1
nagwani1 earned 250 total points
ID: 17837576
make sure libdb2jdbc.so is in PATH variable
0
 
LVL 92

Accepted Solution

by:
objects earned 250 total points
ID: 17841124
put libdb2jdbc.so in one of the directories in java.library.path
0
 

Author Comment

by:Jigspat
ID: 17852187
That works. Thank you very much.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
firstChar challenge 13 110
thymeleaf natural templating vs JSP 2 67
web services creation SOAP vs REST 5 20
table example 4 22
This was posted to the Netbeans forum a Feb, 2010 and I also sent it to Verisign. Who didn't help much in my struggles to get my application signed. ------------------------- Start The idea here is to target your cell phones with the correct…
Basic understanding on "OO- Object Orientation" is needed for designing a logical solution to solve a problem. Basic OOAD is a prerequisite for a coder to ensure that they follow the basic design of OO. This would help developers to understand the b…
This tutorial covers a practical example of lazy loading technique and early loading technique in a Singleton Design Pattern.
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

24 Experts available now in Live!

Get 1:1 Help Now