WebSphere 6.1: Driver ojdbc14.jar loaded but Oracle classes still cannot be resolved

[michael_hk]

Hi,

I am using WebSphere AS 6.1. I have a JSP page that references classes connecting to Oracle. I have deployed the app successfully, but when I access the JSP page, I got the following error in the SystemOut.log


[11/16/06 10:48:11:310 HKT] 00000026 ServletWrappe E SRVE0068E: Uncaught exception thrown in one of the service methods of the servlet: /my/path/error.jsp. Exception thrown : javax.servlet.ServletException: Unresolved compilation problems:
The import oracle cannot be resolved
OracleTypes cannot be resolved
OracleCallableStatement cannot be resolved to a type


I am sure ojdbc14.jar is loaded (confirm using "Class Loader Viewer" in admin console).

Any idea how to resolve this error?

Thanks for your help.

Michael

[ess]

To me...it looks like the server is having problems locating the JDBC Driver.

you need to be sure that your application has been uploaded successfully to the server.

Also, I would recommend that you use NetBeans. I am not 100% sure if there is a plugin for WebSphere....but, NetBeans would take care of the directory structure of your application...import statements...etc. Plus..you can do a lot of testing on your application before deployment using NetBeans.

good luck.
Ess