[jboss-user] [JCA] - Re: Oracle Failover connection url
born_free_77
do-not-reply at jboss.com
Wed Oct 14 08:01:03 EDT 2009
Hey Vickyk,
Thanks for the response. I am using the same xml files and I did see the test-ha-ds.xml files.
Initially I was using <connection-url> like this
| <connection-url>jdbc:oracle:thin at xxxxx:1521 at sid|jdbc:oracle:thin at xxxxx:1521 at sid</connection-url>
|
if I use
| <connection-url>jdbc:oracle:thin:@(description=(address_list=(load_balance=on)(failover=on)(address=(protocol=tcp)(h
| ost=xxxxhost1)(port=1521))(address=(protocol=tcp)(host=xxxxhost2)(port=1521)))(connect_data=(service
| _name=xxxxsid)(failover_mode=(type=select)(method=basic))))</connection-url>
|
then jboss complains that url-delimiter is not povided. I did use the same url when using </local-tx-datasource> but this still does not gives me failover.
Whats the difference between <local-tx-datasource> and <ha-local-tx-datasource>?
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4260280#4260280
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4260280
More information about the jboss-user
mailing list