Oracle JDBC OCI driver access in Tomcat
Hi,
I have a piece of code which I have to run in tomcat 5.5.7. This code is using Oracle JDBC OCI driver for database access. For use of OCI driver, the native library libocijdbc10.so has to be included.
When I run this code snippet as a standalone Java programme (standalone JVM), I do the following:
a) Give the command line option "-d64" while running the standalone programme.
b) Set the LD_LIBRARY_PATH to include the path of libocijdbc10.so and libocci.so
LD_LIBRARY_PATH=/opt/common/oracle_inst_client/instantclient_10_2
And
ls /opt/gmlc/common/oracle_inst_client/instantclient_10_2 ==>
classes12.jar
libnnz10.so
libociei.so
ojdbc14.jar
libclntsh.so.10.1
libocci.so.10.1
libocijdbc10.so
The standalone JVM works fine with these changes.
Now incase of tomcat, I have set the following parameters in "catalina.sh" :
JAVA_OPTS="-d64" - Djava.library.path=/opt/common/oracle_inst_client/instant
client_10_2
CATALINA_OPTS="-d64" -Djava.library.path=/opt/common/oracle_inst_client/ins
tantclient_10_2
I have copied all the jars and native libraries in $CATALINA_HOME/shared/lib and $CATALINA_HOME/common/lib
But the same peice of code when deployed in tomcat (with above mentioned settings) is not working.
Pls suggest a way out - some way to start tomcat application with "-d64" option.
Thanx and Regards,
Gurpreet.
