| Tomcat 5 servlets will not communicate with Oracle 9.2 [message #92271] |
Thu, 13 May 2004 09:21  |
jsun
Messages: 2
Registered: May 2004
|
Junior Member |
|
|
I am running Tomcat 5 and writing servlets that communicate with a java program (JDK 1.4), which in turn opens a connection with an Oracle server (9.2).
The java program runs well as a standalone program - it makes the connection with the database and can perform queries/updates with success. As soon as I attach the java to the servlets I have written, the program gives the following error at the point in the program where a connection is made to the Oracle db. Stack trace is listed below:
I have tried changing to using a thin driver instead of the oci, but while that appears to compile and run correctly, it gives an error of oracle.net.TNSAddress.SOException at the same point (where the connection is established with oracle).
Any direction anyone can give me will be much much appreciated!
exception
javax.servlet.ServletException: Invoker service() exception
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:524)
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.java:216)
javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
root cause java.lang.UnsatisfiedLinkError: get_env_handle
oracle.jdbc.oci8.OCIEnv.get_env_handle(Native Method)
oracle.jdbc.oci8.OCIEnv.getEnvHandle(OCIEnv.java:70)
oracle.jdbc.oci8.OCIDBAccess.logon(OCIDBAccess.java:359)
oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:252)
oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:365)
oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:260)
java.sql.DriverManager.getConnection(DriverManager.java:523)
java.sql.DriverManager.getConnection(DriverManager.java:171)
CurrentConnection.makeConnection(CurrentConnection.java:24)
WebMain.getCctCostInfo(WebMain.java:20)
ShowCctCostInfo.doGet(ShowCctCostInfo.java:47)
ShowCctCostInfo.doPost(ShowCctCostInfo.java:74)
javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.java:466)
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.java:216)
javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856) |
|
|
|
| Re: Tomcat 5 servlets will not communicate with Oracle 9.2 [message #92331 is a reply to message #92271] |
Tue, 08 June 2004 07:19  |
Victor Hugo Ramacciotti
Messages: 1
Registered: June 2004
|
Junior Member |
|
|
Oracle 9.2 Java
04/06/04 18:43:58 java.lang.NullPointerException
04/06/04 18:43:58 at ar.gov.gcba.sai.web.acta.consultar.ConsultarActaAction.doQuery(ConsultarActaAction.java:74)
04/06/04 18:43:58 at ar.gov.gcba.sai.web.acta.consultar.ConsultarActaAction.processQuery(ConsultarActaAction.java:48)
04/06/04 18:43:58 at ar.gov.gcba.sai.web.frw.struts.AbstractCustomQueryAction$CustomProcess.customProcess(AbstractCustomQueryAction.java:81)
04/06/04 18:43:58 at ar.gov.gcba.sai.web.frw.process.AbstractCustomProcess.execute(AbstractCustomProcess.java:77)
04/06/04 18:43:58 at ar.gov.gcba.sai.web.frw.struts.AbstractCustomQueryAction.execute(AbstractCustomQueryAction.java:35)
04/06/04 18:43:58 at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:480)
04/06/04 18:43:58 at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
04/06/04 18:43:58 at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1420)
04/06/04 18:43:58 at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:520)
04/06/04 18:43:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
04/06/04 18:43:58 at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
04/06/04 18:43:58 at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:765)
04/06/04 18:43:58 at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:317)
04/06/04 18:43:58 at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:790)
04/06/04 18:43:58 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:208)
04/06/04 18:43:58 at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:125)
04/06/04 18:43:58 at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:192)
04/06/04 18:43:58 at java.lang.Thread.run(Thread.java:536)
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
