Announcement Announcement Module
No announcement yet.
Replicating databases maintaining consitency Page Title Module
Move Remove Collapse
Conversation Detail Module
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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:

    * HibernateInterceptor
    * TransactionInterceptor

    cheers, and thanks in advanced.

  • #2
    Since two different databases are involved you will have to use global (JTA) transactions. Please refer to Spring documentation for JTA configuration.