日期:2014-05-18  浏览次数:20619 次

大家帮帮我这个菜鸟吧
严重:   Servlet.service()   for   servlet   jsp   threw   exception
java.sql.SQLException:   [Microsoft][SQLServer   2000   Driver   for   JDBC]ResultSet   can   not   re-read   row   data   for   column   2.
at   com.microsoft.jdbc.base.BaseExceptions.createException(Unknown   Source)
at   com.microsoft.jdbc.base.BaseExceptions.getException(Unknown   Source)
at   com.microsoft.jdbc.base.BaseResultSet.validateColumnIndex(Unknown   Source)
at   com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown   Source)
at   com.microsoft.jdbc.base.BaseResultSet.getInt(Unknown   Source)
at   org.apache.jsp.ShowArticleTree_jsp._jspService(org.apache.jsp.ShowArticleTree_jsp:95)
at   org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at   org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:332)
at   org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at   org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at   org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at   org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at   org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at   org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at   org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at   org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at   org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at   org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at   org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at   org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at   org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at   org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at   org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at   java.lang.Thread.run(Thread.java:595)


我JSP里取数据库里的东西的时候提示这个,不知道是怎么回事,帮忙看下..在线等待

------解决方案--------------------
取一次 就可以 了

while(rs.next()) {

int id = rs.getInt( "_id ");
str += " <tr> <td> "+id+ " </td> <td> "+rs.getString( "cont ")+ " </td> </tr> ";
if(rs.getInt( "isleaf ") != 0) {
tree(conn,id);
}