This is probably the old mysql problem: Mysql shuts down connections after
8 hours of inactivity (this is configurable but 8 hours is the standard
setting). Depending on your pool configuration, it may not notice that the
connections are dead, and may fail to evict them. In this case Martin's
s
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 wr
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
