java.sql.SQLRecoverableException: Closed Connection When Running Application (Doc ID 1642867.1)

Last updated on MARCH 08, 2017

Applies to:

JDBC - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.1.7.0 version, SOA Fusion Application

When attempting to call a custom J2EE application deployed to WebLogic server, the following error occurs:

2014-03-24 01:15:28 ERROR DirectService:73 - javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not load an entity: [xxxxxx]
javax.ws.rs.WebApplicationException: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not load an entity: [xxxxx]
....
Caused by: org.hibernate.exception.JDBCConnectionException: could not load an entity: [xxxxxx]
...
Caused by: java.sql.SQLRecoverableException: Closed Connection
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3560)
at oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:3461)
at oracle.jdbc.OracleConnectionWrapper.prepareStatement(OracleConnectionWrapper.java:115)
at weblogic.jdbc.wrapper.XAConnection.prepareStatement(XAConnection.java:639)
at weblogic.jdbc.common.internal.ConnectionEnv.makeStatement(ConnectionEnv.java:1575)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1302)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1216)
at weblogic.jdbc.common.internal.ConnectionEnv.getCachedStatement(ConnectionEnv.java:1209)
at weblogic.jdbc.wrapper.Connection.prepareStatement(Connection.java:550)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1573)
at org.hibernate.loader.Loader.doQuery(Loader.java:696)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
at org.hibernate.loader.Loader.loadEntity(Loader.java:1881)
... 47 more




Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms