nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

Database update conflict resolution

cshar

I have a requirement where I need to build an approval process to update the database tables. I am building a web application in struts 2 and planning to use activiti as a backend engine via REST api of activiti. I would like to understand if activiti has a built in conflict resolution process that will stop 2 users from updating the same DB values via 2 change requests.

1. User A creates a change request C1 to update database table field FLD_VALUE.
2. User B creates a change request C2 to update same database table field FLD_VALUE for same record.

How can activiti detect this as a conflict and flag these 2 change requests as conflicting? Thanks.

Find more posts tagged with

Comments

martin_grofcik

Hi Cshar,

Activiti BPMN implementation does not cover resources. (You have to detect resource conflict from my point of view).
I see 2 possibilities:
- extend activiti model to cover resources too
- implement resource conflict detection outside of activiti (external service)

Regards
Martin

cshar

Thank you Martin. Could you advise what is the industry standard to handle conflict resolutions? Since you have such an experience on BPM you may have some suggestions around scenarios like these. Thanks!

jbarrez

From a low level point of view, you can use traditional database transactions to make sure no two users are changing data of one element at the same time.