[jboss-dev-forums] [Design of JBoss jBPM] - Hibernate and Web Console

[falazar]

We are updating our web console display inbox that shows all the taskinstances available for a user, and have converted it into a datatable, and added sorting and paging.

On the inbox we show the
 Process Name 	 Task Name 	 Process Initiator 	 Task Start Date 	 Task Due Date 	 Task Variable Doc ID 	 Task Variable URL

What is the simplest way to create a Hibernate query to return all these fields, (in general) where it is joining across several tables.

We first were using the internal findTaskInstances() which calls the Named Query: TaskMgmtSession.findTaskInstancesByActorId
And then calling functions to get the other variables, saving all as a list of objects, and sorting.  This was very ineffecient and slow.

So I am looking for a way to use hibernate to return maybe a general generic object that we could contain all of these with.   

I looked at the Criteria package as well, but it seems to only return a single Class object. 

James

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

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