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

[vickyk]

"cbredesen" wrote :  
  | 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.
  | 

I don't think you will have a failed TX , the pool should transparently destroy all the stale connections and create a new one for the application that asks for it .

This will happen if you have configured the check-valid-connection .
All this should be transparent to application .



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

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