• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 351
  • Last Modified:

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
0
carlino70
Asked:
carlino70
  • 4
  • 3
1 Solution
 
CEHJCommented:
Looks like you might have your connection pool and cache misconfigured now
0
 
carlino70Author Commented:
there is a method to test the connection from the pool to the Oracle database?
0
 
CEHJCommented:
I'm not sure. The cache called 'hisrdbora' is not available under that name now
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
carlino70Author Commented:
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
0
 
CEHJCommented:
Not sure i'm afraid
0
 
carlino70Author Commented:
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
0
 
CEHJCommented:
:)
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now