Re: Torque/MySQL connection hung after a week

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: [email protected]
> For additional commands, e-mail: [email protected]