My Oracle Support Banner

Invoking OracleDatabaseMetaData.getColumns Leaks Cursors If Implicit Statement Cache Is Enabled (Doc ID 2689134.1)

Last updated on AUGUST 09, 2023

Applies to:

JDBC - Version 12.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Invoking OracleDatabaseMetaData.getColumns() leaks cursors if implicit statement cache is enabled with JDBC drivers 12.2.0.1 (vanilla) and above. There is no leak using JDBC driver v12.1.0.2 (vanilla) or if implicit statement caching is turned off. A cursor dump shows that the cursors are opened by the internal implementation of the driver. Closing the ResultSet returned by the method does not close the cursor, nor is ResultSet.getStatement().close().

sample stack:

Changes

 

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.