You have a problem with maxIdle times. You could do 2 things: 1. Use more connections. 2. Or - even better - use the singleConnectionperThread connection provider.
Cheers Henner > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Im > Auftrag von prasad chaturvedula > Gesendet: Dienstag, 28. Juni 2005 09:31 > An: [email protected] > Betreff: [dbforms] Connection pool problem > > 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=tr > ue</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 > > > > > <http://clients.rediff.com/signature/track_sig.asp> > ------------------------------------------------------- SF.Net email is sponsored by: Discover Easy Linux Migration Strategies from IBM. Find simple to follow Roadmaps, straightforward articles, informative Webcasts and more! Get everything you need to get up to speed, fast. http://ads.osdn.com/?ad_idt77&alloc_id492&op=click _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
