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
