Java Mailing List Archive

http://www.junlu.com/

Home » Home (12/2007) » Apache Tomcat »

Mysql timouts...

Jacob Rhoden

2007-02-21

Replies:

I am having the seemingly common "Broken pipe" to mysql problem with
tomcat.

All i could find was some info about a "maxideltime" setting and
"idleconnectiontestperiod" where can I find out info about tuning to
make sure tomcat doesn't serve out stale database connections? The
following settings don't seem to be doing the trick:

<Resource auth="Container" name="jdbc/blah" type="javax.sql.DataSource"
   maxActive="5" removeAbandoned="true"
   maxIdle="2" maxIdleTime="300" idleConnectionTestPeriod="60"
   maxWait="10000" username="blah" password="blah"
   driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://localhost:3306/blah?autoReconnect=true&amp;useUnicode=true&amp;characterEncoding=utf8"/>


Thanks guys.
Jacob

---------------------------------------------------------------------
To start a new topic, e-mail: users@(protected)
To unsubscribe, e-mail: users-unsubscribe@(protected)
For additional commands, e-mail: users-help@(protected)

©2008 junlu.com - Jax Systems, LLC, U.S.A.