ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zarar Siddiqi" <zarar.sidd...@utoronto.ca>
Subject Re: Connection Pool
Date Tue, 09 Aug 2005 13:52:00 GMT
Perhaps you can try getting rid of this or increasing the value because I 
think this means that a connection should be re-created if it hasn't been 
requested for more than a second.
  <property value="1000" name="Pool.MaximumWait"/>

I could be wrong but try giving it a shot.






----- Original Message ----- 
From: "Ron Kirchheimer" <rkirchheimer@infometis.ch>
To: <user-java@ibatis.apache.org>
Sent: Tuesday, August 09, 2005 5:57 AM
Subject: Connection Pool


> Hi all
>
> I have a question about the connection pool.
>
> Out Setup looks like this:
>
> <transactionManager type="JDBC">
>    <dataSource type="SIMPLE">
>      <property value="${driver}" name="JDBC.Driver"/>
>      <property value="${url}" name="JDBC.ConnectionURL"/>
>      <property value="${username}" name="JDBC.Username"/>
>      <property value="${password}" name="JDBC.Password"/>
>      <property value="15" name="Pool.MaximumActiveConnections"/>
>      <property value="15" name="Pool.MaximumIdleConnections"/>
>      <property value="1000" name="Pool.MaximumWait"/>
>    </dataSource>
>  </transactionManager>
>
>
> What does the Pool.MaximumActiveConnections property mean?
>
> Are there 15 active Connections in the Pool an every query performed
> uses one of these connections?
>
> When running multiple queries  i get following debug output:
>
> [...]
> 2005-08-09 11:48:53,828 DEBUG java.sql.Connection - {conn-100708}
> Connection
> 2005-08-09 11:48:53,841 DEBUG java.sql.Connection - {conn-100711}
> Connection
> 2005-08-09 11:48:53,852 DEBUG java.sql.Connection - {conn-100714}
> Connection
> 2005-08-09 11:48:53,867 DEBUG java.sql.Connection - {conn-100717}
> Connection
> 2005-08-09 11:48:53,900 DEBUG java.sql.Connection - {conn-100720}
> Connection
> 2005-08-09 11:48:53,920 DEBUG java.sql.Connection - {conn-100723}
> Connection
> 2005-08-09 11:48:53,934 DEBUG java.sql.Connection - {conn-100726}
> Connection
> [...]
>
> no connection id is used twice, this must mean that the pool generates a
> new connection for every query.
> how can i set up the pool to manage a certain number of connections so
> that all queries run over these "preforked" connections?
>
> cheers
> ron
> 



Mime
View raw message