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

[born_free_77]

Let me try this again 

  | <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>
  |  Also if I want to use HA config what would be the url

I did try this in HA

  | <connection-url>jdbc:oracle:thin:@db1:1521:db1|jdbc:oracle:thin:@db2:1521:db2</connection-url>
  |  and it worked for me



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

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