This week's book giveaway is in the OCMJEA forum. We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line! See this thread for details.
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?