I usually just append all my JAR files to catalina.sh. That way you don't need a JAR file in each application.
It seems to be almost the same thing as stated below. CLASSPATH="$CLASSPATH":"$JAVA_HOME"/lib/jdbc/classes12.zip:"$JAVA_HOME"/lib/java mail/activation.jar:"$JAVA_HOME"/lib/javamail/mail.jar thanks! [ t r o y ] -----Original Message----- From: Lloyd Wiggins [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 10:44 AM To: [EMAIL PROTECTED] Subject: Re: JDBC connection failing to Oracle 8i with Tomcat3.3 What we did for this problem was to write a wrapper script for the startup.sh script. In the wrapper script set the classpath explicitly to point to the needed jar files and then call the normal startup script. Yes it's a hack but it solved the problem for us, as tomcat3.2.1 refused to load the jar files in the WEB-INF directory. Good luck. > -----Original Message----- > From: Emmanuel Eze [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]] > Sent: Monday, May 13, 2002 1:37 AM > To: [EMAIL PROTECTED] > Subject: Re: JDBC connection failing to Oracle 8i with Tomcat3.3 > > > Try to extract your driver jar file into your web server default class > directory. That way it will surely see the classes. > > -----Original Message----- > From: Gare, Tref [ <mailto:[EMAIL PROTECTED]> mailto:[EMAIL PROTECTED]] > Sent: Monday, May 13, 2002 10:23 AM > To: [EMAIL PROTECTED] > Subject: JDBC connection failing to Oracle 8i with Tomcat3.3 > > > Hi to all, > > Any help on this one will help save the remaining hair on my head for > which I will be truly grateful. We're having enormous dificulty > with getting an > Oracle JDBC driver recognised in our webapp. A day of > trawling google and > the archives have brought up a variety of solutions which > we've gone through > but so far to no avail.. > > The base error we're getting is the following > Root cause:java.lang.ClassNotFoundException: > oracle.jdbc.driver.OracleDriver > The environment is NT4, Tomcat 3.3, jdk1.3.1_01 and Oracle 8i > > Todate we have: > * downloaded the oracle JDBC driver classes12.zip and dumped it into > the the tomcat\lib directory both as the original zip and then > renamed as a jar - > no success > * Tried it in the specific web-app's lib folder. > * Edited the class path such that wherever it is can be seen > by the jdk and > attempted to run a small test app/class > * Expanded the zip file into the above directories one by one > > Our connection code looks pretty standard > > Class.forName("oracle.jdbc.driver.OracleDriver"); > Connection conn = > DriverManager.getConnection("jdbc:oracle:thin:@123.123.12.123: > dbname","user" > ,"pwd"); > > but we're getting nowhere. > > Does anyone have any thoughts? > > Thanks in advance > > > Tref Gare > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: > "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > <http://archives.java.sun.com/jsp-interest.html> >http://archives.java.sun.com/jsp-interest.html > <http://java.sun.com/products/jsp/faq.html> >http://java.sun.com/products/jsp/faq.html > <http://www.esperanto.org.nz/jsp/jspfaq.jsp> >http://www.esperanto.org.nz/jsp/jspfaq.jsp > <http://www.jguru.com/faq/index.jsp> http://www.jguru.com/faq/index.jsp > <http://www.jspinsider.com> http://www.jspinsider.com > > ============================================================== > ============= > To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff > JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: > "set JSP-INTEREST DIGEST". > Some relevant FAQs on JSP/Servlets can be found at: > > <http://archives.java.sun.com/jsp-interest.html> >http://archives.java.sun.com/jsp-interest.html > <http://java.sun.com/products/jsp/faq.html> >http://java.sun.com/products/jsp/faq.html > <http://www.esperanto.org.nz/jsp/jspfaq.jsp> >http://www.esperanto.org.nz/jsp/jspfaq.jsp > <http://www.jguru.com/faq/index.jsp> http://www.jguru.com/faq/index.jsp > <http://www.jspinsider.com> http://www.jspinsider.com > =========================================================================== To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: <http://archives.java.sun.com/jsp-interest.html> http://archives.java.sun.com/jsp-interest.html <http://java.sun.com/products/jsp/faq.html> http://java.sun.com/products/jsp/faq.html <http://www.esperanto.org.nz/jsp/jspfaq.jsp> http://www.esperanto.org.nz/jsp/jspfaq.jsp <http://www.jguru.com/faq/index.jsp> http://www.jguru.com/faq/index.jsp <http://www.jspinsider.com> http://www.jspinsider.com ==========================================================================To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST". For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST". Some relevant FAQs on JSP/Servlets can be found at: http://archives.java.sun.com/jsp-interest.html http://java.sun.com/products/jsp/faq.html http://www.esperanto.org.nz/jsp/jspfaq.jsp http://www.jguru.com/faq/index.jsp http://www.jspinsider.com
