MS SQL Server 2000 connection reset problem

[Brent Ryan]

Title: Message

I'm using Ibatis 2 with a web app and I get the following error after connecting to the data source and then letting it sit for 2 minutes and then retrying my web applicaiton.

 

ERROR:2005-03-17 10:35:57,379 - Failed to queryForList - id [getUsers], parameterObject [null].  Cause: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Connection reset by peer: socket write error

 

Here's my sql map config:

 

   <transactionManager type="JDBC">
     <dataSource type="DBCP">
        <property name="JDBC.Driver" value="${driver}"/>
        <property name="JDBC.ConnectionURL" value="${url}"/>
        <property name="JDBC.Username" value="${username}"/>
        <property name="JDBC.Password" value="${password}"/>
        <property name="JDBC.DefaultAutoCommit" value="true"/>
        <property name="Pool.MaximumActiveConnections" value="20"/>
        <property name="Pool.MaximumIdleConnections" value="5"/>
        <property name="Pool.MaximumWait" value="120000"/>
        <property name="Pool.TimeToWait" value="500"/>
        <property name="Pool.PingQuery" value="select 1 from BBEXTRACT.USERS"/>
        <property name="Pool.PingEnabled" value="true"/>
        <property name="Pool.PingConnectionsOlderThan" value="1"/>
        <property name="Pool.PingConnectionsNotUsedFor" value="1"/>
     </dataSource>
   </transactionManager>

 

 

Thanks,

Brent Ryan

Don't miss the 2005 Blackboard Users Conference April 12-14 in Baltimore, MD! 
Visit http://www.blackboard.com/about/events/BbUC05/index.htm for more information.

This e-mail is intended only for the personal and confidential use of the recipient(s) named above.
It may include Blackboard confidential and proprietary information, and is not for redistribution.