topic Re: Data from a table in Alfresco Archive

Data from a table

anjan — Wed, 07 Oct 2015 09:28:02 GMT

Hi, we have integrated our application with Activiti (V 5.17) and we are using Activiti REST for all the tasks (starting the process, adding process variables…etc).One of the process definitions that we are going to create need to fetch data from a database table. This data will be same for all the

Re: Data from a table

martin_grofcik — Thu, 08 Oct 2015 08:40:35 GMT

Hi Anjan,

There are many possibilities. At least two of them:

Spring bean
JPA integration

Read activiti doc please.

Regards
Martin

Re: Data from a table

jbarrez — Thu, 08 Oct 2015 08:50:25 GMT

1. If the data is the same for all instances, why not add your own cache for it that is used in the service task.
2. In that case, i'd store it as a json string

Re: Data from a table

anjan — Thu, 08 Oct 2015 09:17:30 GMT

Hi Martin, I thought about JPA integration. But my use case is just a read from the table, so I thought JPA might be an overkill. But I will think about it.
Joram, caching is a good idea. Are you suggesting me to add this cache on the JVM where Activiti is running (our application and Activiti are running in a separate JVM)? If so, can you please throw some light on how to do this.

Re: Data from a table

anjan — Thu, 08 Oct 2015 11:47:51 GMT

Joram, are you suggesting that I can keep the json string as an instance variable in my Java Service Task. If the variable is not initialized, initialize the same, otherwise re-use it. Is it advisable to keep instance variable in the Java Service Task.

Re: Data from a table

jbarrez — Tue, 13 Oct 2015 10:28:20 GMT

anjan: service tasks are stateless, so you'd have to make it a bit smarter than just a static value, but it all depends on your use case of course.

My comment about json was for the 'storing as Serializable': storing as serializable is not a good idea, hence why i suggested a json representation. However, reading your post, it seems you don't need to have it as a process variable, but some smart caching logic should suffice.