Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
Harish Muthuraman
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic