ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tom Henricksen" <T...@A-t-g.com>
Subject number of Initial connections
Date Thu, 22 Feb 2007 18:16:52 GMT
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? 

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="JDBC">
		<dataSource type="SIMPLE">
			<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="Pool.MaximumActiveConnections"
value="50"/>
			<property name="Pool.MaximumIdleConnections"
value="25"/>
			<property name="Pool.MaximumWait" value="600"/>
			<property name="Pool.LogAbandoned"
value="true"/>
			<property name="Pool.RemoveAbandoned"
value="true"/>
			<property name="Pool.RemoveAbandonedTimeout"
value="50000"/>
			<property name="Pool.PingQuery" value="select *
from sysibm.SYSDUMMY1"/>
			<property name="Pool.PingEnabled" value="true"/>
			<property name="Pool.PingConnectionsOlderThan"
value="600000"/>
			<property name="Pool.PingConnectionsNotUsedFor"
value="600000"/>
		</dataSource>
	</transactionManager>

Thanks,
Tom



Mime
View raw message