Odds & Ends : Jboss Apps Moving to RAC servers

So we decided to move to the new Oracle RAC servers.

Pre RAC:

We have JEE applications running on Jboss 4.X. These had cute little ds files where we configured the path to the servers as such:

 <xa-datasource-property name="URL">jdbc:oracle:thin:@TheDatabaseDNS:1521:DBServiceString</xa-datasource-property>
 <user-name>SomeUser</user-name>
 <password>SomePass</password>

Post RAC

The xa-datasource property had to be changed to:
<xa-datasource-property name="URL">jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(HOST=DNSToRACHHost1)(PROTOCOL=TCP)(PORT=SomePort)) (ADDRESS =(HOST = DNSToRACHost2)(PROTOCOL  = TCP)(PORT = SomePort))(LOAD_BALANCE = on) (FAILOVER = on) (ENABLE = broken)(CONNECT_DATA=(SERVICE_NAME=SOMESERVICENAME)(SERVER = dedicated) (FAILOVER_MODE = (TYPE = select) (MET OD = basic) (RETRIES = 240) (DELAY = 2))))</xa-datasource-property>


I was not sure this would work as this was nothing like the I had seen till now, but guess what this freaky thing does work.

Check out the following link for more info:
Jboss Oracle Rac config