Anyone in this group can offer some insights on whether JBoss 4.2.3 or other version is able to handle global transaction across multiple nodes among an Oracle RAC?
As Oracle RAC requires that all database operations inside a global transaction be routed to the same Oracle instance, this known limitation means that to handle transaction across nodes (say, there are two EJBs, each connecting to a different DB node. While one EJB is calleing another EJB internally, this asks the App server to handle the transaction of EBJs with connections to two different DB node.), app server needs to route all operations within on global transation to the same node.
WebLogic use Multi Data Sources to handling transactions across RAC nodes. It basically sends all operations within one global transaction to one single DB node. Do we have similar solution in JBoss?