[jboss-user] [jBPM] - Hibernate queries on jBPM DB tables

[Laura delli Paoli]

Laura delli Paoli [https://community.jboss.org/people/lauradp] created the discussion

"Hibernate queries on jBPM DB tables"

To view the discussion, visit: https://community.jboss.org/message/821535#821535

--------------------------------------------------------------
Hello everybody,
I'm trying to make a query jBPM task table, but I always get an empty list even if I can see result by DB UI.

My mapping is:

<class name="MyTask" table="task" dynamic-insert="true" dynamic-update="true">
                    <subselect>
                              select id, priority, processId, processInstanceId, processSessionId, status, workItemId
                              from task
                    </subselect>
                    <id column="id" name="id" type="java.lang.Long" />
                    <property name="priority" column="priority" type="java.lang.Integer" />
                    <property name="processId" column="processId" type="java.lang.String" />
                    <property name="processInstanceId" column="processInstanceId" type="java.lang.Long" />
                    <property name="processSessionId" column="processSessionId" type="java.lang.Integer" />
                    <property name="status" column="status" type="java.util.String" />
                    <property name="workItemId" column="workItemId" type="java.lang.Long" />
          </class>

the query is:
session.createCriteria(MyTask.class).add(Restrictions.eq("processInstanceId", new Long(pid))).list();

Am I missing somethin??
thanks 
Laura
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/821535#821535]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130605/b0a7b676/attachment-0001.html