DBCP on Tomcat 4.1: DBCP borrowObject failed: null

[Matt Raible]

I am trying to get DBCP working in my app on Tomcat 4.1.10.  I have had
success with Tyrex 0.9.7 on TC 4.0.4, but no luck with DBCP.  I am able
to establish a connection and it works for a few roundtrips to the
database, and then I get "DBCP borrowObject failed: null".  I tried
adding "removeAbandoned" as a parameter, and setting it to true, but I
get the same error.  Any ideas?

My server.xml relevant information is below.

Thanks,

Matt

                <ResourceParams name="jdbc/onpoint">
                <parameter>
                  <name>factory</name>
 
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                </parameter>
            
                <!-- Maximum number of dB connections in pool. Make sure
you
                     configure your mysqld max_connections large enough
to handle
                     all of your db connections. Set to 0 for no limit.
                     -->
                <parameter>
                  <name>maxActive</name>
                  <value>100</value>
                </parameter>
            
                <!-- Maximum number of idle dB connections to retain in
pool.
                     Set to 0 for no limit.
                     -->
                <parameter>
                  <name>maxIdle</name>
                  <value>30</value>
                </parameter>
            
                <!-- Maximum time to wait for a dB connection to become
available
                     in ms, in this example 10 seconds. An Exception is
thrown if
                     this timeout is exceeded.  Set to -1 to wait
indefinitely.
                     -->
                <parameter>
                  <name>maxWait</name>
                  <value>10000</value>
                </parameter>
            
                <!-- MySQL dB username and password for dB connections
-->
                <parameter>
                 <name>username</name>
                 <value>username</value>
                </parameter>
                <parameter>
                 <name>password</name>
                 <value>password</value>
                </parameter>
            
                <!-- Class name for mm.mysql JDBC driver -->
                <parameter>
                   <name>driverClassName</name>
                   <value>org.gjt.mm.mysql.Driver</value>
                </parameter>
            
                <!-- The JDBC connection url for connecting to your
MySQL dB.
                     The autoReconnect=true argument to the url makes
sure that the
                     mm.mysql JDBC Driver will automatically reconnect
if mysqld closed the
                     connection.  mysqld by default closes idle
connections after 8 hours.
                     -->
                <parameter>
                  <name>url</name>
 
<value>jdbc:mysql://localhost:3306/onpoint?autoReconnect=true</value>
                </parameter>
                
                    <!-- Recover abandoned connections -->
                    <!--parameter>
                        <name>removeAbandoned</name>
                        <value>true</value>
                    </parameter-->

              </ResourceParams>



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