ORA-01000 maximum open cursors exceeded
Date: 8 Sep 2003 01:12:30 -0700
Message-ID: <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 Mon Sep 08 2003 - 10:12:30 CEST