SQL Server Performance Forum – Threads Archive

DB connection issue

Hi,
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
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>