急需解决的问题HTTP Status 500

Question

我的JSP是一个提交表单,删除功能的,删除前要先显示数据库的内容,但是调试一步一步走是对的,能够显示,若不用调试就出现如下错误,真不知道是什么问题,请解决

Answer 1

不好意思,补充:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /adminmanage/accountdel.jsp:6360:            
61:            AdmininfoBean admininfobean=(AdmininfoBean)courses.get(i);
62:            int power=admininfobean.getAdminPower();
63:            AccountBean accountbean=accountdao.getPowerNameBypower(power);
64:            %>
65:        <tr bgcolor="#FAF8F1" height="10">
66:        <td align="center"><input type="checkbox" name="users_index<%=i %>" value="<%=admininfobean.getAdminID() %>"></td>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Software caused connection abort: socket write error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.adminmanage.accountdel_jsp._jspService(org.apache.jsp.adminmanage.accountdel_jsp:185)
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:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Software caused connection abort: socket write error
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.TDSLoginRequest.submitRequest(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
com.cdnzzz.billboardsystem.db.DBMain.getDBConnection(DBMain.java:33)
com.cdnzzz.billboardsystem.db.DBMain.getPrepareStatement(DBMain.java:65)
com.cdnzzz.billboardsystem.db.account.AccountDao.getPowerNameBypower(AccountDao.java:28)
org.apache.jsp.adminmanage.accountdel_jsp._jspService(org.apache.jsp.adminmanage.accountdel_jsp:113)
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:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15

Answer 2

不好意思,补充:HTTP Status 500 - --------------------------------------------------------------------------------type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException: Exception in JSP: /adminmanage/accountdel.jsp:6360:            
61:            AdmininfoBean admininfobean=(AdmininfoBean)courses.get(i);
62:            int power=admininfobean.getAdminPower();
63:            AccountBean accountbean=accountdao.getPowerNameBypower(power);
64:            %>
65:        <tr bgcolor="#FAF8F1" height="10">
66:        <td align="center"><input type="checkbox" name="users_index<%=i %>" value="<%=admininfobean.getAdminID() %>"></td>
Stacktrace:
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:504)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:375)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause javax.servlet.ServletException: [Microsoft][SQLServer 2000 Driver for JDBC]Software caused connection abort: socket write error
org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:858)
org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:791)
org.apache.jsp.adminmanage.accountdel_jsp._jspService(org.apache.jsp.adminmanage.accountdel_jsp:185)
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:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
root cause java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Software caused connection abort: socket write error
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.TDSLoginRequest.submitRequest(Unknown Source)
com.microsoft.jdbc.sqlserver.SQLServerImplConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.getNewImplConnection(Unknown Source)
com.microsoft.jdbc.base.BaseConnection.open(Unknown Source)
com.microsoft.jdbc.base.BaseDriver.connect(Unknown Source)
java.sql.DriverManager.getConnection(DriverManager.java:525)
java.sql.DriverManager.getConnection(DriverManager.java:171)
com.cdnzzz.billboardsystem.db.DBMain.getDBConnection(DBMain.java:33)
com.cdnzzz.billboardsystem.db.DBMain.getPrepareStatement(DBMain.java:65)
com.cdnzzz.billboardsystem.db.account.AccountDao.getPowerNameBypower(AccountDao.java:28)
org.apache.jsp.adminmanage.accountdel_jsp._jspService(org.apache.jsp.adminmanage.accountdel_jsp:113)
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:332)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.15 logs.
--------------------------------------------------------------------------------Apache Tomcat/5.5.15

Answer 3

呵呵，socket连接不上，你看看 你的1433端口能用吗？就是sqlserver的端口，telnet一下，估计不能用，是不是xp Sp2啊 是的话 ，SQLSERVER打补丁sp3,sp4

Answer 4

你看一下你的那个admininfobean的bean里面是不是没有把数据库联接及时释放掉

Answer 5

5楼的说对了,1433不通,我和系统是win2000 server