Posted by ceadtinneh on 09/15/05 18:52

Hello Folks,

Our web based application accesses our SQL Server 2k database using a
connection pool of about 150 connections through a BEA JDBC driver.

We recently had a situation where one of our app servers lost
connectivity to the database server (the BEA error logs indicated the
following:

java.sql.SQLException: [BEA][SQLServer JDBC Driver]A problem occurred
when attempting to contact the server (Server returned: Connection
reset by peer.)

We're trying to eliminate possibilities and I was wondering under
which circumstances would SQL Server close one of these pooled
connections. Any ideas?

Thanks in advance...

Joe

[Back to original message]