[mrice999]

I’m having problems with MyEclipse recognizing the ojdbc14.jar file located in my project’s Java Build Path -> Libraries.

Am I missing something else?

I have had this working for a long time and had to switch projects and workspaces. Now can’t seem to get it working.

The database explorer works fine and my Java classes don’t give my any errors when importing any Oracle objects.

The error happens when my servlet tries to access an oracle/java method just as forName().

Would love some help.

Melodie.

[Loyal Water]

You mean your jar is not recognized ? Adding it to your build path should do the trick. Can you switch to new workspace, create a new project, add the ojdbc.jar to it and check if you run into same issues.

Also, what is the error that you are getting ?

[mrice999]

Yes, I have added it to my build path. The error I’m getting is as follows:

ava.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1358)
at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1204)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at database.dbConnect.openConnection(dbConnect.java:103)
at commands.RetrieveLookupInfo.retrieveCityInfo(RetrieveLookupInfo.java:122)
at commands.RetrieveLookupInfo.execute(RetrieveLookupInfo.java:79)
at servlets.EERServlet.doPost(EERServlet.java:208)
at servlets.EERServlet.doGet(EERServlet.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)
java.lang.NullPointerException
at database.dbConnect.setQuery(dbConnect.java:180)
at commands.RetrieveLookupInfo.retrieveCityInfo(RetrieveLookupInfo.java:124)
at commands.RetrieveLookupInfo.execute(RetrieveLookupInfo.java:79)
at servlets.EERServlet.doPost(EERServlet.java:208)
at servlets.EERServlet.doGet(EERServlet.java:85)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:216)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
at java.lang.Thread.run(Unknown Source)

I have the reference to the oracle driver in my classpath also. Like I said before, this was working for a long time but made some changes and dorked it somehow.’

Thanks much for the response!

Melodie

[Loyal Water]

Are you working with Tomcat ? Can you make sure this jar is present under common/lib.

[Author]

Posts