Folks.
I have been researching how to connect jboss to a two node oracle rac 10gr2.
My understanding to date is that load balancing is not possible using XA datasources with
oracle RAC 10g.
In the weblogic arena, this is possible using multipools, but I do not see any
similar feature for jboss?. (4.0.4GA in use currently).
This all leads me to conclude that loadbalanced XA transactions are not
supported in jboss with an oracle rac backend. Could anyone shed any light on this
conclusion Agree/Disagree?
Also from the wiki
http://wiki.jboss.org/wiki/Wiki.jsp?page=SetUpAOracleDatasource, I found this jdbc
connection string for connection to an oracle rac.
<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>
I believe that the "load_balance=on" needs to be set to
"load_balance=off", since this is not supported.
Also, the failover mechanism is not automatic. The service on the oracle rac
is in fact a "singleton service"(ref: "BEST PRACTICES FOR USING XA WITH
RAC, available from oracle's web site). Meaning that it cannot failover by itself.
You will manually need to move this singleton service (eg.from node A to node B) using the
svrctl command.
Does anyone have any knowledge of doing this, or wish to post any comments?
thanks
Sc0tt...
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4074781#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...