how to handle transaction management in multi datasource using atomikos?

Question

I am having one application with multiple datasource and i am facing one issue where i am calling both datasource in one transaction and i am getting result from first datasource but when i am trying to get result from second datasource i am getting exception so at that time i want to rollback both the datasource result. so how we can do that using atomikos? or we have any other way to do it? I know one way ChainedTransactionManager but it is deprecated so we can't use it.

Let me know if you have anyways to handle above situation.

My expected result is to find a way to rollback both the datasource result when we get exception in any datasource result.

Answer 1

try PlatformTransactionManager here is the doc https://docs.spring.io/spring-framework/docs/current/javadoc-api/org/springframework/transaction/PlatformTransactionManager.html .This bloger has the same problem with you https://medium.com/@inzuael/how-to-use-multiple-datasources-with-springboot-exposed-jpa-6bd705bfe994