SQL Server Performance Forum – Threads Archive
DB connection issueHi,
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.