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: anonymous wrote : | <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> This seems to work fine. Does anyone uses it and have experienced any kind of problem? Many thanks, Sérgio View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3964936#3964936 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3964936 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
