[jboss-user] [JCA] - Re: Oracle Failover connection url
vickyk
do-not-reply at jboss.com
Wed Oct 14 06:03:47 EDT 2009
"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
More information about the jboss-user
mailing list