Cannot Use External Connection Pooling After Upgrading To 10.1.3.5 OC4J (Doc ID 1328264.1)

Last updated on OCTOBER 08, 2014

Applies to:

Oracle TopLink - Version 10.1.3.5 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Mar-2013***

Symptoms

A J2EE application previously installed on 10.1.2.3 OC4J is deployed into 10.1.3.5 OC4J .
Using 10.13.5 Toplink, this application is configured to use the External Connection Pools in Toplink.

With external connection pool configuration, the following exception occurs
randomly when executing a SQL statement via Toplink :

1. if the JDBC connection is retrieved from a native datasource :

Caused by: java.sql.SQLException: Attempt to use a closed handle : 'oracle_jdbc_driver_LogicalConnection_Proxy@46d208'.
at oracle.oc4j.sql.spi.ConnectionHandle.oc4j_intercept(ConnectionHandle.java:283)
at oracle.oc4j.sql.proxy.SQLBCELProxy.oc4j_intercept(SQLBCELProxy.java:303)
at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.setNull(PreparedStatementBCELProxy.java:50)]

 
2.  if the the JDBC connection is retrieved from an OC4J  managed datasource :

Caused by: java.sql.SQLException: SQL wrapper has been closed!
at oracle.oc4j.sql.proxy.SQLBCELProxy.oc4j_intercept(SQLBCELProxy.java:296)
at oracle.oc4j.sql.proxy.PreparedStatementBCELProxy.setObject(PreparedStatementBCELProxy.java:318)
at oracle.toplink.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall(DatabasePlatform.java:1497)
at oracle.toplink.oraclespecific.Oracle9Platform.setParameterValueInDatabaseCall(Oracle9Platform.java:355)
at oracle.toplink.internal.databaseaccess.DatabasePlatform.setParameterValueInDatabaseCall(DatabasePlatform.java:1522)



Those exceptions indicate that though a statement has been closed,  Toplink is executing this  statement.


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