db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sven Haiges ...@flavor.de>
Subject Problem with loosing connections after a while
Date Mon, 06 Oct 2003 18:18:37 GMT
Hi there,

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 


Mime
View raw message