I can't understand the behavior difference between the PROPAGATION_REQUIRES_NEW and PROPAGATION_NESTED propagation policies. It seems to me that in both cases, the current process is rollbacked but not the whole transaction. Any clue?
82
votes
See this link: forum.springsource.org/archive/index.php/t-16594.html -- Juergen Hoeller explain it very well
- Ralph
@Ralph: thank you, that's exactly what I was looking for. You should add it as an answer.
- Alexis Dufrenoy
@Ralph : great, that would be a best answer.
- Nandkumar Tekale
So the main difference is that with a nested transaction policy, the transaction can be rollbacked to the beginning to the current atomic operation, which is the same as in a requires_new policy, but it will only be commited at the end of the whole process, which is completly different from the requires_new policy, where each atomic operation will be commited when it ends.
- Alexis Dufrenoy
@Ralph unfortunately, your link no longer points to an existing page :(
- knittl
3 Answers
120
votes
See this link: PROPAGATION_NESTED versus PROPAGATION_REQUIRES_NEW? Juergen Hoeller explain it very well. -- the Spring Source Forum is completely offline sice February 28, 2019, but you can read the relevant part of the article in the quote below
PROPAGATION_REQUIRES_NEW starts a new, independent "inner" transaction for the given scope. This transaction will be committed or rolled back completely independent from the outer transaction, having its own isolation scope, its own set of locks, etc. The outer transaction will get suspended at the beginning of the inner one, and resumed once the inner one has completed. ...
PROPAGATION_NESTED on the other hand starts a "nested" transaction, which is a true subtransaction of the existing one. What will happen is that a savepoint will be taken at the start of the nested transaction. Íf the nested transaction fails, we will roll back to that savepoint. The nested transaction is part of of the outer transaction, so it will only be committed at the end of of the outer transaction. ...
15
votes
PROPAGATION_REQUIRES_NEW : uses a completely independent transaction for each affected transaction scope. In that case, the underlying physical transactions are different and hence can commit or roll back independently, with an outer transaction not affected by an inner transaction's rollback status.
PROPAGATION_NESTED : uses a single physical transaction with multiple savepoints that it can roll back to. Such partial rollbacks allow an inner transaction scope to trigger a rollback for its scope, with the outer transaction being able to continue the physical transaction despite some operations having been rolled back. This setting is typically mapped onto JDBC savepoints, so will only work with JDBC resource transactions.
check spring documentation
-6
votes
Please find the difference
1.) Use of NESTED Transaction
Execute within a nested transaction if a current transaction exists, behave like PROPAGATION_REQUIRED else. Nested transaction is supporting by Spring
2.)Use of REQUIRED Transaction Support a current transaction, create a new one if none exists. . It means for banking domain like withdraw,deposit, update the transaction
3.) Use of REQUIRES_NEW Transaction Create a new transaction, and suspend the current transaction if one exists.
