ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Renato Silveira" <renatosilve...@gmail.com>
Subject Re: Conections Opened
Date Fri, 11 Aug 2006 13:52:03 GMT
I still have this problem. Every single call I made a new connection is
opened. The DaoManager is started just one time. And the connection remain
opened for a  long time until oracle returns a error of max number of
connections opened.

Any ideas to solve this problem?

tks!




On 8/11/06, Mkhitaryan, Aram <Aram.Mkhitaryan@lycos-europe.com> wrote:
>
>   When you do first call DBCP creates minimum number of connections
>
> and uses these connections until all connections are busy(active/running)
> and new connection is created.
>
>
>
> If you compare first call and second, the first one should take much time
> then second one.
>
>
>
> But if "every call I do a new connection is created" that only can mean
> that your calls are too fast and DBCP
>
> can't create connections automatically and creates during call.
>
>
>
> Best,
>
> Aram
>
>
>  ------------------------------
>
> *From:* Renato Silveira [mailto:renatosilveira@gmail.com]
> *Sent:* Friday, August 11, 2006 3:45 AM
> *To:* user-java@ibatis.apache.org
> *Subject:* Re: Conections Opened
>
>
>
> Hi,
>
> I have configured the maxActive connection with 10 but every call I do a
> new connection is created.
>
>  <transactionManager type="JDBC">
>     <dataSource type="DBCP">
>       <property value="${database_driver}" name=" JDBC.Driver"/>
>       <property value="${database_url}" name="JDBC.ConnectionURL"/>
>       <property value="${database_user}" name="JDBC.Username"/>
>       <property value="${database_password}" name=" JDBC.Password"/>
>       <property value="10" name="Pool.MaximumActiveConnections"/>
>       <property value="5" name="Pool.MaximumIdleConnections"/>
>       <property value="6000" name=" Pool.MaximumWait"/>
>     </dataSource>
>   </transactionManager>
>
> This is my SQL-map-config like. How do I limit the number of opened
> connections?
>
> tks!
>
> On 8/10/06, *Renato Silveira* <renatosilveira@gmail.com> wrote:
>
> Hi,
>
> How many connections are opened by Ibatis to make a simple query?
>
> In my sql-map-config, using SimpleDataSource (pool), the maxnumber of
> connection are like this:
> <property value="1" name=" Pool.MaximumActiveConnections"/>
> <property value="1" name="Pool.MaximumIdleConnections"/>
> But Ibatis open 4 connections at least.
>
> Cheers!
>
>
>

Mime
View raw message