I would second what Ronald mentioned earlier about not trying too hard to store business
keys in JBPM. We have a need to be able to look up processes (and tasks) very quickly by
any one of various business keys: account number, order number, product number, etc. We
created a "Business Keys" table that contains a row for each process instance
and records any of the appropriate business key data in the appropriate column. All
columns are indexed.
This solution is very performant. Because JBPM has some very direct relationships between
processInstance, token, and taskInstance, returning the right tasks based on those
business keys is performant as well.
To populate the table, the act of starting each processInstance calls an ActionHandler
that looks up all the pertinent business keys based on our business logic and domain
model.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4180333#...
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...