Saturday, May 17, 2003 06:50 AM
I'm not convinced that you need to use EAI when this can be easily accomplished with XA-enabled JDBC connections pools in both websphere and jboss. XA is a protocol that allows multiple transactional resources (such a oracle and db2 databases) to participate in the same transaction and commit or rollback atomically.
First, create a jdbc connection pool with the XA option enabled in both websphere and jboss. You will need a jdbc driver that supports XA (these can be found in your oracle and db2 client installations). Ensure both EJB1 and EJB2 use the XA-enabled JDBC connection. Once you have configured your app servers, you can call EJB1 (in websphere) which may call EJB2 (in jboss). When the transaction completes, everything is committed (or rolledback) atomically.
The advantage of this solution is that it requires no extra programming. It's all done through your app server configuration.