2012/3/5 Michael <[email protected]>: > 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: [email protected] For additional commands, e-mail: [email protected]
