| 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
|
 |
 |
|
|
subject: Any way to over come "ORA-01000: maximum open cursors exceeded" ??
|
|
|