Getting error "java.sql.SQLException: Attempt to set connection harvestable to false but the connection is already closed" in the logs

(Doc ID 2396856.1)

Last updated on MAY 10, 2018

Applies to:

Oracle WebLogic Server - Version 10.3.6 and later
Information in this document applies to any platform.

Symptoms

Intermittently seeing the following error in the Weblogic server log:

[________,[ACTIVE] ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)']:E: 06 00:00:13.546: ProfileDAOImpl.getMemberFFNumbers: DB Error while executing query :
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Attempt to set connection harvestable to false but the connection is already closed.
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:630)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:695)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:722)
at org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:772)
at org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
at com.epsilon.citi.tygr.dao.ProfileDAOImpl.getMemberFFNumbers(ProfileDAOImpl.java:119)
at com.epsilon.citi.tygr.manager.ProfileManagerImpl.getMemberFFNumbers(ProfileManagerImpl.java:143)
at com.epsilon.citi.tygr.controller.ProfileController.getMbrFFNumbers(ProfileController.java:128)

at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:617)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:397)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:346)
Caused by: java.sql.SQLException: Attempt to set connection harvestable to false but the connection is already closed.
at weblogic.jdbc.wrapper.Connection.setConnectionHarvestable(Connection.java:1556)
at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:649)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:570)
at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:563)
at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
... 52 more

Changes

 

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