topic Re: JPA or JCR to store process related information in Alfresco Archive

JPA or JCR to store process related information

xandros — Tue, 09 Aug 2011 22:12:44 GMT

Hi,I set up Activiti to use my JPA entity to store some of information taken from user during the process execution. All works like a charme. Now at the end of process there is not reference (in history) between process instance and entity stored, then to solve this problem I think is possible to st

Re: JPA or JCR to store process related information

frederikherema1 — Wed, 10 Aug 2011 11:16:57 GMT

You can always create your own VariableType (take a look at JpavariableType etc, and search forum to see how you can plug it in). In this type, you can store any information as a variable, providing you hooks to save/load variables when they are needed using the exact logic you require.

Re: JPA or JCR to store process related information

xandros — Wed, 10 Aug 2011 12:55:19 GMT

I look at JPAEntityVariableType and I see in the inital comment like this:

"Variable type capable of storing reference to JPA-entities"

the I use this in my process definition:


<serviceTask id="servicetask1" name="Create User Request" activiti:expression="${requestService.create(initiator)}" 
activiti:resultVariable="userRequest"></serviceTask>

where the expression create and return JPA entity


 public Request create(String creator){
  logger.info("User " + creator + " create new request.");
  Request entity = new Request();
  entity.setCreator(creator);
  return jpaRequestDao.saveOrUpdate(entity);
 }

then at the end of process I have my Entity stored in DB.
I suppose than the reference of my JPA is stored in process variable userRequest.
Where I can see this reference in Activiti Database (for history retrieve)?

Thanks

Re: JPA or JCR to store process related information

xandros — Wed, 10 Aug 2011 14:26:57 GMT

Debugging applciation I can see that:

- during process execution the JPA reference is stored in ACT_RU_VARIABLE.
- ended the process the JPA reference is removed from ACT_RU_VARIABLE but is not inserted in ACT_HI_DETAIL as I aspected.

Can you help me to understand please.

Re: JPA or JCR to store process related information

xandros — Wed, 10 Aug 2011 14:35:24 GMT

Solved

Setting

<property name="history" value="full" />

Also JPA reference will be stored in history!
Good, hidden but works…

I hope this info can help other users.
Thanks.

Re: JPA or JCR to store process related information

ronald_van_kuij — Wed, 10 Aug 2011 15:08:03 GMT

this is not only true for jpa references but for all variables. If history != full they will not be preserved after the process ends