topic Re: ACT_RE_PROCDEF modification behaviour in Alfresco Archive

ACT_RE_PROCDEF modification behaviour

rufini — Thu, 11 Aug 2011 15:11:07 GMT

Hi:I'm trying to understand in which cases ACT_RE_PROCDEF is updated to try to reproduce/avoid a bug I had in Activiti 5.6 as described in http://forums.activiti.org/en/viewtopic.php?t=1087&p=9293 (multiple key-version that block the whole app)I see that a new entry is added when I modify a work

Re: ACT_RE_PROCDEF modification behaviour

jbarrez — Fri, 12 Aug 2011 06:11:28 GMT

The only way to get a process definition in the database is through the RepositoryService using the deployment.

The @Deployment annotation for unit tests also uses exactly the same code.

Re: ACT_RE_PROCDEF modification behaviour

rufini — Fri, 12 Aug 2011 14:24:44 GMT

Thanks for your reply, Joram.

I'm now adding a constrain to avoid that a duplicate key+version halt my app in the future.

ALTER TABLE `ACT_RE_PROCDEF` ADD UNIQUE INDEX `KEY_VERSION` (`KEY_` ASC, `VERSION_` ASC) ;
Greetings,
rufini