I am preparing my personal web sites with Java. My application runs well at IBM WebSphere Test Environment within VisualAge for Java, and without any problem in loading from and storing into Oracle 8i database. But when I deployed my code into Tomcat3.3, the DBManager can not find a driver in "Class.forName(oracle.jdbc.driver.OracleDriver)". The Exception caught at "Class.forName(oracle.jdbc.driver.OracleDriver)" is ClassNotFoundException. So I run a test on the database connection in JBuilder, which should use the same environment as Tomcat in CLASSPATH, my code also works in loading from and storing into Oracle 8i database. So What is wrong with my environment setting? Can any one help me?
I have set the Oracle driver into my classpath in in "Control Panel/System/Advanced/Environrmental Variables" in Windows 2000 as "D:\Oracle\Ora81\jdbc\lib\classes111.zip".