topic activti support ROWLOCK？ in Alfresco Archive

activti support ROWLOCK？

郭凤旭 — Wed, 14 Dec 2016 06:27:32 GMT

activiti work with database,is support rowlock?

Re: activti support ROWLOCK？

openpj — Wed, 14 Dec 2016 08:05:14 GMT

I'm wondering why you are asking this, I mean when you work with Enterprise platforms similar to Activiti or Alfresco you should never consider the specific supported storage system that you have behind the API.

Enterprise systems allows you to directly work using an API without considering any constraints or capabilities related to the database or the file system that is a huge good point.

In any case, if Activiti supports rowlock or not, your way to create your own Workflow platform will not change at all.

Anyway if you want more details about the Activiti database you can take a look at this thread in the community:

Hope this helps

Re: activti support ROWLOCK？

郭凤旭 — Wed, 14 Dec 2016 08:19:07 GMT

thank you for your reply!

i do pressure test,i fond activiti excute "select * from ACT_RU_VARIABLE where TASK_ID_ = ? and NAME_= ?" failed! ,because tatble [ACT_RU_VARIABLE ] is locked!

Re: activti support ROWLOCK？

openpj — Wed, 14 Dec 2016 08:20:51 GMT

Could you please describe your environment?

Activiti edition and version
Operating system
DBMS

and all the details that you can share with us.

Re: activti support ROWLOCK？

郭凤旭 — Wed, 14 Dec 2016 09:37:03 GMT

Activiti version = 5.20

System:

name=windows7_x64

coreNum=4

memory=12G

DBql server 2014