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