topic Re: ACT_RE_PROCDEF and ACT_GE_BYTEARRAY relationships in Alfresco Archive

ACT_RE_PROCDEF and ACT_GE_BYTEARRAY relationships

bwd — Wed, 26 Oct 2011 01:18:28 GMT

Hi,I'm trying to get the BPMN XML definition for a given version from the database and associate it with running workflow processes. The BPMN data appears to be stored in the ACT_GE_BYTEARRAY table (in the BYTES_ column). The version information appears to be stored in the ACT_RE_PROCDEF (ID_ colu

Re: ACT_RE_PROCDEF and ACT_GE_BYTEARRAY relationships

trademak — Wed, 26 Oct 2011 07:34:43 GMT

Hi,

Why don't you use the Activiti API for this?

Best regards,

Re: ACT_RE_PROCDEF and ACT_GE_BYTEARRAY relationships

bwd — Wed, 26 Oct 2011 16:18:40 GMT

Using the API would be my preference - and I see how to obtain the desired information for the current version of a deployed BPMN using method on the RepositoryService.

However, I also need information about prior versions of a given BPMN - both the XML definition as well as the key that I can then use to look up active processes - in order to provide dependency analysis support. I can't find APIs for this on either the RepositoryService or the HistoryService, which was why I was looking at the database tables directly.

Are there APIs supporting this that don't require that I iterate over all active processes?

Thanks,

bwd.

Re: ACT_RE_PROCDEF and ACT_GE_BYTEARRAY relationships

bwd — Wed, 26 Oct 2011 18:05:43 GMT

It looks like you can associate ACT_GE_BYTEARRAY rows to ACT_RE_PROCDEF rows by mapping (NAME, DEPLOYMENT_ID_) to (RESOURCE_NAME_, DEPLOYMENT_ID_).

Looks like I have to use SQL to get the bytearray data, and then use the RepositoryService.createProcessDefinitionQuery() query to obtain the associated process definition.

(Don't see an API to get the bytearray data.)

bwd