javax.servlet.ServletException: 用尽的 Resultset

mcsong 07-05-02

javax.servlet.ServletException: 用尽的 Resultset
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:848)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.showktintroduce_jsp._jspService(org.apache.jsp.showktintroduce_jsp:79)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)


root cause

java.sql.SQLException: 用尽的 Resultset
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:655)
oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java:680)
oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
org.apache.jsp.showktintroduce_jsp._jspService(org.apache.jsp.showktintroduce_jsp:66)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:291)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

banq
2007-05-08 11:26

是啊,你写程序用完了,你不能简单地大量查询数据,参考有关google资料