tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chema <demablo...@gmail.com>
Subject Re: [Tomcat JDBC Pool] Close pooled connections via JMX
Date Mon, 05 Mar 2012 20:48:22 GMT
2012/3/5 Michael <sgfan@gmx.net>:
> 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.
>>>
>>

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

Thanks ...but , if you only restart the remote db , the query "SELECT
1 FROM DUAL" always works , am I wrong ?

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


Mime
View raw message