try putting the classes12.zip path in the classpath. even i had initially put it in the lib directory and was getting the same error, then set it in the classpath and it worked.
Regards, Vikramjit Singh, Systems Engineer, GTL Ltd. Ph. 7612929-1031 -----Original Message----- From: Gare, Tref [mailto:[EMAIL PROTECTED]] Sent: Monday, May 13, 2002 1: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