This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
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


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
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: 186
Looks like the database server is expiring connections which idle for too long. Do you have any "keepAlive" thread running?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Hibernate -WARN : 19:22:25 - SQL Error: 17143, SQLState: null
 
Similar Threads
org.hibernate.exception.LockAcquisitionException
Deploying Hibernate 3 application in Jboss 4.0.2
Could not find the main class. Program will exit.
Error in opening connection
JDBC Connection