Sep 13th, 2011, 03:02 PM
Replicating databases maintaining consitency
I 've a system which provisioned data into a database..., today's requieriment is to have two databases and perform certain actions on both databases.
I 've achieved that by using a custom HibernateInterceptor combined with a custom implemntation of AbstractRoutingDatasource.
What I couldn't do is to rollback commit on database1 if action on database2 fails.
could anyone give me a hint on how to make the first transaction rollback if the second fails?
Here I detail the interceptors I got running on my system in order:
cheers, and thanks in advanced.
Sep 14th, 2011, 01:28 PM
Since two different databases are involved you will have to use global (JTA) transactions. Please refer to Spring documentation for JTA configuration.
Tags for this Thread