John Augusto Charnet [
http://community.jboss.org/people/jcharnet] created the discussion
"Re: Human task API, how to move forward in the workflow ?"
To view the discussion, visit:
http://community.jboss.org/message/614943#614943
--------------------------------------------------------------
Here is the complete log.
It has hibernate statements and the jbpm console logger.
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.
Thanks
Hibernate:
select
task0_.id as col_0_0_,
deadline1_.id as col_1_0_,
deadline1_.deadline_date as col_2_0_
from
Task task0_,
Deadline deadline1_
where
(
deadline1_.id in (
select
startdeadl2_.id
from
Deadline startdeadl2_
where
task0_.id=startdeadl2_.Deadlines_StartDeadLine_Id
)
or deadline1_.id in (
select
enddeadlin3_.id
from
Deadline enddeadlin3_
where
task0_.id=enddeadlin3_.Deadlines_EndDeadLine_Id
)
)
and deadline1_.escalated=0
order by
deadline1_.deadline_date
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE RULEFLOW VARIABLE CHANGED ator=Joao process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
AFTER RULEFLOW VARIABLE CHANGED ator=Joao process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE RULEFLOW STARTED process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE PROCESS NODE EXITED node:Start[id=1] process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]
Hello world!
Date: Wed Jul 13 11:31:50 BRT 2011
BEFORE RULEFLOW VARIABLE CHANGED action=Hello process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
AFTER RULEFLOW VARIABLE CHANGED action=Hello process:test.b[id=test.bpmn]
Context: org.drools.spi.ProcessContext@d68b39
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE PROCESS NODE EXITED node:Hello World[id=2] process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
BEFORE PROCESS NODE TRIGGERED node:User Task[id=9] process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
AFTER PROCESS NODE TRIGGERED node:User Task[id=9] process:test.b[id=test.bpmn]
AFTER PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]
AFTER PROCESS NODE TRIGGERED node:Hello World[id=2] process:test.b[id=test.bpmn]
AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]
AFTER PROCESS NODE TRIGGERED node:Start[id=1] process:test.b[id=test.bpmn]
AFTER RULEFLOW STARTED process:test.b[id=test.bpmn]
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
select
user_.id
from
OrganizationalEntity user_
where
user_.id=?
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
select
hibernate_sequence.nextval
from
dual
Hibernate:
insert
into
Task
(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)
values
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate:
insert
into
I18NText
(language, text, id)
values
(?, ?, ?)
Hibernate:
insert
into
I18NText
(language, text, id)
values
(?, ?, ?)
Hibernate:
insert
into
I18NText
(language, text, id)
values
(?, ?, ?)
Hibernate:
insert
into
Content
(content, id)
values
(?, ?)
Hibernate:
update
Task
set
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=?
where
id=?
Hibernate:
update
I18NText
set
Task_Descriptions_Id=?
where
id=?
Hibernate:
update
I18NText
set
Task_Names_Id=?
where
id=?
Hibernate:
insert
into
PeopleAssignments_BAs
(task_id, entity_id)
values
(?, ?)
Hibernate:
insert
into
PeopleAssignments_PotOwners
(task_id, entity_id)
values
(?, ?)
Hibernate:
update
I18NText
set
Task_Subjects_Id=?
where
id=?
Hibernate:
select
task0_.id as col_0_0_,
task0_.processInstanceId as col_1_0_,
i18ntext4_.text as col_2_0_,
subjects3_.text as col_3_0_,
i18ntext5_.text as col_4_0_,
task0_.status as col_5_0_,
task0_.priority as col_6_0_,
task0_.skipable as col_7_0_,
task0_.actualOwner_id as col_8_0_,
task0_.createdBy_id as col_9_0_,
task0_.createdOn as col_10_0_,
task0_.activationTime as col_11_0_,
task0_.expirationTime as col_12_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,
I18NText i18ntext4_,
I18NText i18ntext5_,
OrganizationalEntity organizati6_
where
organizati6_.id=?
and (
organizati6_.id in (
select
potentialo9_.entity_id
from
PeopleAssignments_PotOwners potentialo9_
where
task0_.id=potentialo9_.task_id
)
)
and i18ntext4_.language=?
and (
i18ntext4_.id in (
select
names10_.id
from
I18NText names10_
where
task0_.id=names10_.Task_Names_Id
)
)
and (
subjects3_.language=?
or (
select
count(subjects11_.Task_Subjects_Id)
from
I18NText subjects11_
where
task0_.id=subjects11_.Task_Subjects_Id
)=0
)
and (
i18ntext5_.language=?
and (
i18ntext5_.id in (
select
descriptio12_.id
from
I18NText descriptio12_
where
task0_.id=descriptio12_.Task_Descriptions_Id
)
)
or (
select
count(descriptio13_.Task_Descriptions_Id)
from
I18NText descriptio13_
where
task0_.id=descriptio13_.Task_Descriptions_Id
)=0
)
and (
task0_.status in (
'Created' , 'Ready' , 'Reserved' ,
'InProgress' , 'Suspended'
)
)
and (
task0_.expirationTime is null
)
Hibernate:
select
user0_.id as id10_0_
from
OrganizationalEntity user0_
where
user0_.id=?
and user0_.DTYPE='User'
Hibernate:
select
task0_.id as id15_3_,
task0_.allowedToDelegate as allowedT2_15_3_,
task0_.taskInitiator_id as taskIni23_15_3_,
task0_.priority as priority15_3_,
task0_.activationTime as activati4_15_3_,
task0_.actualOwner_id as actualO24_15_3_,
task0_.createdBy_id as createdBy25_15_3_,
task0_.createdOn as createdOn15_3_,
task0_.documentAccessType as document6_15_3_,
task0_.documentContentId as document7_15_3_,
task0_.documentType as document8_15_3_,
task0_.expirationTime as expirati9_15_3_,
task0_.faultAccessType as faultAc10_15_3_,
task0_.faultContentId as faultCo11_15_3_,
task0_.faultName as faultName15_3_,
task0_.faultType as faultType15_3_,
task0_.outputAccessType as outputA14_15_3_,
task0_.outputContentId as outputC15_15_3_,
task0_.outputType as outputType15_3_,
task0_.parentId as parentId15_3_,
task0_.previousStatus as previou18_15_3_,
task0_.processInstanceId as process19_15_3_,
task0_.skipable as skipable15_3_,
task0_.status as status15_3_,
task0_.workItemId as workItemId15_3_,
user1_.id as id10_0_,
user2_.id as id10_1_,
user3_.id as id10_2_
from
Task task0_
left outer join
OrganizationalEntity user1_
on task0_.taskInitiator_id=user1_.id
left outer join
OrganizationalEntity user2_
on task0_.actualOwner_id=user2_.id
left outer join
OrganizationalEntity user3_
on task0_.createdBy_id=user3_.id
where
task0_.id=?
Hibernate:
update
Task
set
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=?
where
id=?
Hibernate:
select
task0_.id as id15_3_,
task0_.allowedToDelegate as allowedT2_15_3_,
task0_.taskInitiator_id as taskIni23_15_3_,
task0_.priority as priority15_3_,
task0_.activationTime as activati4_15_3_,
task0_.actualOwner_id as actualO24_15_3_,
task0_.createdBy_id as createdBy25_15_3_,
task0_.createdOn as createdOn15_3_,
task0_.documentAccessType as document6_15_3_,
task0_.documentContentId as document7_15_3_,
task0_.documentType as document8_15_3_,
task0_.expirationTime as expirati9_15_3_,
task0_.faultAccessType as faultAc10_15_3_,
task0_.faultContentId as faultCo11_15_3_,
task0_.faultName as faultName15_3_,
task0_.faultType as faultType15_3_,
task0_.outputAccessType as outputA14_15_3_,
task0_.outputContentId as outputC15_15_3_,
task0_.outputType as outputType15_3_,
task0_.parentId as parentId15_3_,
task0_.previousStatus as previou18_15_3_,
task0_.processInstanceId as process19_15_3_,
task0_.skipable as skipable15_3_,
task0_.status as status15_3_,
task0_.workItemId as workItemId15_3_,
user1_.id as id10_0_,
user2_.id as id10_1_,
user3_.id as id10_2_
from
Task task0_
left outer join
OrganizationalEntity user1_
on task0_.taskInitiator_id=user1_.id
left outer join
OrganizationalEntity user2_
on task0_.actualOwner_id=user2_.id
left outer join
OrganizationalEntity user3_
on task0_.createdBy_id=user3_.id
where
task0_.id=?
Hibernate:
select
subtaskstr0_.Task_Id as Task4_1_,
subtaskstr0_.id as id1_,
subtaskstr0_.id as id16_0_,
subtaskstr0_.name as name16_0_,
subtaskstr0_.DTYPE as DTYPE16_0_
from
SubTasksStrategy subtaskstr0_
where
subtaskstr0_.Task_Id=?
Hibernate:
update
Task
set
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=?
where
id=?
Hibernate:
select
task0_.id as id15_3_,
task0_.allowedToDelegate as allowedT2_15_3_,
task0_.taskInitiator_id as taskIni23_15_3_,
task0_.priority as priority15_3_,
task0_.activationTime as activati4_15_3_,
task0_.actualOwner_id as actualO24_15_3_,
task0_.createdBy_id as createdBy25_15_3_,
task0_.createdOn as createdOn15_3_,
task0_.documentAccessType as document6_15_3_,
task0_.documentContentId as document7_15_3_,
task0_.documentType as document8_15_3_,
task0_.expirationTime as expirati9_15_3_,
task0_.faultAccessType as faultAc10_15_3_,
task0_.faultContentId as faultCo11_15_3_,
task0_.faultName as faultName15_3_,
task0_.faultType as faultType15_3_,
task0_.outputAccessType as outputA14_15_3_,
task0_.outputContentId as outputC15_15_3_,
task0_.outputType as outputType15_3_,
task0_.parentId as parentId15_3_,
task0_.previousStatus as previou18_15_3_,
task0_.processInstanceId as process19_15_3_,
task0_.skipable as skipable15_3_,
task0_.status as status15_3_,
task0_.workItemId as workItemId15_3_,
user1_.id as id10_0_,
user2_.id as id10_1_,
user3_.id as id10_2_
from
Task task0_
left outer join
OrganizationalEntity user1_
on task0_.taskInitiator_id=user1_.id
left outer join
OrganizationalEntity user2_
on task0_.actualOwner_id=user2_.id
left outer join
OrganizationalEntity user3_
on task0_.createdBy_id=user3_.id
where
task0_.id=?
Hibernate:
select
workitemin0_.workItemId as workItemId3_0_,
workitemin0_.creationDate as creation2_3_0_,
workitemin0_.name as name3_0_,
workitemin0_.processInstanceId as processI4_3_0_,
workitemin0_.state as state3_0_,
workitemin0_.OPTLOCK as OPTLOCK3_0_,
workitemin0_.workItemByteArray as workItem7_3_0_
from
WorkItemInfo workitemin0_
where
workitemin0_.workItemId=?
Hibernate:
select
names0_.Task_Names_Id as Task5_1_,
names0_.id as id1_,
names0_.id as id11_0_,
names0_.language as language11_0_,
names0_.text as text11_0_
from
I18NText names0_
where
names0_.Task_Names_Id=?
--------------------------------------------------------------
Reply to this message by going to Community
[
http://community.jboss.org/message/614943#614943]
Start a new discussion in jBPM at Community
[
http://community.jboss.org/choose-container!input.jspa?contentType=1&...]