SQLRecoverableException: Closed Connection

1,111 views
Skip to first unread message

Erik van Ingen

unread,
Nov 3, 2014, 4:19:29 PM11/3/14
to hika...@googlegroups.com, Erik van Ingen
Our app is given this message:

org.hibernate.exception.JDBCConnectionException: could not inspect JDBC autocommit mode 
java.sql.SQLRecoverableException: Closed Connection 
oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:4333) 
com.zaxxer.hikari.proxy.ConnectionJavassistProxy.getAutoCommit(ConnectionJavassistProxy.java) 
org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.isAutoCommit(LogicalConnectionImpl.java:322) 

We are on Hiraki 2.0.1 with this config:

What could we do in order to prevent this behavior?


Brett Wooldridge

unread,
Nov 3, 2014, 5:56:01 PM11/3/14
to hika...@googlegroups.com, Erik.V...@fao.org
See this thread, for example, as the most likely cause.

"it was because a session close statement was missing from the finally block and so whenever we had an exception, the session was not closed and and became reusable for an incoming transaction. Thus this session was at times available to 2 different threads leading to above inconsistent behavior. "

There can be other causes for this exception, but this is the most likely.
Reply all
Reply to author
Forward
0 new messages