Multithreaded Application Fails With "The Connection Is Closed" After Upgrading UCP to 12.x or Above
(Doc ID 2696313.1)
Last updated on OCTOBER 17, 2022
Applies to:
Universal Connection Pool - Version 12.1.0.1.0 and laterInformation 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 |