[jboss-user] [jBPM] - Problem yith Human Task query
Fred DERNBACH
do-not-reply at jboss.com
Thu Jan 17 05:10:53 EST 2013
Fred DERNBACH [https://community.jboss.org/people/fdernb] created the discussion
"Problem yith Human Task query"
To view the discussion, visit: https://community.jboss.org/message/792549#792549
--------------------------------------------------------------
Hi,
I'm setting up JBPM 5.4.0.Final over hibernate and Oracle. I'm using LocalTaskService, JPA 1 persistence unit over hibernate. It is working, a sample process can be started.
But I'm struggling with a named query that does not return tasks while it should.
To retrieve tasks, I'm now trying to call:
public List<TaskSummary> getTasksAssignedAsPotentialOwnerByStatus(String userId, List<Status> status, String language) of LocalTaskService .
That calls JPA named query *TasksAssignedAsPotentialOwnerByStatus* included in Taskorm.xml file.
For parameter 'status' (a list is expected), I'm passing an ArrayList of size 1 with org.jbpm.task.Status.Ready enum value in it.
JPA Query does not retrieve any task while it should.
I've logged generated SQL and when run nativtely on database, it returns records as expected.
However, the log file shows that the *binding of 'status' list parameter does not serialize correctly*. See log file below in *red*. The status list is binded in binary format !
Any idea what is wrong ?
Fred
*JPA query (extract of Taskorm.xml, see status binding variable in red):*
</named-query>
<named-query name="TasksAssignedAsPotentialOwnerByStatus">
<query>
select
new org.jbpm.task.query.TaskSummary(
t.id,
t.taskData.processInstanceId,
name.text,
subject.text,
description.text,
t.taskData.status,
t.priority,
t.taskData.skipable,
actualOwner,
createdBy,
t.taskData.createdOn,
t.taskData.activationTime,
t.taskData.expirationTime,
t.taskData.processId,
t.taskData.processSessionId)
from
Task t
left join t.taskData.createdBy as createdBy
left join t.taskData.actualOwner as actualOwner
left join t.subjects as subject
left join t.descriptions as description
left join t.names as name,
OrganizationalEntity potentialOwners
where
t.archived = 0 and
potentialOwners.id = :userId and
potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and
(
name.language = :language
or t.names.size = 0
) and
(
subject.language = :language
or t.subjects.size = 0
) and
(
description.language = :language
or t.descriptions.size = 0
) and
t.taskData.status in (*:status*) and
t.taskData.expirationTime is null
</query>
*Log file* *(see binding of status list variable in red)**:*
DEBUG 11439685[RMICallHandler-20](Printer.java:106) - listing entities:
DEBUG 11439685[RMICallHandler-20](Printer.java:113) - org.jbpm.task.User{id=ITCH}
DEBUG 11439685[RMICallHandler-20](Printer.java:113) - org.jbpm.task.Group{id=SECURITY_GLOBAL}
DEBUG 11439700[RMICallHandler-20](Printer.java:113) - org.jbpm.task.Group{id=SECURITY_AUTHORITY}
DEBUG 11439700[RMICallHandler-20](DefaultAutoFlushEventListener.java:76) - Dont need to execute flush
DEBUG 11439700[RMICallHandler-20](HQLQueryPlan.java:174) - find: select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, name.text, subject.text, description.text, t.taskData.status, t.priority, t.taskData.skipable, actualOwner, createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processSessionId) from Task t left join t.taskData.createdBy as createdBy left join t.taskData.actualOwner as actualOwner left join t.subjects as subject left join t.descriptions as description left join t.names as name, OrganizationalEntity potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds0_, :groupIds1_) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and ( name.language = :language or t.names.size = 0 ) and ( subject.language = :language or t.subjects.size = 0 ) and ( description.language = :language or t.descriptions.size = 0 ) and t.taskData.status in (:status) and t.taskData.expirationTime is null
DEBUG 11439732[RMICallHandler-20](SerializationHelper.java:114) - Starting serialization of object [Ready]
DEBUG 11439732[RMICallHandler-20](QueryParameters.java:278) - named parameters: {userId=ITCH, groupIds1_=SECURITY_AUTHORITY, groupIds0_=SECURITY_GLOBAL, status=2c6d8085fef28094eff2e7aeeae2f0edaef4e1f3ebaed3f4e1f4f5f38080808080808080928080f8f2808eeae1f6e1aeece1eee7aec5eef5ed8080808080808080928080f8f0f48085d2e5e1e4f9, language=en-UK}
DEBUG 11439732[RMICallHandler-20](QueryTranslatorImpl.java:307) - HQL: select new org.jbpm.task.query.TaskSummary( t.id, t.taskData.processInstanceId, name.text, subject.text, description.text, t.taskData.status, t.priority, t.taskData.skipable, actualOwner, createdBy, t.taskData.createdOn, t.taskData.activationTime, t.taskData.expirationTime, t.taskData.processId, t.taskData.processSessionId) from org.jbpm.task.Task t left join t.taskData.createdBy as createdBy left join t.taskData.actualOwner as actualOwner left join t.subjects as subject left join t.descriptions as description left join t.names as name, org.jbpm.task.OrganizationalEntity potentialOwners where t.archived = 0 and ( potentialOwners.id = :userId or potentialOwners.id in (:groupIds0_, :groupIds1_) ) and potentialOwners in elements ( t.peopleAssignments.potentialOwners ) and ( name.language = :language or t.names.size = 0 ) and ( subject.language = :language or t.subjects.size = 0 ) and ( description.language = :language or t.descriptions.size = 0 ) and t.taskData.status in (:status) and t.taskData.expirationTime is null
DEBUG 11439747[RMICallHandler-20](QueryTranslatorImpl.java:308) - SQL: select user2_.id as id67_0_, user1_.id as id67_1_, task0_.id as col_0_0_, task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_, descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_, task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_, task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0 )and((organizati6_.id=? )or(organizati6_.id in(? , ?)))and(organizati6_.id in(select potentialo7_.entity_id from PeopleAssignments_PotOwners potentialo7_ where task0_.id=potentialo7_.task_id))and((names5_.language=? )or((select count(names8_.Task_Names_Id) from I18NText names8_ where task0_.id=names8_.Task_Names_Id)=0 ))and((subjects3_.language=? )or((select count(subjects9_.Task_Subjects_Id) from I18NText subjects9_ where task0_.id=subjects9_.Task_Subjects_Id)=0 ))and((descriptio4_.language=? )or((select count(descriptio10_.Task_Descriptions_Id) from I18NText descriptio10_ where task0_.id=descriptio10_.Task_Descriptions_Id)=0 ))and(task0_.status in(?))and(task0_.expirationTime is null )
DEBUG 11439763[RMICallHandler-20](AbstractBatcher.java:410) - about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
DEBUG 11439763[RMICallHandler-20](ConnectionManager.java:444) - opening JDBC connection
DEBUG 11439763[RMICallHandler-20](SQLStatementLogger.java:111) - select user2_.id as id67_0_, user1_.id as id67_1_, task0_.id as col_0_0_, task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_, descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_, task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_, task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0 )and((organizati6_.id=? )or(organizati6_.id in(? , ?)))and(organizati6_.id in(select potentialo7_.entity_id from PeopleAssignments_PotOwners potentialo7_ where task0_.id=potentialo7_.task_id))and((names5_.language=? )or((select count(names8_.Task_Names_Id) from I18NText names8_ where task0_.id=names8_.Task_Names_Id)=0 ))and((subjects3_.language=? )or((select count(subjects9_.Task_Subjects_Id) from I18NText subjects9_ where task0_.id=subjects9_.Task_Subjects_Id)=0 ))and((descriptio4_.language=? )or((select count(descriptio10_.Task_Descriptions_Id) from I18NText descriptio10_ where task0_.id=descriptio10_.Task_Descriptions_Id)=0 ))and(task0_.status in(?))and(task0_.expirationTime is null )
13/01/16 19:00:57 Hibernate: select user2_.id as id67_0_, user1_.id as id67_1_, task0_.id as col_0_0_, task0_.processInstanceId as col_1_0_, names5_.text as col_2_0_, subjects3_.text as col_3_0_, descriptio4_.text as col_4_0_, task0_.status as col_5_0_, task0_.priority as col_6_0_, task0_.skipable as col_7_0_, user2_.id as col_8_0_, user1_.id as col_9_0_, task0_.createdOn as col_10_0_, task0_.activationTime as col_11_0_, task0_.expirationTime as col_12_0_, task0_.processId as col_13_0_, task0_.processSessionId as col_14_0_ from Task task0_ left outer join OrganizationalEntity user1_ on task0_.createdBy_id=user1_.id left outer join OrganizationalEntity user2_ on task0_.actualOwner_id=user2_.id left outer join I18NText subjects3_ on task0_.id=subjects3_.Task_Subjects_Id left outer join I18NText descriptio4_ on task0_.id=descriptio4_.Task_Descriptions_Id left outer join I18NText names5_ on task0_.id=names5_.Task_Names_Id, OrganizationalEntity organizati6_ where (task0_.archived=0 )and((organizati6_.id=? )or(organizati6_.id in(? , ?)))and(organizati6_.id in(select potentialo7_.entity_id from PeopleAssignments_PotOwners potentialo7_ where task0_.id=potentialo7_.task_id))and((names5_.language=? )or((select count(names8_.Task_Names_Id) from I18NText names8_ where task0_.id=names8_.Task_Names_Id)=0 ))and((subjects3_.language=? )or((select count(subjects9_.Task_Subjects_Id) from I18NText subjects9_ where task0_.id=subjects9_.Task_Subjects_Id)=0 ))and((descriptio4_.language=? )or((select count(descriptio10_.Task_Descriptions_Id) from I18NText descriptio10_ where task0_.id=descriptio10_.Task_Descriptions_Id)=0 ))and(task0_.status in(?))and(task0_.expirationTime is null )
DEBUG 11439778[RMICallHandler-20](AbstractBatcher.java:513) - preparing statement
DEBUG 11439794[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() SECURITY_AUTHORITY -> groupIds1_ [3]
DEBUG 11439794[RMICallHandler-20](NullableType.java:151) - binding 'SECURITY_AUTHORITY' to parameter: 3
DEBUG 11439794[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() ITCH -> userId [1]
DEBUG 11439794[RMICallHandler-20](NullableType.java:151) - binding 'ITCH' to parameter: 1
DEBUG 11439810[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() SECURITY_GLOBAL -> groupIds0_ [2]
DEBUG 11439810[RMICallHandler-20](NullableType.java:151) - binding 'SECURITY_GLOBAL' to parameter: 2
*DEBUG 11439810[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() Ready -> status [7]*
*DEBUG 11439825[RMICallHandler-20](SerializationHelper.java:114) -* *Starting serialization of object [Ready]*
*DEBUG 11439825[RMICallHandler-20](NullableType.java:151) - binding '2c6d8085fef28094eff2e7aeeae2f0edaef4e1f3ebaed3f4e1f4f5f38080808080808080928080f8f2808eeae1f6e1aeece1eee7aec5eef5ed8080808080808080928080f8f0f48085d2e5e1e4f9' to parameter: 7*
*DEBUG 11439841[RMICallHandler-20](SerializationHelper.java:114) - Starting serialization of object [Ready]*
DEBUG 11439841[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() en-UK -> language [4]
DEBUG 11439841[RMICallHandler-20](NullableType.java:151) - binding 'en-UK' to parameter: 4
DEBUG 11439857[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() en-UK -> language [5]
DEBUG 11439857[RMICallHandler-20](NullableType.java:151) - binding 'en-UK' to parameter: 5
DEBUG 11439857[RMICallHandler-20](Loader.java:1772) - bindNamedParameters() en-UK -> language [6]
DEBUG 11439872[RMICallHandler-20](NullableType.java:151) - binding 'en-UK' to parameter: 6
DEBUG 11439950[RMICallHandler-20](AbstractBatcher.java:426) - about to open ResultSet (open ResultSets: 0, globally: 0)
DEBUG 11439966[RMICallHandler-20](Loader.java:717) - processing result set
DEBUG 11439966[RMICallHandler-20](Loader.java:744) - done processing result set (0 rows)
DEBUG 11439966[RMICallHandler-20](AbstractBatcher.java:433) - about to close ResultSet (open ResultSets: 1, globally: 1)
DEBUG 11439981[RMICallHandler-20](AbstractBatcher.java:418) - about to close PreparedStatement (open PreparedStatements: 1, globally: 1)
DEBUG 11439981[RMICallHandler-20](AbstractBatcher.java:562) - closing statement
DEBUG 11439981[RMICallHandler-20](ConnectionManager.java:427) - aggressively releasing JDBC connection
DEBUG 11439997[RMICallHandler-20](ConnectionManager.java:464) - releasing JDBC connection [ (open PreparedStatements: 0, globally: 0) (open ResultSets: 0, globally: 0)]
DEBUG 11439997[RMICallHandler-20](Loader.java:874) - total objects hydrated: 0
DEBUG 11439997[RMICallHandler-20](StatefulPersistenceContext.java:860) - initializing non-lazy collections
DEBUG 11440013[RMICallHandler-20](AbstractPlatformTransactionManager.java:922) - Triggering beforeCommit synchronization
DEBUG 11440013[RMICallHandler-20](AbstractPlatformTransactionManager.java:935) - Triggering beforeCompletion synchronization
DEBUG 11440013[RMICallHandler-20](AbstractPlatformTransactionManager.java:948) - Triggering afterCommit synchronization
DEBUG 11440028[RMICallHandler-20](TransactionSynchronizationManager.java:331) - Clearing transaction synchronization
*persistence.xml:*
<persistence-unit name="org.jbpm.persistence.jta" transaction-type="JTA">
<provider>org.hibernate.ejb.HibernatePersistence</provider>
<jta-data-source>jdbc/HUITDS</jta-data-source>
<!-- Use this if you are using JPA1 / Hibernate3 -->
<mapping-file>META-INF/JBPMorm.xml</mapping-file>
<mapping-file>META-INF/ProcessInstanceInfo.hbm.xml</mapping-file>
<!-- Use this if you are using JPA2 / Hibernate4 -->
<!--mapping-file>META-INF/JBPMorm-JPA2.xml</mapping-file-->
<mapping-file>META-INF/Taskorm.xml</mapping-file>
<!-- JBPM classes -->
<class>org.drools.persistence.info.SessionInfo</class>
<class>org.jbpm.persistence.processinstance.ProcessInstanceInfo</class>
<class>org.drools.persistence.info.WorkItemInfo</class>
<class>org.jbpm.process.audit.ProcessInstanceLog</class>
<class>org.jbpm.process.audit.NodeInstanceLog</class>
<class>org.jbpm.process.audit.VariableInstanceLog</class>
<!-- HumanTask classes -->
<class>org.jbpm.task.Attachment</class>
<class>org.jbpm.task.Content</class>
<class>org.jbpm.task.BooleanExpression</class>
<class>org.jbpm.task.Comment</class>
<class>org.jbpm.task.Deadline</class>
<class>org.jbpm.task.Comment</class>
<class>org.jbpm.task.Deadline</class>
<class>org.jbpm.task.Delegation</class>
<class>org.jbpm.task.Escalation</class>
<class>org.jbpm.task.Group</class>
<class>org.jbpm.task.I18NText</class>
<class>org.jbpm.task.Notification</class>
<class>org.jbpm.task.EmailNotification</class>
<class>org.jbpm.task.EmailNotificationHeader</class>
<class>org.jbpm.task.PeopleAssignments</class>
<class>org.jbpm.task.Reassignment</class>
<class>org.jbpm.task.Status</class>
<class>org.jbpm.task.Task</class>
<class>org.jbpm.task.TaskData</class>
<class>org.jbpm.task.SubTasksStrategy</class>
<class>org.jbpm.task.OnParentAbortAllSubTasksEndStrategy</class>
<class>org.jbpm.task.OnAllSubTasksEndParentEndStrategy</class>
<class>org.jbpm.task.User</class>
<properties>
<property name="hibernate.max_fetch_depth" value="3"/>
<!-- Do not allow DDL statement at deployment time -->
<!--
<property name="hibernate.hbm2ddl.auto" value="update"/>
-->
<!-- Show/hide SQL statement at runtime -->
<!--
<property name="hibernate.show_sql" value="false"/>
-->
<property name="hibernate.show_sql" value="true"/>
<!-- Set Oracle dialect for hibernate -->
<!--
<property name="hibernate.dialect" value="org.hibernate.dialect.H2Dialect"/>
-->
*<property name="hibernate.dialect" value="org.hibernate.dialect.Oracle10gDialect"/>*
<!-- Use OC4J transaction manager -->
<!--
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.BTMTransactionManagerLookup" />
-->
<property name="hibernate.transaction.manager_lookup_class" value="org.hibernate.transaction.OC4JTransactionManagerLookup" />
<!-- Toplink-related setting: needed since the problem revolved around a conflicting versions of antlr.jar.
Hibernate depends uses version of antlr.jar (antlr 2.7.6 I believe) and Oracle Application Server (OC4J)
has a conflicting version of antlr.jar enabled by default in its TopLink library for object-relational mapping
-->
<property name="hibernate.query.factory_class" value="org.hibernate.hql.classic.ClassicQueryTranslatorFactory" />
</properties>
</persistence-unit>
--------------------------------------------------------------
Reply to this message by going to Community
[https://community.jboss.org/message/792549#792549]
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/20130117/a0d7aee1/attachment-0001.html
More information about the jboss-user
mailing list