ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vi am" <vi...@hotmail.com>
Subject Re: Connection leak
Date Tue, 07 Jun 2005 16:09:02 GMT
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