ORA-01000 max cursors error received using Oracle and JDBC

From: <ckuczbor_at_my-deja.com>
Date: Tue, 29 Jun 1999 20:42:46 GMT
Message-ID: <7lbb44$qvb$1@nnrp1.deja.com>

We are receiving the ORA-01000 (maximum open cursors exceeded) error when running a load test on our web application. We are using JAVA servlets, Oracle 7.3.4.2, JDBC thin driver, IBM WebSphere Application Server (using their DB connection pool manager), and Netscpape Enterprise Web Server.

It appears that the cursors are not being closed or released when the servlet is finished getting the data. We have the Oracle max cursor configuration parameter set to 400. However, we do not want to increase this any higher. Our problem is that the cursors are not being released when the SQL call is complete, and therefore the number of open cursors keeps growing. We want the cursors to be closed or released when the servlet has completed all processing.

Has anyone else had this issue and what was the final solution?

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Jun 29 1999 - 15:42:46 CDT