"[EMAIL PROTECTED]" wrote : Also I didn't mention that it requires checking the validity of the connection before it is given to a caller. In the testcase, I use check-valid-connection-sql for that.
This is true regardless of HA. JDBC has no mechanism to signal a broken connection asynchronously. The only way to avoid broken connections being given to the application (where it will find it is broken on first use) is to have a validity checker that checks the connecton is not broken before it is handed out from the pool. http://www.jboss.org/wiki/Wiki.jsp?page=WhatHappensToJBossIfIRestartTheDatabase View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3871182#3871182 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3871182 ------------------------------------------------------- This SF.net email is sponsored by: 2005 Windows Mobile Application Contest Submit applications for Windows Mobile(tm)-based Pocket PCs or Smartphones for the chance to win $25,000 and application distribution. Enter today at http://ads.osdn.com/?ad_id=6882&alloc_id=15148&op=click _______________________________________________ JBoss-Development mailing list JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development
