Commons dbcp pooling problems...

Pooling does not seem to be working, every request to specific url executes 5 queries and opens 5 connections and leaves them open once 50 connections are open ( maxActive setting ). I get timeout error here are my settings see if there is any thing wrong. ( Followed jakarta website ):
( Tomcat / MySQL )

Context: 
<Resource name="jdbc/hoh" type="javax.sql.DataSource"/>
  <ResourceParams name="jdbc/hoh">
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/database?autoReconnect=true</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>
    <parameter>
      <name>removeAbandoned</name>
      <value>true</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>50</value>
    </parameter>
    <parameter>
      <name>driverClassName</name>
      <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>username</name>
      <value>username</value>
    </parameter>
    <parameter>
      <name>password</name>
      <value>password</value>
    </parameter>
  </ResourceParams>
 
DAO:
 
Context ctx = new InitialContext();
javax.sql.DataSource ds = (DataSource)ctx.lookup("java:comp/env/hoh");
java.sql.Connection conn = ds.getConnection();
 
// do query
 
conn.close();
rs.close();

From what I have read the above code should work, but it doesn't please help...

[ November 08, 2004: Message edited by: Kerry Wilson ]

Hi Kerry,

I've had the same problem with commons dbcp, and spent some time reviewing my code and config files. Somehow through google found that it was a bug within some version of commons dbcp. This could be your case.

As soon as I replaced the buggy jar with some older one, everything worked just fine.

Cheers !!

Luis F.