Hi Mohan,
Thanx for the suggestion. But I am already using jars. I am not using zips
(as indicated below in the listing of libraries).
Regards,
Gurpreet
"Narayanaswamy,
Mohan"
<Mohan.Narayanasw To
[EMAIL PROTECTED] "Tomcat Users List"
artered.com> <users@tomcat.apache.org>
cc
11/30/2006 07:08
PM Subject
RE: Oracle JDBC OCI driver access
in Tomcat
Please respond to
"Tomcat Users
List"
<[EMAIL PROTECTED]
che.org>
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]
*********************** 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]
