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
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.



Mime
View raw message