Topic: [mssql]Connection reset by peer error

  Print this page

1.[mssql]Connection reset by peer error Copy to clipboard
Posted by: andy
Posted on: 2003-09-02 07:42

提示错误:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error

运行环境:win ad server + ms sql 2000 + jboss 3.0.4

怎么回事?

2.Re:[mssql]Connection reset by peer error [Re: andy] Copy to clipboard
Posted by: redmiddle
Posted on: 2003-09-02 11:29

应该是你的连接因为一些原因丢失了.我试过的原因是resultset太大.或者操作数据库操时....

3.Re:[mssql]Connection reset by peer error [Re: andy] Copy to clipboard
Posted by: why
Posted on: 2003-09-02 12:11

Are you sure your resultset's are properly closed?

Also take a look at http://forum.java.sun.com/thread.jsp?thread=433578&forum=45
this thread is about SQL Server and Tomcat, but I guess similar can be applied to your case, i.e. lower the corresponding Timeout setting.

4.Re:[mssql]Connection reset by peer error [Re: andy] Copy to clipboard
Posted by: ftang
Posted on: 2003-09-02 23:18

you should check first who reset the peer, could be app serve side and same as sql server side, check the window event, ms jdbc will log error in event log on the side have problem.


   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2021 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号-1
客服电话 18559299278    客服信箱 714923@qq.com    客服QQ 714923