Check whether previous java programs which were using JDBC class, were closing Statement objects are not i.e stmt.close(). May be just shut down Oracle once and try running you program again. Take care that before exiting any Java Program which is making JDBC Calls, Statement object should be closed.
Regards Nitin.
Kenia Nimesh wrote:
In one of our program we are opening 3 ResultSet(cursors) at a given point of time.The queries are retreving records from the database.If there are many records retreived we are getting the foll error.We have Oracle 8.0.5 as our database.The maximum OPEN_CURSORS set in init(DBinstance).ora is 120 still we are getting the error.Please help me.Thanks in advanceNimesh
java.sql.SQLException: ORA-01000: maximum open cursors exceeded
