DBCP Parameters

[Leonardo Larraquy]

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