Hi all,

I also was trying to depoly a simple JSP page with a SQL call to an oracle instance, but I keep getting the "package oracle.jdbc does not exist" or simiar errors.

I used Eclipse IDE and deployed to Tomcat server, which I thought might be the problem, so I downloaded and installed Sun's Glassfish server. The same problem persisted.

I followed instructions/advice and added the file C:\oracle\product\10.2.0\db_1\jdbc\lib\classes12.jar to my build path. Would not work.

Finally, I happened to notice a warning from eclipse:
"Classpath entry C:/oracle/product/10.2.0/db_1/jdbc/lib/classes12.jar will not be exported or published. Runtime ClassNotFoundExceptions may result."

If you see this warning, right mouse it and choose Quick Fix - a dialog offers two quick fixes, the first one will be:

"Mark the associated raw classpath entry as publish/export dependency."

With this option highlighed click Finish - this will remove the warning and resolve this problem.

Once I did that my jsp page worked correctly in either Tomcat or Glassfish. I tried it on several other projects and it also worked.

I hope this was helpful - it worked for me.

JC