<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: Human task API, how to move forward in the workflow ?
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/jcharnet">John Augusto Charnet</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/614943#614943">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Here is the complete log.</p><p>It has hibernate statements and the jbpm console logger.</p><p>I can't see through the jbpm console logger, anything related to the complete task. But if you see the hibernate statemens, you will find some updates to the task table, the last update sets the status to Completed.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks</p><p>Hibernate: </p><p>    select</p><p>        task0_.id as col_0_0_,</p><p>        deadline1_.id as col_1_0_,</p><p>        deadline1_.deadline_date as col_2_0_ </p><p>    from</p><p>        Task task0_,</p><p>        Deadline deadline1_ </p><p>    where</p><p>        (</p><p>            deadline1_.id in (</p><p>                select</p><p>                    startdeadl2_.id </p><p>                from</p><p>                    Deadline startdeadl2_ </p><p>                where</p><p>                    task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id</p><p>            ) </p><p>            or deadline1_.id in (</p><p>                select</p><p>                    enddeadlin3_.id </p><p>                from</p><p>                    Deadline enddeadlin3_ </p><p>                where</p><p>                    task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id</p><p>            )</p><p>        ) </p><p>        and deadline1_.escalated=0 </p><p>    order by</p><p>        deadline1_.deadline_date</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE RULEFLOW VARIABLE CHANGED ator=Joao process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>AFTER RULEFLOW VARIABLE CHANGED ator=Joao process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE RULEFLOW STARTED process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE PROCESS NODE EXITED node:Start[id=1] process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]</p><p>Hello world!</p><p>Date: Wed Jul 13 11:31:50 BRT 2011</p><p>BEFORE RULEFLOW VARIABLE CHANGED action=Hello process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>AFTER RULEFLOW VARIABLE CHANGED action=Hello process:test.b[id=test.bpmn]</p><p>Context: org.drools.spi.ProcessContext@d68b39</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE PROCESS NODE EXITED node:Hello World[id=2] process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>BEFORE PROCESS NODE TRIGGERED node:User Task[id=9] process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>AFTER PROCESS NODE TRIGGERED node:User Task[id=9] process:test.b[id=test.bpmn]</p><p>AFTER PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]</p><p>AFTER PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]</p><p>AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]</p><p>AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]</p><p>AFTER RULEFLOW STARTED process:test.b[id=test.bpmn]</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    select</p><p>        user_.id </p><p>    from</p><p>        OrganizationalEntity user_ </p><p>    where</p><p>        user_.id=?</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    select</p><p>        hibernate_sequence.nextval </p><p>    from</p><p>        dual</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        Task</p><p>        (allowedToDelegate, taskInitiator_id, priority, activationTime, actualOwner_id, createdBy_id, createdOn, documentAccessType, documentContentId, documentType, expirationTime, faultAccessType, faultContentId, faultName, faultType, outputAccessType, outputContentId, outputType, parentId, previousStatus, processInstanceId, skipable, status, workItemId, id) </p><p>    values</p><p>        (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        I18NText</p><p>        (language, text, id) </p><p>    values</p><p>        (?, ?, ?)</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        I18NText</p><p>        (language, text, id) </p><p>    values</p><p>        (?, ?, ?)</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        I18NText</p><p>        (language, text, id) </p><p>    values</p><p>        (?, ?, ?)</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        Content</p><p>        (content, id) </p><p>    values</p><p>        (?, ?)</p><p>Hibernate: </p><p>    update</p><p>        Task </p><p>    set</p><p>        allowedToDelegate=?,</p><p>        taskInitiator_id=?,</p><p>        priority=?,</p><p>        activationTime=?,</p><p>        actualOwner_id=?,</p><p>        createdBy_id=?,</p><p>        createdOn=?,</p><p>        documentAccessType=?,</p><p>        documentContentId=?,</p><p>        documentType=?,</p><p>        expirationTime=?,</p><p>        faultAccessType=?,</p><p>        faultContentId=?,</p><p>        faultName=?,</p><p>        faultType=?,</p><p>        outputAccessType=?,</p><p>        outputContentId=?,</p><p>        outputType=?,</p><p>        parentId=?,</p><p>        previousStatus=?,</p><p>        processInstanceId=?,</p><p>        skipable=?,</p><p>        status=?,</p><p>        workItemId=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    update</p><p>        I18NText </p><p>    set</p><p>        Task_Descriptions_Id=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    update</p><p>        I18NText </p><p>    set</p><p>        Task_Names_Id=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        PeopleAssignments_BAs</p><p>        (task_id, entity_id) </p><p>    values</p><p>        (?, ?)</p><p>Hibernate: </p><p>    insert </p><p>    into</p><p>        PeopleAssignments_PotOwners</p><p>        (task_id, entity_id) </p><p>    values</p><p>        (?, ?)</p><p>Hibernate: </p><p>    update</p><p>        I18NText </p><p>    set</p><p>        Task_Subjects_Id=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    select</p><p>        task0_.id as col_0_0_,</p><p>        task0_.processInstanceId as col_1_0_,</p><p>        i18ntext4_.text as col_2_0_,</p><p>        subjects3_.text as col_3_0_,</p><p>        i18ntext5_.text as col_4_0_,</p><p>        task0_.status as col_5_0_,</p><p>        task0_.priority as col_6_0_,</p><p>        task0_.skipable as col_7_0_,</p><p>        task0_.actualOwner_id as col_8_0_,</p><p>        task0_.createdBy_id as col_9_0_,</p><p>        task0_.createdOn as col_10_0_,</p><p>        task0_.activationTime as col_11_0_,</p><p>        task0_.expirationTime as col_12_0_ </p><p>    from</p><p>        Task task0_ </p><p>    left outer join</p><p>        OrganizationalEntity user1_ </p><p>            on task0_.createdBy_id=user1_.id </p><p>    left outer join</p><p>        OrganizationalEntity user2_ </p><p>            on task0_.actualOwner_id=user2_.id </p><p>    left outer join</p><p>        I18NText subjects3_ </p><p>            on task0_.id=subjects3_.Task_Subjects_Id,</p><p>        I18NText i18ntext4_,</p><p>        I18NText i18ntext5_,</p><p>        OrganizationalEntity organizati6_ </p><p>    where</p><p>        organizati6_.id=? </p><p>        and (</p><p>            organizati6_.id in (</p><p>                select</p><p>                    potentialo9_.entity_id </p><p>                from</p><p>                    PeopleAssignments_PotOwners potentialo9_ </p><p>                where</p><p>                    task0_.id=potentialo9_.task_id</p><p>            )</p><p>        ) </p><p>        and i18ntext4_.language=? </p><p>        and (</p><p>            i18ntext4_.id in (</p><p>                select</p><p>                    names10_.id </p><p>                from</p><p>                    I18NText names10_ </p><p>                where</p><p>                    task0_.id=names10_.Task_Names_Id</p><p>            )</p><p>        ) </p><p>        and (</p><p>            subjects3_.language=? </p><p>            or (</p><p>                select</p><p>                    count(subjects11_.Task_Subjects_Id) </p><p>                from</p><p>                    I18NText subjects11_ </p><p>                where</p><p>                    task0_.id=subjects11_.Task_Subjects_Id</p><p>            )=0</p><p>        ) </p><p>        and (</p><p>            i18ntext5_.language=? </p><p>            and (</p><p>                i18ntext5_.id in (</p><p>                    select</p><p>                        descriptio12_.id </p><p>                    from</p><p>                        I18NText descriptio12_ </p><p>                    where</p><p>                        task0_.id=descriptio12_.Task_Descriptions_Id</p><p>                )</p><p>            ) </p><p>            or (</p><p>                select</p><p>                    count(descriptio13_.Task_Descriptions_Id) </p><p>                from</p><p>                    I18NText descriptio13_ </p><p>                where</p><p>                    task0_.id=descriptio13_.Task_Descriptions_Id</p><p>            )=0</p><p>        ) </p><p>        and (</p><p>            task0_.status in (</p><p>                'Created' , 'Ready' , 'Reserved' , 'InProgress' , 'Suspended'</p><p>            )</p><p>        ) </p><p>        and (</p><p>            task0_.expirationTime is null</p><p>        )</p><p>Hibernate: </p><p>    select</p><p>        user0_.id as id10_0_ </p><p>    from</p><p>        OrganizationalEntity user0_ </p><p>    where</p><p>        user0_.id=? </p><p>        and user0_.DTYPE='User'</p><p>Hibernate: </p><p>    select</p><p>        task0_.id as id15_3_,</p><p>        task0_.allowedToDelegate as allowedT2_15_3_,</p><p>        task0_.taskInitiator_id as taskIni23_15_3_,</p><p>        task0_.priority as priority15_3_,</p><p>        task0_.activationTime as activati4_15_3_,</p><p>        task0_.actualOwner_id as actualO24_15_3_,</p><p>        task0_.createdBy_id as createdBy25_15_3_,</p><p>        task0_.createdOn as createdOn15_3_,</p><p>        task0_.documentAccessType as document6_15_3_,</p><p>        task0_.documentContentId as document7_15_3_,</p><p>        task0_.documentType as document8_15_3_,</p><p>        task0_.expirationTime as expirati9_15_3_,</p><p>        task0_.faultAccessType as faultAc10_15_3_,</p><p>        task0_.faultContentId as faultCo11_15_3_,</p><p>        task0_.faultName as faultName15_3_,</p><p>        task0_.faultType as faultType15_3_,</p><p>        task0_.outputAccessType as outputA14_15_3_,</p><p>        task0_.outputContentId as outputC15_15_3_,</p><p>        task0_.outputType as outputType15_3_,</p><p>        task0_.parentId as parentId15_3_,</p><p>        task0_.previousStatus as previou18_15_3_,</p><p>        task0_.processInstanceId as process19_15_3_,</p><p>        task0_.skipable as skipable15_3_,</p><p>        task0_.status as status15_3_,</p><p>        task0_.workItemId as workItemId15_3_,</p><p>        user1_.id as id10_0_,</p><p>        user2_.id as id10_1_,</p><p>        user3_.id as id10_2_ </p><p>    from</p><p>        Task task0_ </p><p>    left outer join</p><p>        OrganizationalEntity user1_ </p><p>            on task0_.taskInitiator_id=user1_.id </p><p>    left outer join</p><p>        OrganizationalEntity user2_ </p><p>            on task0_.actualOwner_id=user2_.id </p><p>    left outer join</p><p>        OrganizationalEntity user3_ </p><p>            on task0_.createdBy_id=user3_.id </p><p>    where</p><p>        task0_.id=?</p><p>Hibernate: </p><p>    update</p><p>        Task </p><p>    set</p><p>        allowedToDelegate=?,</p><p>        taskInitiator_id=?,</p><p>        priority=?,</p><p>        activationTime=?,</p><p>        actualOwner_id=?,</p><p>        createdBy_id=?,</p><p>        createdOn=?,</p><p>        documentAccessType=?,</p><p>        documentContentId=?,</p><p>        documentType=?,</p><p>        expirationTime=?,</p><p>        faultAccessType=?,</p><p>        faultContentId=?,</p><p>        faultName=?,</p><p>        faultType=?,</p><p>        outputAccessType=?,</p><p>        outputContentId=?,</p><p>        outputType=?,</p><p>        parentId=?,</p><p>        previousStatus=?,</p><p>        processInstanceId=?,</p><p>        skipable=?,</p><p>        status=?,</p><p>        workItemId=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    select</p><p>        task0_.id as id15_3_,</p><p>        task0_.allowedToDelegate as allowedT2_15_3_,</p><p>        task0_.taskInitiator_id as taskIni23_15_3_,</p><p>        task0_.priority as priority15_3_,</p><p>        task0_.activationTime as activati4_15_3_,</p><p>        task0_.actualOwner_id as actualO24_15_3_,</p><p>        task0_.createdBy_id as createdBy25_15_3_,</p><p>        task0_.createdOn as createdOn15_3_,</p><p>        task0_.documentAccessType as document6_15_3_,</p><p>        task0_.documentContentId as document7_15_3_,</p><p>        task0_.documentType as document8_15_3_,</p><p>        task0_.expirationTime as expirati9_15_3_,</p><p>        task0_.faultAccessType as faultAc10_15_3_,</p><p>        task0_.faultContentId as faultCo11_15_3_,</p><p>        task0_.faultName as faultName15_3_,</p><p>        task0_.faultType as faultType15_3_,</p><p>        task0_.outputAccessType as outputA14_15_3_,</p><p>        task0_.outputContentId as outputC15_15_3_,</p><p>        task0_.outputType as outputType15_3_,</p><p>        task0_.parentId as parentId15_3_,</p><p>        task0_.previousStatus as previou18_15_3_,</p><p>        task0_.processInstanceId as process19_15_3_,</p><p>        task0_.skipable as skipable15_3_,</p><p>        task0_.status as status15_3_,</p><p>        task0_.workItemId as workItemId15_3_,</p><p>        user1_.id as id10_0_,</p><p>        user2_.id as id10_1_,</p><p>        user3_.id as id10_2_ </p><p>    from</p><p>        Task task0_ </p><p>    left outer join</p><p>        OrganizationalEntity user1_ </p><p>            on task0_.taskInitiator_id=user1_.id </p><p>    left outer join</p><p>        OrganizationalEntity user2_ </p><p>            on task0_.actualOwner_id=user2_.id </p><p>    left outer join</p><p>        OrganizationalEntity user3_ </p><p>            on task0_.createdBy_id=user3_.id </p><p>    where</p><p>        task0_.id=?</p><p>Hibernate: </p><p>    select</p><p>        subtaskstr0_.Task_Id as Task4_1_,</p><p>        subtaskstr0_.id as id1_,</p><p>        subtaskstr0_.id as id16_0_,</p><p>        subtaskstr0_.name as name16_0_,</p><p>        subtaskstr0_.DTYPE as DTYPE16_0_ </p><p>    from</p><p>        SubTasksStrategy subtaskstr0_ </p><p>    where</p><p>        subtaskstr0_.Task_Id=?</p><p>Hibernate: </p><p>    update</p><p>        Task </p><p>    set</p><p>        allowedToDelegate=?,</p><p>        taskInitiator_id=?,</p><p>        priority=?,</p><p>        activationTime=?,</p><p>        actualOwner_id=?,</p><p>        createdBy_id=?,</p><p>        createdOn=?,</p><p>        documentAccessType=?,</p><p>        documentContentId=?,</p><p>        documentType=?,</p><p>        expirationTime=?,</p><p>        faultAccessType=?,</p><p>        faultContentId=?,</p><p>        faultName=?,</p><p>        faultType=?,</p><p>        outputAccessType=?,</p><p>        outputContentId=?,</p><p>        outputType=?,</p><p>        parentId=?,</p><p>        previousStatus=?,</p><p>        processInstanceId=?,</p><p>        skipable=?,</p><p>        status=?,</p><p>        workItemId=? </p><p>    where</p><p>        id=?</p><p>Hibernate: </p><p>    select</p><p>        task0_.id as id15_3_,</p><p>        task0_.allowedToDelegate as allowedT2_15_3_,</p><p>        task0_.taskInitiator_id as taskIni23_15_3_,</p><p>        task0_.priority as priority15_3_,</p><p>        task0_.activationTime as activati4_15_3_,</p><p>        task0_.actualOwner_id as actualO24_15_3_,</p><p>        task0_.createdBy_id as createdBy25_15_3_,</p><p>        task0_.createdOn as createdOn15_3_,</p><p>        task0_.documentAccessType as document6_15_3_,</p><p>        task0_.documentContentId as document7_15_3_,</p><p>        task0_.documentType as document8_15_3_,</p><p>        task0_.expirationTime as expirati9_15_3_,</p><p>        task0_.faultAccessType as faultAc10_15_3_,</p><p>        task0_.faultContentId as faultCo11_15_3_,</p><p>        task0_.faultName as faultName15_3_,</p><p>        task0_.faultType as faultType15_3_,</p><p>        task0_.outputAccessType as outputA14_15_3_,</p><p>        task0_.outputContentId as outputC15_15_3_,</p><p>        task0_.outputType as outputType15_3_,</p><p>        task0_.parentId as parentId15_3_,</p><p>        task0_.previousStatus as previou18_15_3_,</p><p>        task0_.processInstanceId as process19_15_3_,</p><p>        task0_.skipable as skipable15_3_,</p><p>        task0_.status as status15_3_,</p><p>        task0_.workItemId as workItemId15_3_,</p><p>        user1_.id as id10_0_,</p><p>        user2_.id as id10_1_,</p><p>        user3_.id as id10_2_ </p><p>    from</p><p>        Task task0_ </p><p>    left outer join</p><p>        OrganizationalEntity user1_ </p><p>            on task0_.taskInitiator_id=user1_.id </p><p>    left outer join</p><p>        OrganizationalEntity user2_ </p><p>            on task0_.actualOwner_id=user2_.id </p><p>    left outer join</p><p>        OrganizationalEntity user3_ </p><p>            on task0_.createdBy_id=user3_.id </p><p>    where</p><p>        task0_.id=?</p><p>Hibernate: </p><p>    select</p><p>        workitemin0_.workItemId as workItemId3_0_,</p><p>        workitemin0_.creationDate as creation2_3_0_,</p><p>        workitemin0_.name as name3_0_,</p><p>        workitemin0_.processInstanceId as processI4_3_0_,</p><p>        workitemin0_.state as state3_0_,</p><p>        workitemin0_.OPTLOCK as OPTLOCK3_0_,</p><p>        workitemin0_.workItemByteArray as workItem7_3_0_ </p><p>    from</p><p>        WorkItemInfo workitemin0_ </p><p>    where</p><p>        workitemin0_.workItemId=?</p><p>Hibernate: </p><p>    select</p><p>        names0_.Task_Names_Id as Task5_1_,</p><p>        names0_.id as id1_,</p><p>        names0_.id as id11_0_,</p><p>        names0_.language as language11_0_,</p><p>        names0_.text as text11_0_ </p><p>    from</p><p>        I18NText names0_ </p><p>    where</p><p>        names0_.Task_Names_Id=?</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/614943#614943">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>