aspose file tools*
The moose likes JDBC and the fly likes Error message : ORA-01000: Maximum number of open cursors reached ?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Error message : ORA-01000: Maximum number of open cursors reached ??" Watch "Error message : ORA-01000: Maximum number of open cursors reached ??" New topic
Author

Error message : ORA-01000: Maximum number of open cursors reached ??

Harish Muthuraman
Greenhorn

Joined: Jun 10, 2010
Posts: 11
When i tried to update the database after page submit, i got the error message "ORA-01000: Maximum number of open cursors reached".
what does this mean?
can any one help me??


With Regards
Harish M
Rene Larsen
Ranch Hand

Joined: Oct 12, 2001
Posts: 1179

I think you haven't closed your Statements, ResultSet and/or Connection i your code ??

Can you post the code which uses JDBC, and where you have the problem ??


Regards, Rene Larsen
Dropbox Invite
Gus Spier
Greenhorn

Joined: Dec 27, 2007
Posts: 5
Oracle documentation is your friend ...

Error Message: ORA-01000 maximum open cursors exceeded
Error Cause:
A host language program attempted to open too many cursors. The initialization parameter OPEN_CURSORS determines the maximum number of cursors per user.

Action:
Modify the program to use fewer cursors. If this error occurs often, shut down Oracle, increase the value of OPEN_CURSORS, and then restart Oracle.

swapnil kachave
Greenhorn

Joined: Feb 10, 2010
Posts: 27
Harish Muthuraman wrote:When i tried to update the database after page submit, i got the error message "ORA-01000: Maximum number of open cursors reached".
what does this mean?
can any one help me??


This error occur because in program you not handled statement object properly. if ( no. of statement object open > size of open_cursor variable of Oracle ) then this error is occur. If your doing transaction management then try to close the statement object who firing select query to your database or increase size of open_cursor in oracle.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Error message : ORA-01000: Maximum number of open cursors reached ??
 
Similar Threads
ORA-01000: maximum open cursors exceeded
Any way to over come "ORA-01000: maximum open cursors exceeded" ??
ORA-01000: maximum open cursors exceeded
ORA-01000 maximum open cursors exceeded
java.sql.SQLException: ORA-01000: maximum open cursors exceeded