Mysql timouts...

[Jacob Rhoden]

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@tomcat.apache.org
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]