[jboss-dev-forums] [Design of JCA on JBoss] - Re: Handling fatal JDBC connection exceptions

[cbredesen]

anonymous wrote : Destroying the stale connection upon receiving the fatal exception Or destroying the stale connections when getting them from the Pool will effectively have the same effect.

No, it would not.  Currently if you have no valid connection checker (or SQL), a fatal exception must be encountered before each individual connection is destroyed. 

Consider a pool of 100 connections against a database that was restarted.  All 100 connections are now invalid, but we don't know until we attempt to use one.  100 failed transactions later, we have a clean pool.

What I'm proposing (based on interaction with a WAS user) is a setting which allows a single fatal exception to kill all connections in the pool because we know they aren't going to be usable.  This way you limit yourself to 1 (or very few) failed transactions.  It's just another way of doing proactive pool management without doing background validation (or validate on match).

-Chris

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4158684#4158684

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4158684