Oracle JDBC OCI driver access in Tomcat 2006-11-30 - By Narayanaswamy, Mohan
Back
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: Gurpreet.Sachdeva@(protected)
[mailto:Gurpreet.Sachdeva@(protected)]
Sent: Friday, December 01, 2006 2:45 AM
To: users@(protected)
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@(protected) To unsubscribe,
e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(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@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)
|
|
