You have to install Oracle 9 Client http://forums.oracle.com/forums/thread.jspa?messageID=1526720� and make a backup copy of your jvm.cfg be careful when manipulating LD_LIBRARY_PATH in $JAVA_HOME/jre/lib/$Processor/jvm.cfg to include libraries located in $ORACLE_HOME/lib (version inconsistencies with either so or dll libraries may very well cause the VM to halt)
Anyone else? M- This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents ----- Original Message ----- From: <[EMAIL PROTECTED]> To: "Tomcat Users List" <users@tomcat.apache.org> Cc: "Tomcat Users List" <users@tomcat.apache.org> Sent: Thursday, November 30, 2006 2:18 PM Subject: RE: Oracle JDBC OCI driver access in Tomcat > > > > > 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] > >
