Open Cursors in Java

From: Carlos <karlosandres_at_hotmail.com>
Date: 11 Aug 2003 08:01:45 -0700
Message-ID: <860ae4b4.0308110701.5d89c327@posting.google.com>

Hi everybody.

I have a problem with open cursors in Java. I'm connecting to Oracle with a jdbc driver and I've found the
next error: "Max Open Cursors Exceeded". I've read many messages about this issue but this error follows me.

In some messages people tell that you have to close the ResultSet and the Statement. I've done it.

Other messages talk about loops and that you have to close the ResultSet in each iteratio of the loop. I've done it.

Somewhere I read that the cursor is freed not when close is called, but only if the resultset is garbage collected.

I'm desesperated. Using the v$open_cursor view I can see the querys which open the cursors but I think that are internal cursors. I'm sure that I close all
the ResultSets ant Statements.

Anybody could help me?

Thanks in Advance,
Karlos. Received on Mon Aug 11 2003 - 10:01:45 CDT