Return-Path: Mailing-List: contact tomcat-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list tomcat-user@jakarta.apache.org Received: (qmail 39542 invoked from network); 9 Nov 2000 17:57:22 -0000 Received: from unknown (HELO www.datasynapse.com) (216.205.87.58) by locus.apache.org with SMTP; 9 Nov 2000 17:57:22 -0000 Received: from AALTO (24-29-132-210.nyc.rr.com [24.29.132.210]) by www.datasynapse.com (8.9.3/8.9.3) with SMTP id MAA10148 for ; Thu, 9 Nov 2000 12:49:09 -0500 Message-ID: <019601c04a76$8f54a760$0a08a8c0@AALTO> From: "John Skovron" To: References: Subject: Re: Oracle and Tomcat Date: Thu, 9 Nov 2000 12:57:12 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Spam-Rating: locus.apache.org 1.6.2 0/1000/N We use the Oracle 8i Java "thin" JDBC client on Linux without the oci native libraries, by including the JDBC extenstions (jdbc2_0-stdext.jar) and the Oracle Java thin JDBC classes (classes111.zip). You have to get the jars included in the classpath during the tomcat startup script and specify the thin client in the JDBC connection parameters. Not sure if that's what you want but it works for us. - John ----- Original Message ----- From: "David Molloy" To: Sent: Thursday, November 09, 2000 7:29 AM Subject: Oracle and Tomcat > Hi, > > I've been through all this before with JServ and I'm working > on Tomcat now. I'm trying to get JDBC connections going with Tomcat > (I've got a connection pool) and I get the standard: > > java.lang.UnsatisfiedLinkError: no ocijdbc8 in java.library.path > at java.lang.Throwable.fillInStackTrace(Native Method) > etc.. > > This is the same as I got in JServ and it is due to the LD_LIBRARY_PATH > not being set correctly. I've a little confused in Tomcat how this > should be set though... > > At the top of the tomcat.sh file I added the lines... > LD_LIBRARY_PATH=/oracle_sw/app/oracle/product/8.1.5/lib > echo "LD_LIBRARY_PATH=${LD_LIBRARY_PATH}" > ORACLE_HOME=/oracle_sw/app/oracle/product/8.1.5 > ORACLE_SID=OAK > DISPLAY=oak.hostname.ie:0.0 > > Also in the tomcat.properties file I added in the lines.... > > # An environment name with value passed to the JVM > # Syntax: wrapper.env=[name]=[value] (String) > # Default: NONE on Unix Systems > # SystemDrive and SystemRoot with appropriate values on Win32 systems > wrapper.env=LD_LIBRARY_PATH=/oracle_sw/app/oracle/product/8.1.5/lib > wrapper.env=ORACLE_HOME=/oracle_sw/app/oracle/product/8.1.5 > wrapper.env=ORACLE_SID=OAK > wrapper.env=DISPLAY=oak.hostname.ie:0.0 > > However none of these seem to have any effect when I kill Tomcat and > start it again. Any ideas would be greatly appreciated... I presume > I am just setting the environment variables wrong since I have the > exact same stuff working concurrently with JServ. Thanks. > > David > > PS: System is Oracle8.1.5, Solaris7, Tomcat3.1 Release