OFBiz connection issue with Oracle

[Mukhtar]

Hi,

I'm working on OFBiz 9 version and we are getting connection errors.
Database: oracle

We got the below from log file and the issue remains until we restart the server what is the problem?
Anything would be appreciated

Thanks.

Geronimo is the configured transaction manager but there was an error getting a database Connection through Geronimo for the preservice datasource. Please check your configuration, class path, etc.
Exception: java.lang.RuntimeException
Message: Unable to setTransactionIsolation: ??????? ??????/??????: Socket read timed out
---- stack trace ---------------------------------------------------------------
java.lang.RuntimeException: Unable to setTransactionIsolation: ??????? ??????/??????: Socket read timed out
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:414)
org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:645)
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:355)
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56)
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:94)
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104)
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82)
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:268)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:374)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:345)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:423)
org.ofbiz.crm.miniCSC.MiniCSCServices.changeSimService(MiniCSCServices.java:3117)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:90)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:76)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:407)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:243)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:183)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:79)
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:249)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------------------

2014-02-04 15:37:10,360 [  ConnectionFactory.java:95 :ERROR]
---- runtime exception report --------------------------------------------------
There was an error getting a Minerva datasource.
Exception: java.lang.RuntimeException
Message: Unable to setTransactionIsolation: ??????? ??????/??????: Socket read timed out
---- stack trace ---------------------------------------------------------------
java.lang.RuntimeException: Unable to setTransactionIsolation: ??????? ??????/??????: Socket read timed out
org.ofbiz.minerva.pool.jdbc.xa.XAConnectionFactory.prepareObject(XAConnectionFactory.java:414)
org.ofbiz.minerva.pool.ObjectPool.getObject(ObjectPool.java:645)
org.ofbiz.minerva.pool.jdbc.xa.XAPoolDataSource.getConnection(XAPoolDataSource.java:355)
org.ofbiz.entity.transaction.MinervaConnectionFactory.getConnection(MinervaConnectionFactory.java:56)
org.ofbiz.entity.jdbc.ConnectionFactory.tryGenericConnectionSources(ConnectionFactory.java:92)
org.ofbiz.geronimo.GeronimoTransactionFactory.getConnection(GeronimoTransactionFactory.java:100)
org.ofbiz.entity.transaction.TransactionFactory.getConnection(TransactionFactory.java:104)
org.ofbiz.entity.jdbc.ConnectionFactory.getConnection(ConnectionFactory.java:82)
org.ofbiz.entity.jdbc.SQLProcessor.getConnection(SQLProcessor.java:268)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:374)
org.ofbiz.entity.jdbc.SQLProcessor.prepareStatement(SQLProcessor.java:345)
org.ofbiz.entity.jdbc.SQLProcessor.executeQuery(SQLProcessor.java:423)
org.ofbiz.crm.miniCSC.MiniCSCServices.changeSimService(MiniCSCServices.java:3117)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:585)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:90)
org.ofbiz.webapp.event.JavaEventHandler.invoke(JavaEventHandler.java:76)
org.ofbiz.webapp.control.RequestHandler.runEvent(RequestHandler.java:407)
org.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:243)
org.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:183)
org.ofbiz.webapp.control.ControlServlet.doPost(ControlServlet.java:79)
javax.servlet.http.HttpServlet.service(HttpServlet.java:615)
javax.servlet.http.HttpServlet.service(HttpServlet.java:688)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.ofbiz.webapp.control.ContextFilter.doFilter(ContextFilter.java:249)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
java.lang.Thread.run(Thread.java:595)
--------------------------------------------------------------------------------

2014-02-04 15:37:10,360 [  ConnectionFactory.java:84 :ERROR] ******* ERROR: No database connection found for helperName "preservice"
2014-02-04 15:37:10,360 [    MiniCSCServices.java:3125:INFO ] MK Exception = Unable to esablish a connection with the database. Connection was null!