[jboss-jira] [JBoss JIRA] (JBJCA-724) Support system property to disable validation of JDBC JCA recovery connection

[Jesper Pedersen (Resolved) (JIRA)]

     [ https://issues.jboss.org/browse/JBJCA-724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesper Pedersen resolved JBJCA-724.
-----------------------------------

    Fix Version/s: 1.0.7.Final
                   1.1.0.Alpha5
       Resolution: Done


Added a org.jboss.jca.core.recovery.ConfigurableRecoveryPlugin class to deal with this
                
> Support system property to disable validation of JDBC JCA recovery connection
> -----------------------------------------------------------------------------
>
>                 Key: JBJCA-724
>                 URL: https://issues.jboss.org/browse/JBJCA-724
>             Project: IronJacamar
>          Issue Type: Feature Request
>          Components: JDBC
>            Reporter: Justin Bertram
>            Assignee: Jesper Pedersen
>             Fix For: 1.0.7.Final, 1.1.0.Alpha5
>
>
> Whenever the JBossTS transaction recovery manager asks for an XAResource from a JDBC XA datasource we call java.sql.Connection.isValid(int) to ensure the connection is valid. However, in DB2 a call to java.sql.Connection.isValid(int) causes the connection made from the DB2 JDBC driver to the back-end DB2 RDBMS to become "active" which prevents an administrative shutdown of the DB2 RDBMS instance. To deal with this quirk in the DB2 implementation of java.sql.Connection.isValid(int) and since we cannot change the configuration schema at this point we should support a new system property named "recover-connection-validation" which can be used to turn the validation off, e.g.:
>   -Drecover-connection-validation=false
> Using "false" for "recover-connection-validation" will force the recovery connection used for an XA JDBC datasource to be re-created every time the JBossTS transaction recovery manager asks for it.
> In the future we can change the configuration schema to support this functionality directly.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira