Thanks, that works like a charm. Actually, I'm surprised that the connection pool wouldn't in all cases check for broken connections by default. It seems like it should just be able to check the state of the socket locally if nothing else. It seems inefficient to have it perform an extra query each time.

Jon

----- Original Message ----- From: "Suavi Ali Demir" <[EMAIL PROTECTED]>
To: "Derby Discussion" <[email protected]>
Sent: Thursday, January 20, 2005 4:21 PM
Subject: Re: Auto-reconnect, connection pool connection validation query question



values(1)

This is valid derby sql.

Regards,
Ali



Reply via email to