Spring Boot @Transactional Attribute with Multiple DataSource

Question

Hi I have two different methods and they use different datasources and transaction manager.I use @Transactional attribute and what I want, if my second method throws exception than my first method do its rollback. But it is not working, first method cant rollback. What am I missing?

@Transactional(rollbackFor = Exception.class, isolation = Isolation.READ_COMMITTED,
    transactionManager = myTransactionManager", propagation = Propagation.REQUIRED)
public void saveTest(TblTest testEntity)  {

    mySecondDBSource.saveTest2(testEntity);(use MyTransactionManager2) //Do job

    testTableRepository.save(testEntity); (Use myTransactionManager) //throws Exception

}

//in mySecondDBSource class there is another method
@Transactional(rollbackFor = Exception.class, isolation = Isolation.READ_COMMITTED,
    transactionManager = "MyTransactionManager2", propagation = Propagation.REQUIRED)
public void saveTest2(TblTest2 testEntity) {

    testTableRepository2.save(testEntity);

}

score 4 · Accepted Answer · answered Mar 10 '20 at 11:23

4

Spring Data offers a way to handle so called chained/distributed transactions via ChainedTransactionManager.

See spring-transactional-with-a-transaction-across-multiple-data-sources.

Here is also a simple guide on medium.

answered Mar 10 '20 at 11:23

kluckow

181
1
4

Yes it is working.Is it best way or different solutions?Regards – Bilgehan Mar 10 '20 at 12:23
So far I didn't step over any other solution using the 'spring way'. – kluckow Mar 10 '20 at 12:57
This post might also prove useful: https://metamorphant.de/blog/posts/2021-03-21-distributed-transactions-across-multiple-dbs-chainedtransactionmanager/ – dribnif Mar 31 '21 at 20:41

Spring Boot @Transactional Attribute with Multiple DataSource

1 Answers1