Hai all, i made a web site where evry time the data is retrived from the database and shown to the user, but when browsing id done for for a long time then i get the SQLEXception and the page is not displayed. Request you all to suggest for this SQLException thanx 4 all prabhakar ----------------------------------------------------------------- SQLException in doPost: java.sql.SQLException: ORA-01000: maximum open cursors exceeded java.sql.SQLException: ORA-01000: maximum open cursors exceeded at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java) at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java) at oracle.jdbc.ttc7.Oopen.receive(Oopen.java) at oracle.jdbc.ttc7.TTC7Protocol.open(TTC7Protocol.java) at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java) at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java) at ShoppingCategoryWise.doGet(ShoppingCategoryWise.java:436) at javax.servlet.http.HttpServlet.service(HttpServlet.java:499) at javax.servlet.http.HttpServlet.service(HttpServlet.java:588) at sun.servlet.http.HttpServerHandler.sendResponse(HttpServerHandler.java:165) at sun.servlet.http.HttpServerHandler.handleConnection(HttpServerHandler.java:121) at sun.servlet.http.HttpServerHandler.run(HttpServerHandler.java:90) at java.lang.Thread.run(Unknown Source)
somewhere in your code, you are creating statements, and not closing them. This causes cursors to remain open and accumulate, until finally, the number of open cursors exceeds the maximum set by the Database. So you'll have to find all the statements in your code and make sure you call statement.close() on every one. Jamie
