Can you try SIMPLE instead of DBCP, just to confirm that the behaviour is the same?

Cheers,
Clinton

On 6/7/05, vi am <vi_am@hotmail.com> 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 <brandon.goodin@gmail.com >
>Reply-To: Brandon Goodin <brandon.goodin@gmail.com>
>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 < vi_am@hotmail.com> 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.
> >
> >
> >