I found out how to make it work. I read the iBatis documentation and
the properties are different for DBCP vs. SIMPLE datasource so using
this:
<property name="Pool.ValidationQuery" value="select 1 from
BBEXTRACT.USERS"/>
<property name="Pool.LogAbandoned" value="true"/>
<property name="Pool.RemoveAbandoned" value="true"/>
<property name="Pool.RemoveAbandonedTimeout" value="50000"/>
Instead of this fixed the problem:
<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="10"/>
<property name="Pool.PingConnectionsNotUsedFor" value="10"/>
------------------------------------
Brent Ryan
-----Original Message-----
From: Abdullah Kauchali [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 11:47 AM
To: [email protected]
Subject: Re: MS SQL Server 2000 connection reset problem
Hi Brent,
I think your best bet would be to talk to the folks at the JDBC forum on
the Microsoft newsgroups. I've had a terrible week with SQL Server too.
:)
Sorry I couldn't be of further help,
Abdullah
Brent Ryan wrote:
> I'm running SQL Server 2000 8.00.760. The connection reset problem
> happens for any sql statement, but the ones that I'm testing are:
>
> <select id="getUsers" resultMap="userResult"> select * from
> BBEXTRACT.USERS </select>
>
> <select id="getRoles" resultMap="roleResult"> select * from
> BBEXTRACT.ROLES </select>
>
> I never had this problem when connection to a Oracle DB. This only
> happens when connecting to MS SQL Server.
>
> ------------------------------------ Brent Ryan
>
>
>
> -----Original Message----- From: Abdullah Kauchali
> [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005
> 11:22 AM To: [email protected] Subject: Re: MS
> SQL Server 2000 connection reset problem
>
>
>
>
> Brent Ryan wrote:
>
> > * The commiting/rolling back is handled by the datasource
> > automatically.
> >
> > * The max allowable connection is set to 0 * netstat -n on client
> > and server show 3 connections established.
> >
> > If I set this property to 0 then it works, but then this means there
> > is
>
>
> > nothing in the pool. Right? <property
> > name="Pool.MaximumIdleConnections" value="0"/
> >
>
> Also, can you post the SQL statement?
>
> 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.
>
>
>
