Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQLException

 
varkala prabhakar
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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)
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
varkala prabhakar
Ranch Hand
Posts: 54
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dear Robertson,
thanx , my exception is solved with ur v.ble reply.
cheers
prabhakar
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic