[jboss-user] [jBPM] - Re: Perform DB operations from Workflow

[Maciej Swiderski]

Maciej Swiderski [https://community.jboss.org/people/swiderski.maciej] created the discussion

"Re: Perform DB operations from Workflow"

To view the discussion, visit: https://community.jboss.org/message/795857#795857

--------------------------------------------------------------
I would certainly recommend to go for option number 2. As it is much easier to maintain and you have an option to the the work in async way if that is needed. In script task you make your process definition really tightly coupled with the db operation code which is usually not good practice as it introduces rather difficult ways to manage that code. 
As it comes to making work item handler specific you could simply enclose all db specific code within that handler and configure it via parameters what it shall execute, either by supplying sql queries or sql script files that can differ between activities in the process.

HTH
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/795857#795857]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130204/4ca1eb13/attachment-0001.html