Re: ORA-01000 maximum open cursors exceeded

Deepali ,

  I would select your results into a java object(i.e.hash table) in a serverlet then close the cursor.

"Deepali Gupta" <deepaligupta5_at_yahoo.co.uk> wrote in message news:c125a682.0309080012.58138bda_at_posting.google.com...
> We are encountering the problem of "maximum open cursors exceeded"
> exception.
>
> Our web based system uses jdk1.3 as frontend with Oracle 9i as backend
> and Oracle JDBC Driver version - 9.0.2.0.0 for connectivity.
>
> Connection pooling is being used and the resultset is fetched in the
> functions and returned to JSPs where the functions are being called.
>
> As per the articles on the net this exception occurs as a result of
> not closing the prepared statements/ statements/ resultSets.
>
> The problem is how do we close the statements as we are using the
> resultsets in the JSPs. We cannot close the prepared statements/
> statements/ resultSets in the JSPs as we cannot access them because
> they are local to the respective functions. Nor can we close them in
> the functions as we are retrieving the records from the resultsets in
> our JSPs.
>
> Kindly reply with a solution as soon as possible.
Received on Wed Dec 10 2003 - 03:28:26 CET