[jboss-user] [Datasource Configuration] - Is background connection validation without on-the-fly validation possible?

Bojan Dolinar do-not-reply at jboss.com
Thu Sep 9 10:58:10 EDT 2010

Bojan Dolinar [http://community.jboss.org/people/bodzolca] created the discussion

"Is background connection validation without on-the-fly validation possible?"

To view the discussion, visit: http://community.jboss.org/message/560596#560596


I want background validation only and I expected this to be the motivation for background-validation tag. When enabled, however, this option works only with check-valid-connection-sql, but this always comes with validation on connection check-out. Doesn't this defeat the purpose of background-validation? What am I missing?

I'm using JBoss AS 4.2.2.GA.

This is part of configuration that I'm using:
<!-- Validation works only when next line is not commented, but validation also happens at connection check-out -->
<!--<check-valid-connection-sql>select count(*) from gu_gemaSystemSettings</check-valid-connection-sql>-->

Thx for help!

Reply to this message by going to Community

Start a new discussion in Datasource Configuration at Community

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20100909/be45c78a/attachment-0001.html 

More information about the jboss-user mailing list