File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null" Watch "Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null" New topic
Author

Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null

S Branch
Greenhorn

Joined: Jan 07, 2013
Posts: 8
Not sure why I am seeing this error occasionally. I copied it below.
Thanks.

[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]


Emanuel Kadziela
Ranch Hand

Joined: Mar 24, 2005
Posts: 187
Looks like the database server is expiring connections which idle for too long. Do you have any "keepAlive" thread running?
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null