How to handle conficts and reconciliation issue

[amitshekhar]

We are trying to Integrate 2 systems. We have a Java Application and Database in between integrating both the systems for handling Bi-directional flow of data using event-based approach and Web services. There are couple of queries:

1. There is a maximum possibility that Integrating Application and Database can go down.Despite handling through Clustering and Load Balancing, how can we ensure that data is in sync and transactions gets committed properly without causing any conflicts?

2. Updates can happen on the same ticket from both ends at the same time. One of the user changes Priority on a ticket in JIRA. At the same time a user updates the Workflow status from Open to Close. The Integrating Java Application & Database goes down. When the Integrating Database and Application is started, how can we technically handle the events so that there is no loss of data?

[DarrylBurke]

This is a forum, not a homework service.

db

[Fubarable]

Agree with Darryl. Poster please read the link on "how to ask smart questions" in my signature below. Since the original post is not a specific question but rather a homework dump, I'm locking this thread, but I invite the original poster to repost a new question that actually is a specific question and where he shows his work.