Link to home
Start Free TrialLog in
Avatar of carlino70
carlino70Flag for Argentina

asked on

Problem with connection between APP JAVA and Oracle Database.

Hi experts, I try to access from an application to the Oracle database, but I detect this error in the logs:
host:/cots/ENet/log> vi stdout.log
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:619)
geh.data.ViewException: Unable to perform operation
    at geh.appserver.DataBroker.getHISRFrequencyData(DataBroker.java:9567)
    at geh.appserver.AppServerController.getHISRFrequencyData(AppServerController.java:11398)
    at geh.appserver.AppServer.getHISRFrequencyData(AppServer.java:8670)
    at geh.servlet.AdapterServlet.invokeCommand(AdapterServlet.java:2241)
    at geh.servlet.AdapterServlet.doPost(AdapterServlet.java:163)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:760)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:198)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:144)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:209)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:138)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
    at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:197)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
    at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2460)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:132)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
    at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:118)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:116)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:593)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:126)
    at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:595)
    at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:432)
    at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:954)
    at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:152)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
    at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
    at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
    at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
    at java.lang.Thread.run(Thread.java:619)

Open in new window

and:
host:/cots/ENet/log> vi enternetserver.log.1
12 Mar 11:42:10,116 [Thread-25890]: DEBUG geh.util.database.DBPoolFacade - GETTING CONNECTION FROM POOL: hisrdbora
12 Mar 11:42:10,116 [Thread-25890]: DEBUG geh.util.database.DBPoolFacade - ERROR GETTING NUMBER OF AVAILABLE CONNECTIONS FOR CACHE [hisrdbora]
java.sql.SQLException: Connection Cache with this Cache Name does not exist
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
    at oracle.jdbc.pool.OracleConnectionCacheManager.getNumberOfActiveConnections(OracleConnectionCacheManager.java:621)
    at geh.util.database.DBPoolFacade.getCheckedOutConnections(DBPoolFacade.java:1859)
    at geh.util.database.DBPoolFacade.access$2100(DBPoolFacade.java:46)
    at geh.util.database.DBPoolFacade$5.doExecute(DBPoolFacade.java:1099)
    at geh.util.ExecutionTimer$2.run(ExecutionTimer.java:103)
    at java.lang.Thread.run(Thread.java:619)
12 Mar 11:42:10,116 [Thread-25890]: ERROR geh.util.database.DBPoolFacade - UNABLE TO GET CONNECTION FROM DATABASE POOL hisrdbora
java.sql.SQLException: Oracle Pool is null...Oracle unavailable
    at geh.util.database.DBPoolFacade.getConnectionFromPool(DBPoolFacade.java:1899)
    at geh.util.database.DBPoolFacade.access$2200(DBPoolFacade.java:46)
    at geh.util.database.DBPoolFacade$5.doExecute(DBPoolFacade.java:1101)
    at geh.util.ExecutionTimer$2.run(ExecutionTimer.java:103)
    at java.lang.Thread.run(Thread.java:619)
12 Mar 11:42:10,117 [Connection Ping Timer for Pool: hisrdbora]: ERROR geh.util.database.DBPoolFacade - UNABLE TO OBTAIN CONNECTION, RETURNED NULL

Open in new window

Could you please guide me in finding the solution?
How I can test a connection from Java to the Oracle database?
Note: In the Oracle server, a name change and IP was performed. After that the application could not connect.
Thanks
Regards
ASKER CERTIFIED SOLUTION
Avatar of CEHJ
CEHJ
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of carlino70

ASKER

there is a method to test the connection from the pool to the Oracle database?
I'm not sure. The cache called 'hisrdbora' is not available under that name now
sorry, but "hisrdbora" would be on the app server or on oracle server?

I'm not a Java developer, and I did not do the installation.

Thankyou
Not sure i'm afraid
The connection between APP and the Oracle database, It is configured to read the service_name parameter. I added a second option of service_name and the connection was established.
Thankyou
:)