SQL Server 2000 Driver for JDBC: Connection reset

zhu894532094

SQL Server 2000 Driver for JDBC: Connection reset by peer
　　If you’re using the SQL Server 2000 Driver for JDBCand Commons DBCPand you either you see this error in your logs:

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

and / or your application stops functioning after your SQL Server is
restarted or the connection between the your application and the SQL
Server is terminated, then you need to add this to your JDNI setup:




<parameter>
<name>validationQuery</name>
<value>select $somecolumn FROM $sometable</value>
</parameter>
　　
　　

where the value is a query that returns at least one row from your database. According to the documentation
, the validation query is:

“… invoked in an implementation-specific fashion to
determine if an instance is still valid to be returned by the pool. It
will only be invoked on an “activated” instance.”

　　In my testing, if I add the validationQuery parameter to my JNDI
setup, restart the servlet container (in this case Tomcat), request a
page and then stop SQL Server, an error is returned (as expected).
After starting SQL Server and requesting another page, the application
returns to normal usage (which doesn’t happen if the validationQuery
parameter is not present).
　　
　　转自:http://cephas.net/blog/2004/07/14/sql-server-2000-driver-for-jdbc-connection-reset-by-peer/