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?