Connection reset 问题

Question

本帖最后由 ypchengmsdn 于 2009-09-11 17:53:27 编辑

Answer 1

试着重启数据库。。
跟那个没关系吧。只是创建了statement，结果集是滚动的敏感的，可更新的

Answer 2

java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
com.microsoft.jdbc.base.BaseExceptions.createException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.base.BaseExceptions.getException(Unknown Source)
com.microsoft.jdbc.sqlserver.tds.TDSRequest.processReply(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.setupImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseStatement.<init>(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.createStatement(Unknown Source)
org.apache.jsp.admin.chklogin_jsp._jspService(chklogin_jsp.java:116)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Answer 3

还有：
root cause :javax.servlet.ServletException: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:852)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:781)
org.apache.jsp.admin.chklogin_jsp._jspService(chklogin_jsp.java:135)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Answer 4

出现这个错误的主要原因是：在我刷新一个页面的时候，就出现了这个Exception？这里：
org.apache.jasper.JasperException: An exception occurred processing JSP page /admin/chklogin.jsp at line 129:  "'and user_password='"+password+"'";
10: 
11: //smt = con.createStatement();
12: Statement smt_1 = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
13:  rs = smt_1.executeQuery(sql);
14:  if(!rs.next()) {
15:  String errmsg= "error1";