Not sure why I am seeing this error occasionally. I copied it below. Thanks.
[b][b]WARN : 19:22:25 - SQL Error: 17143, SQLState: null ERROR : 19:22:25 - Connection validation failed : ORA-02396: exceeded maximum idle time, please connect again
ERROR : 19:22:25 - (cdsar.dataobjects.entityobjects.ClsEntCtrlcard:61) Cannot open connection org.hibernate.exception.GenericJDBCException: Cannot open connection at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLState Converter.java:126) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:6 6) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:5 2) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:449 ) at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:167)
at org.hibernate.jdbc.JDBCContext.connection(JDBCContext.java:142) at org.hibernate.transaction.JDBCTransaction.begin(JDBCTransaction.java:85) at org.hibernate.impl.SessionImpl.beginTransaction(SessionImpl.java:1354) at cdsar.dataobjects.entityobjects.AbstractEntityDao.select(AbstractEntityDao.jav a:48) at cdsar.dataobjects.ClsDataObjectCtrlcard.findRecordS2TCtrlcard2eci140(ClsDataOb jectCtrlcard.java:213) at cdsar.businessobjects.ClsbussProcessObjEci140.getControlCard(ClsbussProcessObj Eci140.java:908) at cdsar.businessobjects.ClsbussProcessObjEci140.releaseEnrollmentHoldseci140(Cls bussProcessObjEci140.java:518) at cdsar.businessobjects.ClsbussProcessObjEci140.processForReleasingEnrollmentHol dseci140(ClsbussProcessObjEci140.java:469) at cdsar.businessobjects.ClsbussProcessObjEci140.execute(ClsbussProcessObjEci140. java:443) at cdsar.servlets.RunBatch.executeBusinessProcess(RunBatch.java:64) at cdsar.servlets.RunBatch.doPost(RunBatch.java:47) at javax.servlet.http.HttpServlet.service(HttpServlet.java:763) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatc her.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletReque stDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandle r.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler. java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler .java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadH andler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcc eptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHan dler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSoc ketAcceptHandler.java:879) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableReso urcePooledExecutor.java:298) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: Connection validation failed : ORA-02396: exceeded maxi mum idle time, please connect again
at oracle.oc4j.sql.spi.ConnectionHandle.throwSQLException(ConnectionHandle.java:6 98) at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_validate(ConnectionHandle.java:680) at oracle.oc4j.sql.spi.OracleConnectionHandle.oc4j_validate(OracleConnectionHandl e.java:158) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:281) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:200) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:142) at oracle.oc4j.sql.ManagedDataSource.getConnection(ManagedDataSource.java:127) at org.hibernate.connection.DatasourceConnectionProvider.getConnection(Datasource ConnectionProvider.java:92) at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:446 ) ... 27 more Caused by: java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect a gain
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:138) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:316) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:282) at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:639) at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113) at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431) at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java :1029) at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1 126) at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1654) at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_validate(ConnectionHandle.java:664) ... 34 more INFO : 19:22:25 - (cdsar.dataobjects.entityobjects.ClsEntCtrlcard:67) Done with select(..., ...)[/b][/b]
|