ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: Connection leak
Date Tue, 07 Jun 2005 21:16:39 GMT
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.
> > >
> > >
> > >
> 
> 
>

Mime
View raw message