Below information may be useful to you. abstract of oracle technical docs : JDK Driver File Name JDBC Version --- ---------------- ------------ 1.1 classes111.zip 7.3.4 - 1.2 classes12.zip 8.1.6 - 1.3 classes12.zip 9.2 - 1.4 ojdbc14.zip 9.2 -
If you use oracle 9i and JDK 1.4 you must use ojdbc14.jar (and not ojdbc14.zip as oracle says), classes12.zip also doesn't work. Regards, Mohan -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, December 01, 2006 2:45 AM To: users@tomcat.apache.org Subject: 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. *********************** Aricent-Unclassified *********************** "DISCLAIMER: This message is proprietary to Aricent and is intended solely for the use of the individual to whom it is addressed. It may contain privileged or confidential information and should not be circulated or used for any purpose other than for what it is intended. If you have received this message in error, please notify the originator immediately. If you are not the intended recipient, you are notified that you are strictly prohibited from using, copying, altering, or disclosing the contents of this message. Aricent accepts no responsibility for loss or damage arising from the use of the information transmitted by this email including damage from virus." --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] This email is confidential. If you are not the addressee tell the sender immediately and destroy this email without using, sending or storing it. Emails are not secure and may suffer errors, viruses, delay, interception and amendment. Standard Chartered PLC and subsidiaries ("SCGroup") do not accept liability for damage caused by this email and may monitor email traffic. --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
