jdbc driver in Java Servlet/Tomcat doesn't load

[mydavor]

The piece of code loading oracle.jdbc.driver.OracleDriver succeedes in JAVAApi but not within a Servlet over Tomcat:

System.out.println("Loading the driver");
Class.forName("oracle.jdbc.driver.OracleDriver");
// Getting the connection
System.out.println("Getting the connection to demo@demo");

When called from a servlet it generates an exception:
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

The other prints: Getting the connection to demo@demo
Both programs have
import java.sql.*
use same CLASSPATH set in ControlPanel
run on the same box

Can you help ?

 

[prosper]

My servlet is stored in the following folder
I:\tom\webapps\servlet2\WEB-INF\classes
My mysql-connector-java-3.0.9-stable-bin.jar is stored in
I:\tom\webapps\servlet2\WEB-INF\lib
Java application needs classpath.
Tomcat needs classpath and jar file in the lib directory for your driver connecting to the database

 

[sedj]

Add classes12.jar (NOT classes12.zip) to TOMCAT_HOME/common/lib

 

[mydavor]

Thanks, it worked out

 

[sedj]

Good... its something to bear in mind - that tomcat5 will not load .zip files like tomcat4 would.