DB connection issue | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DB connection issue

I have a java front end with pooling technology, which connects to my sql server 2k sp3.
It will have a 50 initial connections, and shirnks and expands on the need. Sometime, the front end throws a message: SQLException: Connection reset by peer. and the connections is lost. By M. people say that, it is the SQL server closing the connection. But I dont see anything abonormal from SQL side. The non-java connections to SQL server still exists. Is this a sql server related problem ? I think it is more of a java connection properties or could be a too big resultset ? Any inputs appreciated. This issue is tormenting me. Thanks.
This error might occur that will be thrown due to network break/glitches.
Check thru event viewer logs, SQL server error logs for more information. Are you using UNIONs in your query? Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.