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.