[jboss-jira] [JBoss JIRA] Created: (AS7-1218) Ability to specify a delay between URL round-robin attempts in HA datasource

[Daniel Marchese (JIRA)]

Ability to specify a delay between URL round-robin attempts in HA datasource
----------------------------------------------------------------------------

                 Key: AS7-1218
                 URL: https://issues.jboss.org/browse/AS7-1218
             Project: Application Server 7
          Issue Type: Feature Request
          Components: JCA
    Affects Versions: 7.0.0.CR1
            Reporter: Daniel Marchese


We have a configuration with Oracle RAC One Node (1 active database, 1 standby database) and we are testing HA possibilities.
In one test, if we try to obtain a connection during the starting of the standby database after the active database crash, we get an ORA-12514 error because the standby instance is not ready to respond.
Besides the fact that Oracle should not return an error but wait for the standby database to be ready to respond, it would be interesting if it was possible to specify a delay between URL round-roubin attempts in the HA datasource (ex: url-retry-wait-millis).
This way, it would be possible to ask JBoss to wait before it tries the next URL in the list, giving the standby database the time to start.

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira