Message:
A new issue has been created in JIRA.
---------------------------------------------------------------------
View the issue:
http://objectstyle.org/jira/secure/ViewIssue.jspa?key=CAY-255
Here is an overview of the issue:
---------------------------------------------------------------------
Key: CAY-255
Summary: ORA-01000: maximum open cursors exceeded
Type: Bug
Status: Assigned
Priority: Major
Project: Cayenne
Components:
Cayenne Core Library
Versions:
1.1
Assignee: Andrus Adamchik
Reporter: Beth Williams
Created: Wed, 29 Dec 2004 4:07 PM
Updated: Wed, 29 Dec 2004 4:07 PM
Environment: Running JBoss 3.2.5 locally on Windows 2000, Oracle DB 9.2.0.3
Description:
We are receiving the following error: "ORA-01000: maximum open cursors exceeded" when executing stored procedures. Our OPEN_CURSORS variable is set to 500 and it appears that once this number is reached the error occurs. We have not been able to find leaks within the PL/SQL. We have tested this with stand alone PL/SQL by executing the same package 5000 times with no problems. It was only when we ran through JBoss with Cayenne that we had the problem. It appears that Cayenne may not be properly closing the ResultSet and Statement objects when dealing with stored procedures. Is this something you've seen before? I will upload our mapping XML along with our procedures code for your review. Let me know if you need any other information. Thanks in advance.
Beth
---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.
If you think it was sent incorrectly contact one of the administrators:
http://objectstyle.org/jira/secure/Administrators.jspa
If you want more information on JIRA, or have a bug to report see:
http://www.atlassian.com/software/jira
This archive was generated by hypermail 2.0.0 : Wed Dec 29 2004 - 16:08:03 EST