[JBoss JIRA] Created: (AS7-1218) Ability to specify a delay between URL round-robin attempts in HA datasource
11 a.m.
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
2:20 p.m.
New subject: [JBoss JIRA] Commented: (AS7-1218) Ability to specify a delay between URL round-robin attempts in HA datasource
[
https://issues.jboss.org/browse/AS7-1218?page=com.atlassian.jira.plugin.s...
]
Daniel Marchese commented on AS7-1218:
--------------------------------------
I was hoping that I could obtain a good result using the existing <allocation-retry>
and <allocation-retry-wait-millis> with a single URL pointing to the RAC instance
but it is not working as expected because these 2 properties are not replicated to the
TxConnectionManager instance.
I have tried to set the properties manually in debug mode and it works.
Here is my datasource configuration :
{code:java}
<local-tx-datasource>
<jndi-name>jdbc/ds</jndi-name>
<rar-name>jboss-local-jdbc.rar</rar-name>
<use-java-context>false</use-java-context>
<connection-definition>javax.sql.DataSource</connection-definition>
<jmx-invoker-name>jboss:service=invoker,type=jrmp</jmx-invoker-name>
<min-pool-size>0</min-pool-size>
<max-pool-size>10</max-pool-size>
<blocking-timeout-millis>30000</blocking-timeout-millis>
<idle-timeout-minutes>30</idle-timeout-minutes>
<prefill>false</prefill>
<background-validation>false</background-validation>
<background-validation-millis>0</background-validation-millis>
<validate-on-match>true</validate-on-match>
<statistics-formatter>org.jboss.resource.statistic.pool.JBossDefaultSubPoolStatisticFormatter</statistics-formatter>
<isSameRM-override-value>false</isSameRM-override-value>
<allocation-retry>2</allocation-retry>
<allocation-retry-wait-millis>10000</allocation-retry-wait-millis>
<application-managed-security xsi:type="securityMetaData"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"/>
<metadata>
<type-mapping>Oracle9i</type-mapping>
</metadata>
<type-mapping>Oracle9i</type-mapping>
<local-transaction/>
<user-name>XXXX</user-name>
<password>XXXX</password>
<check-valid-connection-sql>SELECT * FROM
DUAL</check-valid-connection-sql>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
<prepared-statement-cache-size>0</prepared-statement-cache-size>
<share-prepared-statements>false</share-prepared-statements>
<set-tx-query-timeout>false</set-tx-query-timeout>
<query-timeout>0</query-timeout>
<use-try-lock>60000</use-try-lock>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<connection-url>jdbc:oracle:oci:@(DESCRIPTION=(ENABLE=BROKEN)(LOAD_BALANCE=off)(FAILOVER=on)(ADDRESS=(PROTOCOL=tcp)(HOST=cluster-scan)(PORT=1528))(CONNECT_DATA=(SERVICE_NAME=RAC_INSTANCE)(FAILOVER_MODE=(TYPE=select)(METHOD=basic)(RETRIES=180)(DELAY=1))))</connection-url>
</local-tx-datasource>
{code}
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
4:57 p.m.
New subject: [JBoss JIRA] (AS7-1218) Ability to specify a delay between URL round-robin attempts in HA datasource
[
https://issues.jboss.org/browse/AS7-1218?page=com.atlassian.jira.plugin.s...
]
Jason Greene updated AS7-1218:
------------------------------
Fix Version/s: Open To Community
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
Fix For: Open To Community
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.
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
4:57 p.m.
New subject: [JBoss JIRA] (AS7-1218) Ability to specify a delay between URL round-robin attempts in HA datasource
[
https://issues.jboss.org/browse/AS7-1218?page=com.atlassian.jira.plugin.s...
]
Jason Greene commented on AS7-1218:
-----------------------------------
If anyone is interested in working on a patch, join #jboss-as7 and ping jpederse
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
Fix For: Open To Community
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.
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
5393
days inactive
5512
days old
3 comments
3 participants
participants (3)
-
Daniel Marchese (JIRA) -
Jason Greene (Commented) (JIRA)
-
Jason Greene (Updated) (JIRA)