'How to rollback if data save/update is failed in anyone database in spring boot?

I need to save/update data into two different database (oracle & db2). If data save failed in anyone database, it should rollback the data in other database. I am using spring boot 2.6.6. After some research i planned to use chainedTransactionManager. But it is deprecated. do we have any other way to achieve my scenario ?

spring-bootspring-data-jpajtadistributed-transactionsxa


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions

Composite Primary Key using MongoDB and Spring Data JPA

Postman returns null when using POST (Spring Boot)

How to set default current date in jpa for mysql

JPA Repository.findById() returns null but the value is exist on db

Possibly consider using a shorter maxLifetime value - hikari connection pool spring boot

How do I update an entity using spring-data-jpa?

Can't Autowire @Repository annotated interface in Spring Boot

When does the hibernate session gets closed

getting Caused by: org.hibernate.QueryException: cannot dereference scalar collection element: roles

Unable to find a @SpringBootConfiguration, you need to use @ContextConfiguration or @SpringBootTest(classes=...) with your test

How to limit result in @Query used in Spring Data Repository

Spring data repository not found at compile time

JPA created too many fields in table

Fundamentals.How can you use Lazy fetching in Spring+Hibernate+=Vaadin after the session closes

How to tell what action was taken by the JPA save method