-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Daniel,
On 4/4/12 8:46 AM, Daniel Mikusa wrote: > ----- Original Message ----- >> My db connections seem to be lost after an extended period of >> inactivity (for a web application). And the only way to get the >> connections to work again is to restart tomcat. >> >> My tomcat.jdbc.pool.Datasource settings have: >> >> <property name="maxActive" value="100"/> <property name="maxIdle" >> value="30"/> <property name="maxWait" value="1000"/> <property >> name="defaultAutoCommit" value="true"/> <property >> name="removeAbandoned" value="true"/> <property >> name="removeAbandonedTimeout" value="60"/> > > You probably want to add testOnBorrow="true" and > "validationQuery=SELECT 1" (or some other valid query for your > DB). +1 > See the following link for an explanation of those properties. > > https://commons.apache.org/dbcp/configuration.html - -1 This is the wrong documentation for tomcat-pool. You're looking for http://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On the other hand, there was no mention of a Tomcat version, what type of pool is actually being used (I inferred tomcat-pool from the subject line as well as the use of "tomcat.jdbc.pool.DataSource") and the use of <property> elements seems antiquated, so I must admit I'm a little confused. - -chris -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.17 (Darwin) Comment: GPGTools - http://gpgtools.org Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk9/MWAACgkQ9CaO5/Lv0PCcOgCeJcRA6Oq2KcVSDE6vIAmQ+5Ji lJUAoL4QiLp1oZSBVkiaFYTrJTlK6Gkv =wFzD -----END PGP SIGNATURE----- --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org