dbcp and maxWait

[John Moore <Jo...@PDSI-Software.COM>]

       

Is there any trick to getting the maxWait to work.  Am using TC 4.1.24LE, RH
9 (2.4.20-9), JVM 1.4.1_02, DBCP 1.0 and Pool 1.0.1 connecting to a sybase
sqlanywhere database.  Even though I have max wait set to 5 seconds it still
doesn't timeout for over three minutes.  I checked out the source and
started to follow it through got lost along the way.

TIA,
John Moore


    <Resource name="webdemo" scope="Shareable" type="javax.sql.DataSource"/>
    <ResourceParams name="webdemo">
      <parameter><name>removeAbandoned</name><value>true</value></parameter>
      <parameter><name>logAbandoned</name><value>true</value></parameter>
      <parameter><name>testOnBorrow</name><value>true</value></parameter>
      <parameter><name>validationQuery</name><value>select count(0) from
agency_tbl</value></parameter>
      <parameter><name>testWhileIdle</name><value>true</value></parameter>
 
<parameter><name>timeBetweenEvectionRunsMillis</name><value>60000</value></p
arameter>
      <parameter> <name>maxWait</name> <value>5000</value> </parameter>
      <parameter> <name>maxActive</name> <value>4</value> </parameter>
      <parameter> <name>password</name> <value>xxxxx</value> </parameter>
      <parameter> <name>url</name>
<value>jdbc:sybase:Tds:[host]:[port]/[db]</value> </parameter>
      <parameter> <name>driverClassName</name>
<value>com.sybase.jdbc2.jdbc.SybDataSource</value> </parameter>
      <parameter> <name>maxIdle</name> <value>2</value> </parameter> 
      <parameter> <name>username</name> <value>xxxxxxx</value> </parameter>
    </ResourceParams>