[jboss-user] [JCA] - Re: Oracle Failover connection url

[vickyk]

"born_free_77" wrote : 
  | Any idea what I am missing, Does any one has sample ds files?
  | 
Check this
http://anonsvn.jboss.org/repos/jbossas/branches/JBPAPP_4_2/testsuite/src/resources/jca/ha/test-ha-ds.xml
http://anonsvn.jboss.org/repos/jbossas/branches/JBPAPP_4_2/testsuite/src/resources/jca/ha/test-ha-xa-ds.xml

Also using oracle RAC and configuring ha-datasource should be done exclusively, I have not seen people combining it but it looks possible.
Anyway the right connection-url for oracle-RAC should be like this 
<connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(host=xxxxhost1)(port=1521))(address=(protocol=tcp)(host=xxxxhost2)(port=1521)))(connect_data=(service_name=xxxxsid)(failover_mode=(type=select)(method=basic))))</connection-url>
You can find more details here 
http://www.jboss.org/community/wiki/SetupAOracleDataSource


View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4260254#4260254

Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4260254