Solved

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

Posted on 2006-10-30
3
2,700 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle SQL syntax check  without executing 6 75
even odd program using while loop 3 60
Java string replace 11 55
ejb entity bean example issue 2 18
By the end of 1980s, object oriented programming using languages like C++, Simula69 and ObjectPascal gained momentum. It looked like programmers finally found the perfect language. C++ successfully combined the object oriented principles of Simula w…
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…
Viewers will learn about the regular for loop in Java and how to use it. Definition: Break the for loop down into 3 parts: Syntax when using for loops: Example using a for loop:
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.

830 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