[dbforms] Connection pool problem

[prasad chaturvedula]

Hi folks

Recently I started working on one of our applications which was dveloped using DBForms.  We have a problem during peak usage hours, people get blank web pages and whne I check the logs I find that dbforms was not able to retrieve aconnection from the pool as I get a Connection not found exception.  The Database is MySql 4.0.17.  I checked teh configuration and I found teh following-

1. The application uses Tomcat's commons dbcp to maintain teh connection pool. 

2.  I am placing the xml file in which we describe teh connection properties.  This is placed in the CATALINA_HOME\conf\Catalina\localhost folder.  I am also palcing the dbconnection tag definition in the dbforms-config.xml

Content of Statusreport.xml file in CATALINA_HOME\conf\Catalina\localhost

            <Resource name="jdbc/statusreport" auth="Container"
                type="javax.sql.DataSource"/>
            <ResourceParams name="jdbc/statusreport">
                <parameter>
                    <name>factory</name>
                    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
                </parameter>
                <parameter>
                    <name>username</name>
                    <value>root</value>
                </parameter>
                <parameter>
                    <name>password</name>
                    <value></value>
                </parameter>
                <parameter>
                    <name>driverClassName</name>
                    <value>org.gjt.mm.mysql.Driver</value>
                </parameter>
                <parameter>
                    <name>url</name>
                    <value>jdbc:mysql://localhost/statusreportdev?autoReconnect=true</value>
                </parameter>
                <parameter>
                    <name>maxActive</name>
                    <value>25</value>
                </parameter>
                <parameter>
                    <name>maxIdle</name>
                    <value>4</value>
                </parameter>
                <parameter>
                    <name>maxWait</name>
                    <value>10000</value>
                </parameter>
            </ResourceParams>


Content of dbforms-config

    <!-- ========== Connection =================================== -->

    <dbconnection
        id = "statusreport"
        isJndi = "true"
        name = "java:comp/env/jdbc/statusreport" />


There are about 30 users during peak hours and the application is throwing errors as described above.  I wanted to know whether it was a problem was with MySql not being able to support that many connections or with the pooling parameters given above like maxIdle etc.

Any help would be greatly apprecited.


Thanks
Prasad