tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Michael <sg...@gmx.net>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Mon, 05 Mar 2012 20:41:52 GMT
Chema schrieb:
>>> Do you have testOnBorrow="true" and a validationQuery="SELECT 1 FROM
>>> DUAL" configured?
>>>
>>> This should suffice to ensure each connection is valid before use.
>>
>> Pid,
>>
>> works like a charms. Thanks very much.
>>
> 
>>From Tomcat doc for testOnBorrow setting:
> 
> "The indication of whether objects will be validated before being
> borrowed from the pool. If the object fails to validate, it will be
> dropped from the pool, and we will attempt to borrow another
> For a true value to have any effect, the validationQuery parameter
> must be set to a non-null string. Default value is false In order to
> have a more efficient validation, see validationInterval Default value
> is false"
> 
> I don't understand how it works now
> 
> By the way, what does "validate" a object ?

It executes the validation query and checks if there is no SQLException.

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message