Spring boot Service Layer Tranction not working

Question

i am trying to achieve spring boot Transaction service layer bit not able to achieve:

Here is my code


@Service
public class EmpService {

    @Autowired
    EmployeeDao employeeDao;
    
    @Autowired
    EmployeeRepo empRepo;
    
    @Autowired
    EmployeeHealthInsuranceRepo healthRepo;
    
    @Transactional
    public void insertEmployee1(Employee employee,EmployeeHealthInsurance employeeHealthInsurance) {
        
            empRepo.save(employee);
            System.out.println(100/0);
            healthRepo.save(employeeHealthInsurance);
        
    
    
    }
    
    
    public void insertEmployee(Employee employee,EmployeeHealthInsurance employeeHealthInsurance) {
        insertEmployee1(employee,employeeHealthInsurance);

        }
}

i am expecting roll back if any error occuer from database or any code level

Maybe this helps: https://stackoverflow.com/questions/7125837/why-does-transaction-roll-back-on-runtimeexception-but-not-sqlexception — Jens, Feb 27 '23 at 08:07
java.lang.ArithmeticException: / by zero at com.example.transation.service.EmpService.insertEmployee1(EmpService.java:30) — Admin Metaversity, Feb 27 '23 at 08:15

score 1 · Answer 1 · answered Feb 27 '23 at 08:25

The issue happens when you call insertEmployee1(...) from insertEmployee(...)

The @Transactional annotation does not extend to the insertEmployee(...) method.

Try adding @Transactional above insertEmployee(...) for it to be transactional too.

Hope it helps.

Spring boot Service Layer Tranction not working

1 Answers1