topic Re: Database update conflict resolution in Alfresco Archive

Database update conflict resolution

cshar — Wed, 03 Jun 2015 21:44:16 GMT

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

Re: Database update conflict resolution

martin_grofcik — Thu, 04 Jun 2015 06:31:20 GMT

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

Re: Database update conflict resolution

cshar — Fri, 05 Jun 2015 18:26:46 GMT

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!

Re: Database update conflict resolution

jbarrez — Fri, 12 Jun 2015 09:39:18 GMT

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.