tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: jdbc pool properties
Date Fri, 06 Apr 2012 18:09:36 GMT
-----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-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message