db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Tilsted <til...@daimi.au.dk>
Subject Re: Torque/MySQL connection hung after a week
Date Fri, 31 Oct 2008 21:59:05 GMT
I had a similary problem with torque 3.3, and fixed it with

torque.dsfactory.YOURDATABASE.pool.validationQuery=SELECT 1
torque.dsfactory.YOURDATABASE.pool.testOnBorrow=true

I did a few other things with my code, but I am pretty sure it was these 
2 lines that fixed it.

Martin


Frank Nguyen wrote:
> I use Tomcat 4.x + Torque 3.1.1 + MySQL (5.x). The # of frequent users 
> is <10 but heavy; i.e. continuous 8hrs. My problem is that after a week 
> or so, the db connection b/w Tomcat (Torque) and MySQL hung (Tomcat is 
> still working fine w/ other transaction) and have to reboot. I 
> experienced a lot w/ Torque.properties configuration; especially 
> db-common section, but nothing helped. Attached is my Torque.properties 
> file. Any help/pointers is greatly appreciated.
> 
> 
> Frank Nguyen
> 
> 
> 
> 
> 
> ------------------------------------------------------------------------
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
> For additional commands, e-mail: torque-user-help@db.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message