We have implemented JBPM Workflow in our application and is integrated with Spring MVC. Now we are planning to handle all the Workflow related DB operations from within the Workflow. We thought of two options.
1) Define Script Task for invoking the DAO class to do the DB operations from the Workflow
2) Define custom Service Task and invoke the DAO from the WorkItemHandler corresponding to the Service Task.
We would like to get the opinion on this design approach to keep the Workflow related DB operations inside the Workflow, and also on the above two options. Which would be the right approach?
If we go with the second one of having a Service Task, then we need to generalize the WorkItemHandler to be used in many situations, which would be slightly tricky.
We would like to get the suggestion from JBPM experts.
Thanks in advance...