Try renaming classes12.zip to classes12.jar this worked for me -----Original Message----- From: Lloyd Wiggins [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]] > 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]] > 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://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 > > ============================================================== > ============= > 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 > =========================================================================== 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 =========================================================================== 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
