Can you try SIMPLE instead of DBCP, just to confirm that the behaviour is the same?
Cheers,
Clinton
On 6/7/05, vi am <[EMAIL PROTECTED]> wrote:
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.
> >
> >
> >