web网站的bug,求高手解决
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1157f77
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@6399ae
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@fe9ad1
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1662250
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@56d6cf
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@130b13c
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1c3e3fb
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1aca5e2
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1be9a50
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@8518d4
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@2136c6
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@933cba
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@77f040
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@3e0339
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@145934e
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@ca1ada
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@a8e2b8
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1bca486
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1d56bbe
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@c4cee
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@18ec029
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@e9c592
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1a9fcea
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@11b99c4
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@10c29fe
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1991ba7
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@e674d6
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@b925
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@17b6074
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@f97d27
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@187b5ff
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@bdb6ae
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@12478a9
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@16dc5c9
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1d433c1
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@92015d
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@197871d
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@15b2043
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@1a33662
1conn=============com.microsoft.sqlserver.jdbc.SQLServerConnection@476914
1com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset
at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
at com.microsoft.sqlserver.jdbc.TDSChannel.read(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.Prelogin(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connectHelper(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.loginWithoutFailover(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.connect(Unknown Source)
at com.microsoft.sqlserver.jdbc.SQLServerDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at s2jsp.bysj.dao.BaseDao.getConn(BaseDao.java:16)
at s2jsp.bysj.dao.AdminDao.GetAllAdminOperate(AdminDao.java:25)
at org.apache.jsp.admin.selectadmin_jsp._jspService(selectadmin_jsp.java:169)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
at java.lang.Thread.run(Unknown Source)
conn=============null
2012-1-12 8:50:25 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at s2jsp.bysj.dao.AdminDao.GetAllAdminOperate(AdminDao.java:27)
at org.apache.jsp.admin.selectadmin_jsp._jspService(selectadmin_jsp.java:169)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:393)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:261)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:852)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:584)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1508)
at java.lang.Thread.run(Unknown Source)
上边是日志,现在我说下出现问题的原因,
多次点击下一页,每次都会连接数据库,就会有可能出现上面的问题,求高手讲解下这是上面原因造成的
[解决办法]
正常没问题,连接慢也没问题
只有多次点击下一页才有,如果不是恰好翻页传递了什么奇奇怪怪的参数的话,那么应该是连接设计的问题