That´s because DBCP when reach its limit it create a new connection
to suplay the demand, after all connection without use are released your
current connections come back to 3 connection in pool as you setted to 3 max
connection alive in the pool.

 Regards,
 Edson

-----Mensagem original-----
De: Leonardo Larraquy [mailto:llarraquy@(protected)]
Enviada em: terça-feira, 5 de outubro de 2004 16:15
Para: Tomcat Users List
Assunto: DBCP Parameters


Hi everyone.
I've just made my application work with an SQL Server Datasource, wich is
written below. It's working fine, but there's one problem (or not), so I
want to ask you folks.
As you can see I put at the parameter "maxConnections" a value of "3".
Then I made a test, getting a Connection from the pool within a "for loop".
I was able to get over 10000 connections, and I stoped the test.
With dind't I get a "Connection Pool exasusted error" at the fourth
iteration???

Thanks in advance.

<Resource name="jdbc/sql2000" auth="Container"
type="com.microsoft.jdbcx.sqlserver.SQLServerDataSource"/>
 <ResourceParams name="jdbc/sql2000">
  <parameter>
    <name>factory</name>

<value>com.microsoft.jdbcx.sqlserver.SQLServerDataSourceFactory</value>
  </parameter>
  <parameter>
    <name>driverClassName</name>
    <value>com.microsoft.jdbcx.sqlserver.SQLServerDataSource</value>
  </parameter>
  <parameter>
    <name>driverName</name>
    <value>SQLServer</value>
  </parameter>
  <parameter>
    <name>description</name>
    <value>SQL Server DataSource</value>
  </parameter>
  <parameter>
    <name>serverName</name>
    <value>JK008</value>
  </parameter>
  <parameter>
    <name>portNumber</name>
    <value>1433</value>
  </parameter>
  <parameter>
    <name>selectMethod</name>
    <value>cursor</value>
  </parameter>
  <parameter>
    <name>databaseName</name>
    <value>seguridad</value>
  </parameter>
  <parameter>
    <name>user</name>
    <value>puma</value>
  </parameter>
  <parameter>
    <name>password</name>
    <value>puma</value>
  </parameter>
  <parameter>
    <name>maxConnections</name>
    <value>3</value>
  </parameter>
  <parameter>
    <name>minConnections</name>
    <value>1</value>
  </parameter>
  <parameter>
    <name>loginTimeout</name>
    <value>3000</value>
  </parameter>
  <parameter>
    <name>checkEvery</name>
    <value>60000</value>
  </parameter>
  <parameter>
    <name>idleTimeout</name>
    <value>500000</value>
  </parameter>
  </ResourceParams>


Leonardo Lopez Larraquy
Jakarta Ingenieria de Software
www.jakartasrl.com.ar