Re: Open Cursors in Java

See here http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:3512824755435 if it is of any help to you.

HTH,
KT

karlosandres_at_hotmail.com (Carlos) wrote in message news:<860ae4b4.0308110701.5d89c327_at_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 - 15:11:14 CDT