Tomcat 3.2.1 - Oracle 8i Connection

[sbaby95]

Hai, I had faced a problem when I was trying to connect Oracle database to my web page.
I used Jakarta-Tomcat 3.2.1 as my server, Java Servlet to develop system front-end, and Oracle 8i Personal Edition as my server site database.
I had downloaded the Oracle thin driver, classes12.zip, and placed it under \lib forder of Tomcat directory. I had also set the classpath to the driver.
I got the error message "Driver not found" or sometime "Class not found" when I test the web page.
Should I change the .zip to .jar in the \lib forder? Because other files have .jar. Actually I had tried to change it but still couldn't work.
The off-line database connection is work properly with normal Java application.

Why this could happen? Advise please.

Thank you.

 

[wushutwist]

Very simple solution, classes12.zip needs to be on your CLASSPATH.

 

[sbaby95]

c:\oracle\ora81\jdbc\lib\classes12.zip;c:\jakarta-tomcat-3.2.1\lib\classes12.zip;

this had been added in the classpath. but it didn't work..?

 

[wushutwist]

Show your code. Also you should only have the classes12.zip file on the CLASSPATH once.