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

"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/... http://anonsvn.jboss.org/repos/jbossas/branches/JBPAPP_4_2/testsuite/src/... 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#... Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&a...