File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Any way to over come Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Any way to over come "ORA-01000: maximum open cursors exceeded" ??" Watch "Any way to over come "ORA-01000: maximum open cursors exceeded" ??" New topic
Author

Any way to over come "ORA-01000: maximum open cursors exceeded" ??

Harish Muthuraman
Greenhorn

Joined: Jun 10, 2010
Posts: 11
Is there any way to overcome the exception - "ORA-01000: maximum open cursors exceeded"?
can you suggest any way that i can adopt to overcome this.
Can this be overcome by any strategic implementation in java?


With Regards
Harish M
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

You need to find out if your application needs more connections than your Oracle database currently allows. If that is the case then you need to increase this amount (see the docs as to how to do this), or decrease the amount allowed in your connection pool if you are using one and if you cannot reconfigure Oracle.

You also need to check you don't have poorly written JDBC code. Do you always close connections immediately after you are finished with them in a finally block?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Any way to over come "ORA-01000: maximum open cursors exceeded" ??