We recently migrated your project from Weblogic 9.2 to Weblogic 10.3.After this migration we are sprodically getting the below exception for SQL queries
org.springframework.dao.RecoverableDataAccessException: PreparedStatementCallback; SQL []Closed Connection; nested exception is java.sql.SQLRecoverableException: Closed Connection
at org.springframework.jdbc.support.SQLExceptionSubclassTranslator.translate(SQLExceptionSubclassTranslator.java:82)
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:237)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:674)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:706)
Listed below are your system configuration
WebLogic Version: 10.3.3 [32-Bit installer]
Weblogic running on Solaris Sparc OS 10, 64-Bit
Weblogic JDK type/version: SUN, JDK 160_26
JDBC Driver file:
ojdbc6.jar [2152051 bytes]
Oracle DB Version: 11.2.0.2
Oracle DB running on Solaris Sparc OS 10, 64-Bit
Spring :2.0
Any help will be appreciated
