HELP ORA01000 maximum open cursors exceeded

This is an urgent request for help!

We are using webMethods 4.6 with Service Pack 2 and we have some java services that use connection pooling and execute database queries. We have 15 maximum pool connections. We have over 500 set as the max cursor limit. We have been checking the code to make sure there is a finally block which closes the resultset and the statement object thinking this may be our leak - but we do not see any open resultsets being left and WE ARE STILL GETTING THIS ERROR (ORA-01000: maximum open cursors exceeded).

Help! Does anyone know how to resolve this issue?

Are you explicitly closing the connections & resultsets??


Depending on your environment, you may need to have the DBA increase the value of OPEN_CURSORS in the Oracle server, if it turns out that your code is functioning correctly and you still receive the error.