[jboss-jira] [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} -- This message is automatically generated by JIRA. For more information on JIRA, see: http://www.atlassian.com/software/jira