Best is to get it from the api (including the query api) and not use the database directly. What is the issue you have?
I am able to successfully deploy the process definition and able to start the process instance with process definition key.
My requirement is the workflow (process instance) should move to the next step in workflow process after some user interaction. But i am not sure from which table i can get the process instance id for that process deifnition so that i can signal it. Also how to get the process instance id from table for that specific process definition.
Please clarify me
Thaks for your response
When creating the ProcessInstance, you will get a processInstanceId back. Save it.
The processInstanceId is the key into the jBPM API world.
If you want to find out all the current tasks (often only 1) for your process instance then you do this:
Then if you want to bump the Task on to the next one ... do something like this:
outcomes = taskService.getOutcomes(tasks.getId()) // gets outcomes just for the first currently running task.
taskService.completeTask( tasks.getId(), yourDesiredOutcome)