Hi all,
I'm using Jboss 4.0.3SP1 and Oracle JDBC Drivers 9i and 10g (on two different cases) and I need to implement a Database cluster failover on both cases. Using RAC to manage Oracle failover.
After many searches on web (including Oracle) I saw this type of usage on oracle-ds.xml:
<jndi-name>OracleDS</jndi-name>
<connection-url>jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=on)(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx1)(PORT=1521))
(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xx.xx.xx2)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=SID)(FAILOVER_MODE=(TYPE=select)(DELAY=15)(RETRIES=20))))</connection-url>