求,很急,项目sqlserver出问题了吗?

最近更新的java项目除了问题,抛出的错误如下,求哥哥姐姐们帮忙看看问题出在哪,错误是什么意思
2-9-12 17:19:37:015 CST] 0000001c SystemErr R com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset by peer: socket write error
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSChannel.write(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSWriter.flush(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSWriter.writePacket(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSWriter.endMessage(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteStatement(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement$StmtExecCmd.doExecute(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.TDSCommand.execute(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.microsoft.sqlserver.jdbc.SQLServerStatement.execute(Unknown Source)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.sinosoft.utility.DBConn.createConnection(DBConn.java:29)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.sinosoft.utility.DBConnPool.getConnection(DBConnPool.java:57)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.sinosoft.lis.db.LDSysVarDB.query(LDSysVarDB.java:483)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.sinosoft.lis.aml.AntiInit.getValueFromSysvar(AntiInit.java:109)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.sinosoft.lis.aml.AntiInit.init(AntiInit.java:62)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm._jsp._main._jspService(_main.java:98)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:99)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at javax.servlet.http.HttpServlet.service(HttpServlet.java:831)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.cache.servlet.ServletWrapper.serviceProxied(ServletWrapper.java:307)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.cache.servlet.CacheHook.handleFragment(CacheHook.java:576)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.cache.servlet.CacheHook.handleServlet(CacheHook.java:250)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.cache.servlet.ServletWrapper.service(ServletWrapper.java:259)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1657)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1597)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:131)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:34)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:188)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:116)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:77)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:908)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:934)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:502)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:179)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.jsp.webcontainerext.AbstractJSPExtensionServletWrapper.handleRequest(AbstractJSPExtensionServletWrapper.java:259)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:91)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:864)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1583)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:186)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:452)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:511)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:305)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)
[12-9-12 17:19:37:015 CST] 0000001c SystemErr R at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)

2个回答

可能原因:
1. 创建的连接时间过于长,导致失效;
2. SQLServer2005,停止服务,或者网络中断;

zq2665213
zq2665213 看了代码,可以确定是创建的连接闲置时间过长导致失效,谢谢帮忙
7 年多之前 回复
iteye_5246
iteye_5246 看来就普通的jdbc。关闭con了没? finally方法中有关闭连接了没?
7 年多之前 回复
zq2665213
zq2665213 con = DriverManager.getConnection(JUrl.getJdbcUrl(), JUrl.getUserName(), JUrl.getPassWord());
7 年多之前 回复
zq2665213
zq2665213 用的是jdbc方式连接,公司框架
7 年多之前 回复
iteye_5246
iteye_5246 你用的什么?连接池?还是?
7 年多之前 回复
zq2665213
zq2665213 嗯,我觉得挺像第一种情况的,那在sqlserver有没有什么方式可以延长失效时间呢?
7 年多之前 回复

连接数据库出错,是不是换了数据库版本 如果是那建议你的jdbc包也换成相应的版本试试吧

Csdn user default icon
上传中...
上传图片
插入图片
抄袭、复制答案,以达到刷声望分或其他目的的行为,在CSDN问答是严格禁止的,一经发现立刻封号。是时候展现真正的技术了!
立即提问
相关内容推荐