My Oracle Support Banner

Multithreaded Application Fails With "The Connection Is Closed" After Upgrading UCP to 12.x or Above (Doc ID 2696313.1)

Last updated on FEBRUARY 10, 2021

Applies to:

Universal Connection Pool - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

A multithreaded application that had been running without problems in an environment using UCP version 11.x experiences a connection error after upgrading UCP to 12.x or above:

Caused by: java.sql.SQLException: The connection is closed: The connection is closed
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:441)
  at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:425)
  at oracle.ucp.jdbc.proxy.StatementProxyFactory.invoke(StatementProxyFactory.java:363)
  at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:194)



This is a distinct issue from the one addressed in unpublished UCP bug 21187539. That bug is fixed beginning in UCP version 12.2, but the error in this case persists even when using that version or above.

Changes

 The issue appears after upgrading UCP from version 11.x or lower, to version 12.x or higher.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.