no db2jdbc in java.library.path

I am tring to connect to DB2 database from Datadeploy.I set LD_LIBRARY_PATH and CLASSPATH settings.Still iam getting no db2jdbc in java.library.path.

Please suggest me to resolve the issue.

Thanks,
Msr

Find more posts tagged with

Comments

sumitk

Where have you done the classpath settings? Have you placed the driver file in OD/driver directory? Have you checked whether your driver file is proper file? What error message are you getting in the log?

nakumar

Is your DB2 and OD, on the same machine? What is the version of DB2 do you use? OD ships DB2 7.X driver ootb, if you are at a higher version then you need to copy the db2 drivers and put it into ODHOME/drivers and restart the service.

Attach the relevant logs if you still face the problem

connectionprofile.doc

msr

Hi Sumit/nakumar

Sorry for delay in reply,

I did my classpath settings in my .profile as "CLASSPATH=./:/opt/inst1/sqllib:/opt/IBM/db2/V8.1/java/db2java.zip"
"LD_LIBRARY_PATH=:/usr/openwin/lib:/usr/dt/lib:/usr/local/lib/sparcv9:/opt/IBM/db2/V8.1/java/db2java.zip:/opt/db2inst1/sqllib/lib"

Iam getting the folowing error messages in the log:
1)java.sql.SQLException: java.lang.UnsatisfiedLinkError: no db2jdbc in java.library.path
2)java.sql.SQLException: No suitable driver

My DB2 and OD are in different mechines.I had put my driver class (DB2java.zip) in LD_LIBRARY_PATH.

I tried in different ways to resolve the issue,still iam geting the same problem
Please give me suggestions to resolve the issue.

Thanks,
Msr.