problems connecting with jdbc

[thomgreen]

I created a java program named connect.java I then ran:
javac connect.java
::This ran successfully

I then ran:
java connect bdonnetdev.wcomnet.com 1521 dbdev thin
::This ran with the following errors:
Failed to load oracle driver
java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

Environment variable is as follows:
CLASSPATH=/u01/app/oracle/product/8.1.7/jdbc/lib/class12.zip:/u01/app/oracle/product/8.1.7/jdbc/lib/nls_charset12.zip:/u01/app/oracle/product/8.1.7/sqlj/demo:/u01/app/oracle/product/8.1.7/sqlj/lib/translator.zip:/u01/app/oracle/product/8.1.7/sqlj/lib/runtime12.zip:/opt/home/oracle

(1)all *.zip files are in the right places.
(2)successfully loaded and tested jvm

 

[pazhanikanthan]

What Server are u using???? Is it Tomcat???

If it is so, then u need to put the classes12.zip in the
D:\Tomcat\shared\lib folder where
D:\Tomcat is teh folder where I have installed Tomcat.

 

[thomgreen]

thnks. I got the problem fixed. I did a stupid thing and added 'class12.zip' to CLASSPATH instead of 'classes12.zip'.