UCP Does Not Close Statement Or ResultSet When Connection Is Closed

(Doc ID 2348643.1)

Last updated on JANUARY 18, 2018

Applies to:

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

Symptoms

With UCP, the statement object created using the UCP managed connection reports as closed when the Connection is closed; but the wrapped java.sql.Statement object does not get closed.
Since the real statement is not closed, the ResultSet is not closed either.

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