Skip to Main Content
Forums

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Cursor leakage when calling JDBC getMetaData().getTables on a connection

IanB21Jul 28 2015 — edited Aug 11 2015

Hi,

Calling

ResultSet rs = conn.getMetaData().getTables(null, null, null, new String[]{"TABLE", "ALIAS"});
        rs.close(); // this leaves cursor open

repeatedly on a connection will eventually cause an error

"ORA-1000 maximum open cursors exceeded"

Is this a defect in the JDBC driver?  We pool our connections, so they aren't closed and therefore we are hitting this issue.  We do not want to have to close the connection each time.

TIA

Ian

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 8 2015
Added on Jul 28 2015
#java-database-connectivity-jdbc
5 comments
5,656 views