Return-Path: 
 <user-java-return-10807-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 5184 invoked from network); 22 Feb 2007 18:20:11 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 22 Feb 2007 18:20:11 -0000
Received: (qmail 63996 invoked by uid 500); 22 Feb 2007 18:20:06 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 63978 invoked by uid 500); 22 Feb 2007 18:20:06 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 63958 invoked by uid 99); 22 Feb 2007 18:20:06 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Feb 2007 10:20:06 -0800
X-ASF-Spam-Status: No, hits=-0.0 required=10.0
	tests=SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: domain of TomH@a-t-g.com designates
 65.171.64.184 as permitted sender)
Received: from [65.171.64.184] (HELO yitweb11.a-t-g.com) (65.171.64.184)
    by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 22 Feb 2007 10:19:52 -0800
Received: from mail.a-t-g.com ([65.162.162.10]) by yitweb11.a-t-g.com with
 Microsoft SMTPSVC(5.0.2195.6713);
	 Thu, 22 Feb 2007 12:34:47 -0600
Received: from 65.171.64.163 ([65.171.64.163] helo=mail.a-t-g.com) by
	ASSPCentral; 22 Feb 2007 12:34:47 -0600
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.5
Subject: number of Initial connections
Date: Thu, 22 Feb 2007 12:16:52 -0600
Message-ID: <B2C40C183B943C4EA9775DAE4CB0D6692646F2@EX2003.a-t-g.com>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: number of Initial connections
Thread-Index: AcdWraCxZ85h9myNTPe6CfUhvUwGxg==
From: "Tom Henricksen" <TomH@A-t-g.com>
To: <user-java@ibatis.apache.org>
X-OriginalArrivalTime: 22 Feb 2007 18:34:47.0390 (UTC)
 FILETIME=[2128BFE0:01C756B0]
X-Virus-Checked: Checked by ClamAV on apache.org

We have a problem where we exceed our maximum connections on our
database.  Our setup is here.  Does MaximumIdleConnections mean that the
database right away grabs 25 connections? Or is that the maximum idle
connections before it starts to clean up?=20

I see in the iBatis-SqlMaps-2.pdf it says Pool.MaximumIdleConnections -
"The number of idle connections that will be stored in the pool."  Is
that initially? Is there Pool.IntialSize?

	<transactionManager type=3D"JDBC">
		<dataSource type=3D"SIMPLE">
			<property name=3D"JDBC.Driver" value=3D"${driver}"/>
			<property name=3D"JDBC.ConnectionURL"
value=3D"${url}"/>
			<property name=3D"JDBC.Username"
value=3D"${username}"/>
			<property name=3D"JDBC.Password"
value=3D"${password}"/>
			<property name=3D"Pool.MaximumActiveConnections"
value=3D"50"/>
			<property name=3D"Pool.MaximumIdleConnections"
value=3D"25"/>
			<property name=3D"Pool.MaximumWait" value=3D"600"/>
			<property name=3D"Pool.LogAbandoned"
value=3D"true"/>
			<property name=3D"Pool.RemoveAbandoned"
value=3D"true"/>
			<property name=3D"Pool.RemoveAbandonedTimeout"
value=3D"50000"/>
			<property name=3D"Pool.PingQuery" value=3D"select *
from sysibm.SYSDUMMY1"/>
			<property name=3D"Pool.PingEnabled" value=3D"true"/>
			<property name=3D"Pool.PingConnectionsOlderThan"
value=3D"600000"/>
			<property name=3D"Pool.PingConnectionsNotUsedFor"
value=3D"600000"/>
		</dataSource>
	</transactionManager>

Thanks,
Tom