ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brent Ryan" <br...@blackboard.com>
Subject MS SQL Server 2000 connection reset problem
Date Thu, 17 Mar 2005 17:49:03 GMT
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
        <property name="Pool.PingEnabled" value="true"/>
        <property name="Pool.PingConnectionsOlderThan" value="1"/>
        <property name="Pool.PingConnectionsNotUsedFor" value="1"/>
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
It may include Blackboard confidential and proprietary information, and is not for redistribution.

View raw message