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]
_______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user