The best way of joining data between JBM and other database?

[juan30mad]

Hello,
We are developing a small application (to manage order, quotes, etc) to try jbpm. We are using an Oracle with two schemas: one for JBPM and another for storing data (orders, quotes and other information about the application). Why is the best way of getting information from DB?. For example: we need a list of all orders in the state "OPEN". We can use JBPM API to get all Instances and then get the information about these orders or We can join the tables.
We aren't using EJM or AX, the tables are really in the same Schema.

thanks

[hannes]

Hi, I am currently laboring with a similar thing. Maybe you extend the JbpmSession and where you can add statements in the hibernate query language. For sure you have to use hibernate also for your existing data model.
I am presently thinking of connecting a certain processInstance to other data by using the context:
processInstance.getContextInstance().createVariable()
any ideas about that?