ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ron Kirchheimer <rkirchhei...@infometis.ch>
Subject Connection Pool
Date Tue, 09 Aug 2005 09:57:36 GMT
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