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