1 Reply Latest reply on Feb 26, 2010 7:04 AM by Scott Brodersen

    Multiple activities "Execute SQL statement" in transaction

    FabioSpiga Level 1

      I have defined a process with multiple activities "Execute SQL statement".

      Then, I noticed that when an INSERT SQL fails, and the other ones success, the transaction does not rollback all the statements.

      I have configured the process as "short-lived" with transaction settings -> propagation = REQUIRES NEW, but it does not put in a unique transaction all the activities.

      How can I do?

       

      Thanks,

      Fabio