3 Replies Latest reply on Mar 30, 2006 3:29 PM by Shiung Yong

    Transaction across different DBs

    Shiung Yong Newbie

      Is it possible to have JBoss transactions span across multiple databases? Here is the scenario:

      Session Bean A is reading from database A.
      Session Bean B reads/writes from database B, then calls a method from session bean A. If this method fails, what happens right now is that the changes to database B are permanent instead of being rolled back.

      I'm not using manually demarcated transactions, relying instead on container support to handle all the transactions for me. What is a workaround for this problem?

      I'm using JBoss 4.0.2 and EJB3 session/entity beans.

      Please advise, thank you!