Here is the full transaction manager configuration:
********************************************************
<sqlMapConfig>
<properties resource="properties/database.properties"/>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
maxSessions="64"
maxTransactions="8"
maxRequests="128"/>
<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="3" />
<property name="Pool.MaximumIdleConnections" value="2" />
<property name="Pool.MaximumWait"
value="1000" />
</dataSource>
</transactionManager>
<sqlMap resource="batis_maps/Account.xml"/>
<sqlMap resource="batis_maps/Product.xml"/>
</sqlMapConfig>
********************************************************
Thank you.
From: Brandon Goodin <[EMAIL PROTECTED]>
Reply-To: Brandon Goodin <[EMAIL PROTECTED]>
To: ibatis-user-java@incubator.apache.org
Subject: Re: Connection leak
Date: Mon, 6 Jun 2005 18:45:04 -0600
Please provide your full transaction manager configuration.
Brandon
On 6/6/05, vi am <[EMAIL PROTECTED]> wrote:
> Is there a way to limit the maximum number of connections (at any given
> time) Apache's DBCP pool? iBATIS does seem to support DBCP. Whenever
I
> access JSP pages, there is constant increase of connections at Oracle
> backend.
>
>
> I was hoping the following config will limit the DBCP pool to a maximum
of 3
> connections. If all the three connections are in use, new connections
> should not be created... and users will wait.
>
> What am I missing from the configuration?
>
>
> <transactionManager type="JDBC">
> <dataSource type="DBCP">
> ......
> <property name="Pool.MaximumActiveConnections" value="3" />
> ......
> </dataSource>
> </transactionManager>
>
>
> Thank you.
>
>
>