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

刚出的新问题,请大家进来看看....
java.sql.SQLException:   [Microsoft][SQLServer   2000   Driver   for   JDBC]Software   caused   connection   abort:   socket   write   error
at   com.microsoft.jdbc.base.BaseExceptions.createException(Unknown   Source)
at   com.microsoft.jdbc.base.BaseExceptions.getException(Unknown   Source)
at   com.microsoft.jdbc.base.BaseExceptions.getException(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSRPCRequest.submitRequest(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.tds.TDSCursorRequest.openCursor(Unknown   Source)
at   com.microsoft.jdbc.sqlserver.SQLServerImplStatement.execute(Unknown   Source)
at   com.microsoft.jdbc.base.BaseStatement.commonExecute(Unknown   Source)
at   com.microsoft.jdbc.base.BaseStatement.executeQueryInternal(Unknown   Source)
at   com.microsoft.jdbc.base.BaseStatement.executeQuery(Unknown   Source)
at   org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:188)
at   DBManager.DBManager.getDB_returnArrayListSelect(DBManager.java:121)
at   com.yourcompany.struts.action.IsWhichWebAction.execute(IsWhichWebAction.java:69)
at   org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
at   org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
at   org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
at   org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
at   javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
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.ajp.AjpAprProcessor.process(AjpAprProcessor.java:425)
at   org.apache.coyote.ajp.AjpAprProtocol$AjpConnectionHandler.process(AjpAprProtocol.java:452)
at   org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at   java.lang.Thread.run(Unknown   Source)

今天看到TOMCAT日值老是报这个错...小弟不理解,请各位高论!

------解决方案--------------------
数据库连接与连接池之间冲突导至.
database把空闲一段时间的连接关闭了,而应用服务器连接池却认为该边接还是可用的,再次访问时还是使用该连接,导致出现连接异常。
------解决方案--------------------
xizhiyao(流浪的猴子) 正解