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