I integrated Torque with a struts-based web application and everything works fine, except:
after a few hours, it seems like Torque (Commons Connection Pool) is loosing the connectivity to the MySQL database... this then results in some errors, of course.
How can one keep the connections alive? Is there a special trick / setting that tells torque to refresh the connections after a while?
Here is my Torque.properites section that should be relevant:
#torque.dsfactory.xmas.factory=org.apache.torque.dsfactory.SharedPoolDataSourceFactory torque.dsfactory.xmas.factory=org.apache.torque.dsfactory.PerUserPoolDataSourceFactory (what is the difference, actually??)
# Lifetime of a connection in the pool. Defaults to one hour #torque.defaults.pool.maxExpiryTime = 3600
-> as you can see, i did not change this setting. Is one hour too much here? Does anyone have experience with MySQL connections, using the Commons Pool? What value is best here and does prevent the errors?
cu
SVEN
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
