| Author |
can't find library db2jdbc
|
|
|
| Hi,
I am setting up Portal 6 on RHLE 4 (AMD 64 Bit version). I am trying to transfer from Cloudscape to a Remote DB/2 system.
When I run the Transfer data process I get a validation failure. the error says its cos the process can not connect to my database. However before that i am getting a Java exception thrown, " ... cant find library db2jdbc ... ".
I have run the db2profile from /home/usr/db2inst1 and can issue DB2 commands ok / connect to my database. But I have obviously missed something.
Anybody got any pointers??
Thanks
Mike
| |
|
| Mike
Please can you post the exact error message that you see.
Regards
Dave Hay
david_hay@uk.ibm.com
| |
|
| Hi,
Sorry about the cryptic message.
I am testing the transfer of the data for the release domain, so the command that I am issuing is :-
/WPSconfig.sh validate-database-connection-wps -DDbDomainList=release
The message I get is file:../config/actions/validatation.xml:160: ERROR: Validate Dbconnection: Database connection to release.jdbc:db2:Rrelease could not be established.
However if I scroll back I have a Java stack trace the first few lines of which read :-
[sqlproc] action: validate-db-connection
[sqlproc] ________________________________________
_________________
[sqlproc] DbDomain: release
[sqlproc] Could not load driver
[sqlproc] java.sql.SQLException: java.lang.UnsatisfiedLinkError: Can't f
ind library db2jdbc (libdb2jdbc.so) in sun.boot.library.path or java.libr
ary.path
[sqlproc] sun.boot.library.path=/opt/IBM/WebSphere/AppServer/java/jre/bi
n
[sqlproc] java.library.path=/opt/IBM/WebSphere/AppServer/java/jre/bin:/o
pt/IBM/WebSphere/AppServer/java/jre/bin/classic:/opt/IBM/WebSphere/AppServ
er/java/jre/bin:/home/db2inst1/sqllib/lib:/usr/lib
[sqlproc] at COM.ibm.db2.jdbc.app.DB2Driver.<init>(Unknown Source)
[sqlproc] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(
Native Method)
[sqlproc] at sun.reflect.NativeConstructorAccessorImpl.newInstance(N
ativeConstructorAccessorImpl.java:80)
<cut>
So I am assuming the reason why the validation failed is because it can not find db2jdbc.
I have added it to my class path and I have the db2.DBlibrary property set to /opt/IBM/db2/V8.1/java/db2java.zip which is the correct location for my runtime client install.
Mike
| |
|
| Hi Mike
I'm assuming that you are using the appropriate level of DB2 UDB for a 64bit Linux OS, and that Portal has no issue with this specific OS in terms of 32bit vs. 64bit JVMs 
Have you run the script: -
/home/db2inst1/sqllib/db2profile
noting the syntax - dot space - which (iirc) ensures that the contents of the script are applied to the CURRENT shell, and not to a new shell.
?
Having done this, you should not need to manipulate your classpath, path, libpath etc.
Regards
Dave Hay
david_hay@uk.ibm.com
| |
|
| Hi,
Thanks for the help. That seems to be ok now.
In the end I downloaded the latest DB/2 Run Time Client and did a reinstall. I also made sure that when I installed the run time client I created a 32 bit instance and did not take the default of a 64 bit instance.
Mike
|
|
|
|