java.sql.SQLException: 用尽的 Resultset at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269) at oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:655) at oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java:680) at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482) at org.apache.jsp.ListChinesePlan$jsp._jspService(ListChinesePlan$jsp.java:195) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2003-03-26 16:25:34 StandardWrapperValve[debugjsp]: Servlet.service() for servlet debugjsp threw exception javax.servlet.ServletException: 用尽的 Resultset at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:463) at org.apache.jsp.ModifyMathPlan$jsp._jspService(ModifyMathPlan$jsp.java:664) at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202) at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382) at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
at oracle.jdbc.driver.ScrollableResultSet.getOracleObject(ScrollableResultSet.java:655)
at oracle.jdbc.driver.ScrollableResultSet.getString(ScrollableResultSet.java:680)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1482)
at org.apache.jsp.ListChinesePlan$jsp._jspService(ListChinesePlan$jsp.java:195)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
2003-03-26 16:25:34 StandardWrapperValve[debugjsp]: Servlet.service() for servlet debugjsp threw exception
javax.servlet.ServletException: 用尽的 Resultset
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:463)
at org.apache.jsp.ModifyMathPlan$jsp._jspService(ModifyMathPlan$jsp.java:664)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:107)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:202)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:382)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:474)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
while(rs.next())
{
s1=rs.getString(1);
f2=rs.getFloat(2);
}
检查是不是不小心把某个getXXX语句写在while循环外边了。这样rs已经用尽,当然不能再取了。
这是常见小失误嘛。
while(rs.next())
{
s1=rs.getString(1);
f2=rs.getFloat(2);
}
检查是不是不小心把某个getXXX语句写在while循环外边了。这样rs已经用尽,当然不能再取了。
这是常见小失误嘛。