Why am I getting an “ORA-01000: maximum open cursors exceeded” error, even though I closed all ResultSet, Statement, and Connection objects?
This is an Oracle issue. According to Oracle’s documentation, dynamic cursors can remain open from run to run in a session and are not closeable when a procedure closes. To work around this issue, you can increase the number of open cursors allowed in the database or you can reset the connection pool (close and reopen database connections in the connection pool). To reset the connection pool, you can untarget and retarget the connection pool using the Administration Console. You can also use the reset() method through the JMX API or the RESET_POOL command on the WebLogic Server command line interface. See Programming WebLogic JDBC for more information.
Related Questions
- When I try to activate Rationale I get the message "Unexpected error: The underlying connection was closed: An unexpected error occurred on a send...". What can I do?
- Why am I getting an "ORA-01000: maximum open cursors exceeded" error, even though I closed all ResultSet, Statement, and Connection objects?
- Geomorph stops with an error when I try to open a new document, after having closed all the documents. What can be done?
