[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