2012/3/5 Michael <sg...@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-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org