Multi query and transaction

Question

I do some treatment on many data, so i do a loop.

@Transactional
@Override
public void processPayment(List<Long> paymentsId, PaymentModeEnum paymentMode) throws ProcessPaymentException{
   ...
   processCreditCardPayment(payments);
}

private void processCreditCardPayment(List<Payment> payments) throws ProcessPaymentException {
    for (Payment payment : payments) {

         try {
              //save to db
         }catch (ProcessPaymentException ppe) {
         }

    }
}

ProcessPaymentException extends Exception

If I loop on 10 item, on the last one, error happen. Everything is rollbacked (all my item) or only the one in error?

Answer 1

In this case nothing would be rolled back. It is because you caught the exception and it didn't pass Spring transaction boundary.

Read here in Spring Docs:

The recommended way to indicate to the Spring Framework’s transaction infrastructure that a transaction’s work is to be rolled back is to throw an Exception from code that is currently executing in the context of a transaction. The Spring Framework’s transaction infrastructure code will catch any unhandled Exception as it bubbles up the call stack, and make a determination whether to mark the transaction for rollback.