« Return to Thread: DBCP and Firewall timeouts

Re: DBCP and Firewall timeouts

by David Smith-2 :: Rate this Message:

Christopher Schultz wrote:

> David,
>
> On 7/1/2009 10:49 AM, David Smith wrote:
> > It would and the performance hit is minimal if you use the ping syntax
> > in your validation query. I believe it looks like this:
>
> > validationQuery="/* ping */ SELECT 1"
>
> Note that both the PING is only applicable for MySQL when using
> Connector/J, and "SELECT 1" may only be applicable on certain databases
> (MySQL being one of them).
>
> -chris

Right and I double checked the original post that started this thread.
AD described the environment as having MySQL 5.1

--David

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

« Return to Thread: DBCP and Firewall timeouts