Connection pool exhausted

[Allistair Crossley]

Hi All,

My tomcat is chucking a connection pool exhausted at me after about 15 minutes of 
operations on my web application. 

Here is my resource;

   <Resource name="jdbc/theDB" auth="Container" type="javax.sql.DataSource"/>

   <ResourceParams name="jdbc/theDB">            
    <parameter>              
      <name>factory</name>              
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>            
    </parameter>            
      <parameter>              
       <name>driverClassName</name>              
       <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>            
      </parameter>            
      <parameter>             
        <name>url</name>              
        <value>jdbc:microsoft:sqlserver://server:1433</value>            
      </parameter>            
      <parameter>              
     <name>username</name>              
     <value>sa</value>           
       </parameter>            
       <parameter>              
     <name>password</name>              
     <value>password</value>            
       </parameter>            
       <parameter>              
     <name>maxActive</name>              
     <value>50</value>            
       </parameter>            
       <parameter>              
       <name>maxIdle</name>              
       <value>10</value>            
       </parameter>            
       <parameter>              
       <name>maxWait</name>              
       <value>10000</value>            
       </parameter>
       <parameter>
       <name>validationQuery</name>
       <value>SELECT 1 + 1</value>
       </parameter>
<parameter><name>logAbandoned</name><value>true</value></parameter>
<parameter><name>removeAbandoned</name><value>true</value></parameter>

</ResourceParams>

I have checked that all my code have finally blocks to close result sets, connections 
and statements.

I have also checked my SQL server monitors and it shows the connections are all idle. 

Any starter tips on this problem?

Cheers, ADC


<FONT SIZE=1 FACE="VERDANA,ARIAL" COLOR=BLUE> 
-------------------------------------------------------
QAS Ltd.
Developers of QuickAddress Software
<a href="http://www.qas.com";>www.qas.com</a>
Registered in England: No 2582055
Registered in Australia: No 082 851 474
-------------------------------------------------------
</FONT>


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]