RE: Conections Opened

[Mkhitaryan, Aram]

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:[EMAIL PROTECTED] 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 <[EMAIL PROTECTED]> 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!