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);

}

kluckow · Accepted Answer · 2020-03-10 11:23:07Z

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, 2020 at 11:23

kluckow

1911 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Bilgehan Over a year ago

Yes it is working.Is it best way or different solutions?Regards

kluckow Over a year ago

So far I didn't step over any other solution using the 'spring way'.

dribnif Over a year ago

This post might also prove useful: metamorphant.de/blog/posts/…

Collectives™ on Stack Overflow

Spring Boot @Transactional Attribute with Multiple DataSource

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related