[jboss-user] [JBoss jBPM] - Hibernate query to get all active instances

[michaelholtzman]

Greetings. As part of our application, I need to display all running process instances. I originally wrote some code to get all definitions (GraphSession.findAllProcessDefinitions()) and then, for each definition get the process instances (GraphSession.findProcessInstances(defnId)). It does what I need, but is very slow.

I am trying to write a hib query to get the process instances in one db access.  I'd like the results grouped by process definition name and version.


  | String q = "from org.jbpm.graph.exe.ProcessInstance as pi" + 
  | 	" where pi.end is null" +
  | 	" order by pi.processDefinition.name pi.processDefinition.version pi.start " ;
  |    	Query qry = jbpmContext.getSession().createQuery(q);
  |    	result = qry.list();
  | 

This produces the following error:

  | 12:52:18,962 ERROR ErrorCounter : line 1:82: unexpected token: pi
  | 12:52:18,962 WARN  HqlParser : processEqualityExpression() : No expression to process!
  | 12:52:18,962 ERROR Utility : unexpected token: pi near line 1, column 82 [from org.jbpm.graph.exe.ProcessInstance as pi
  | order by pi.processDefinition.name pi.processDefinition.version pi.start ]
  | 

Any suggestions? Thanx.



View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3959966#3959966

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3959966