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.