AnsweredAssumed Answered

TaskService complete performance issue

Question asked by bcelikcan on Jun 11, 2012
Latest reply on Jun 12, 2012 by ronald.van.kuijk
Hi,

When we call TaskService 's complete method, its taking about 18 seconds. In our process there is a user task before end. So process ends after our call.

I wondering is this normal? 

Thanks
Beslan

[size=85]
11 Jun 2012 13:33:02,448 http-apr-80-exec-8 DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:02,449 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:02,449 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:02,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:02,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:02,794 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:02,794 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067053(String)
11 Jun 2012 13:33:03,298 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:03,298 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String), usertaskKISI(String)
11 Jun 2012 13:33:03,376 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:03,376 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067049(String)
11 Jun 2012 13:33:03,844 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? )
11 Jun 2012 13:33:03,844 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067063(String), sisAtanacakAdayKullanicilar(String), java.io.ByteArrayInputStream@250970c1(ByteArrayInputStream), null
11 Jun 2012 13:33:03,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:03,847 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067064(String), 2067042(String), 2067042(String), 2067057(String), null, sisAtanacakAdayKullanicilar(String), 1(Integer), serializable(String), 2012-06-11 13:33:03.298(Timestamp), 2067063(String), null, null, null, null
11 Jun 2012 13:33:03,849 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? )
11 Jun 2012 13:33:03,849 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067065(String), sisAtanacakAdayGruplar(String), java.io.ByteArrayInputStream@7b119f9e(ByteArrayInputStream), null
11 Jun 2012 13:33:03,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:03,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067066(String), 2067042(String), 2067042(String), 2067057(String), null, sisAtanacakAdayGruplar(String), 1(Integer), serializable(String), 2012-06-11 13:33:03.843(Timestamp), 2067065(String), null, null, null, null
11 Jun 2012 13:33:03,852 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_ = ?
11 Jun 2012 13:33:03,852 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2(Integer), java.io.ByteArrayInputStream@5edc2a37(ByteArrayInputStream), 2067053(String), 1(Integer)
11 Jun 2012 13:33:04,243 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_GE_BYTEARRAY set REV_ = ?, BYTES_ = ? where ID_ = ? and REV_ = ?
11 Jun 2012 13:33:04,243 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2(Integer), java.io.ByteArrayInputStream@c044ac1(ByteArrayInputStream), 2067049(String), 1(Integer)
11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_TASK where ID_ = ?
11 Jun 2012 13:33:04,658 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RE_PROCDEF where ID_ = ?
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: SERBEST_DOLASIM2_TASK_KISI:4:104515(String)
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ?
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ?
11 Jun 2012 13:33:04,674 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:04,689 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where TASK_ID_ = ?
11 Jun 2012 13:33:04,689 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:04,705 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_TASKINST where ID_ = ?
11 Jun 2012 13:33:04,721 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:04,752 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:04,752 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:04,856 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:04,856 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String), usertaskKISI(String)
11 Jun 2012 13:33:04,932 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:04,932 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:05,012 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:05,012 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067067(String)
11 Jun 2012 13:33:05,327 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:05,327 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:05,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RE_PROCDEF where KEY_ = ? and VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?)
11 Jun 2012 13:33:05,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: SERBEST_DOLASIM2_KARAR(String), SERBEST_DOLASIM2_KARAR(String)
1 Jun 2012 13:33:05,557 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:05,557 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067069(String)
11 Jun 2012 13:33:05,623 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:05,624 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (RETRIES_ > 0) and (DUEDATE_ is null or DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0)
11 Jun 2012 13:33:05,624 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:05.623(Timestamp), 2012-06-11 13:33:05.623(Timestamp)
11 Jun 2012 13:33:05,625 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:05,627 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:05,628 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0) order by DUEDATE_
11 Jun 2012 13:33:05,628 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:10.627(Timestamp), 2012-06-11 13:33:10.627(Timestamp)
11 Jun 2012 13:33:05,629 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:05,802 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:05,802 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067069(String)
11 Jun 2012 13:33:05,895 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:05,895 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067053(String)
11 Jun 2012 13:33:06,353 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:06,353 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067049(String)
11 Jun 2012 13:33:06,801 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:06,801 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067080(String)
11 Jun 2012 13:33:07,023 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:07,023 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067081(String)
11 Jun 2012 13:33:07,289 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,289 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067080(String)
11 Jun 2012 13:33:07,296 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,296 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067080(String)
11 Jun 2012 13:33:07,314 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,314 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067081(String)
11 Jun 2012 13:33:07,333 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,333 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067081(String)
11 Jun 2012 13:33:07,351 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,351 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067069(String)
11 Jun 2012 13:33:07,371 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,371 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067069(String)
11 Jun 2012 13:33:07,396 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,396 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067067(String)
11 Jun 2012 13:33:07,413 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,413 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067067(String)
11 Jun 2012 13:33:07,421 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ?
11 Jun 2012 13:33:07,421 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:07,516 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:07,516 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:07,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RE_PROCDEF where ID_ = ?
11 Jun 2012 13:33:07,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: SERBEST_DOLASIM2_KARAR:4:104514(String)
11 Jun 2012 13:33:07,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,645 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:07,666 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:07,666 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:07,675 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:07,675 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String), CallActivityKISI(String)
11 Jun 2012 13:33:07,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:07,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:07,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:07,850 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String), CallActivityKISI(String)
11 Jun 2012 13:33:07,915 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:07,915 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:08,136 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:08,136 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:08,357 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:08,357 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
11 Jun 2012 13:33:08,467 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:08,467 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:08,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:08,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:08,629 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:08,629 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:08,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:08,644 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:08,648 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:08,648 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
1 Jun 2012 13:33:08,739 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:08,740 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:08,756 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:08,756 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:08,757 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:08,757 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:08,862 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:08,862 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:08,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:08,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067027(String)
11 Jun 2012 13:33:09,014 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:09,014 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
11 Jun 2012 13:33:09,244 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:09,244 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
11 Jun 2012 13:33:09,263 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:09,263 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
11 Jun 2012 13:33:09,264 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:09,264 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067027(String)
11 Jun 2012 13:33:09,505 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:09,505 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067027(String)
11 Jun 2012 13:33:09,521 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:09,522 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067027(String)
11 Jun 2012 13:33:09,523 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:09,523 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:09,753 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ?
11 Jun 2012 13:33:09,753 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:09,829 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:09,829 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String)
11 Jun 2012 13:33:09,934 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RE_PROCDEF where ID_ = ?
11 Jun 2012 13:33:09,934 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: SERBEST_DOLASIM2:9:104517(String)
11 Jun 2012 13:33:09,935 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:09,935 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067018(String)
11 Jun 2012 13:33:10,367 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:10,367 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067022(String)
11 Jun 2012 13:33:10,630 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:10,631 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (RETRIES_ > 0) and (DUEDATE_ is null or DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0)
11 Jun 2012 13:33:10,631 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:10.63(Timestamp), 2012-06-11 13:33:10.63(Timestamp)
11 Jun 2012 13:33:10,632 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0) order by DUEDATE_
11 Jun 2012 13:33:10,633 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:15.633(Timestamp), 2012-06-11 13:33:15.633(Timestamp)
11 Jun 2012 13:33:10,634 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:10,815 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:10,815 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:10,831 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:10,831 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:10,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_ACTINST HAI WHERE HAI.EXECUTION_ID_ = ? and HAI.ACT_ID_ = ? and HAI.END_TIME_ is null
11 Jun 2012 13:33:10,846 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String), callactivity1(String)
11 Jun 2012 13:33:10,909 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:10,909 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:11,018 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:11,018 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String)
11 Jun 2012 13:33:11,227 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_EXECUTION where PARENT_ID_ = ?
11 Jun 2012 13:33:11,227 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:11,320 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:11,320 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String)
11 Jun 2012 13:33:11,339 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:11,339 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String)
11 Jun 2012 13:33:11,340 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_VARIABLE where EXECUTION_ID_ = ? and TASK_ID_ is null
11 Jun 2012 13:33:11,340 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:11,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_HI_PROCINST where PROC_INST_ID_ = ?
11 Jun 2012 13:33:11,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:11,642 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:11,642 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067003(String)
11 Jun 2012 13:33:12,087 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:12,087 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067007(String)
11 Jun 2012 13:33:12,531 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select distinct T.* from ACT_RU_TASK T WHERE T.EXECUTION_ID_ = ?
11 Jun 2012 13:33:12,531 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:12,548 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB J WHERE J.EXECUTION_ID_ = ?
11 Jun 2012 13:33:12,548 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:12,550 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,550 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067068(String), SERBEST_DOLASIM2_TASK_KISI:4:104515(String), 2067042(String), 2067067(String), callactivity1(String), Call activity(String), callActivity(String), null, 2012-06-11 13:33:05.011(Timestamp), 2012-06-11 13:33:07.373(Timestamp), 2362(Long)
11 Jun 2012 13:33:12,552 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_PROCINST ( ID_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_, END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,552 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067069(String), 2067069(String), null, SERBEST_DOLASIM2_KARAR:4:104514(String), 2012-06-11 13:33:05.556(Timestamp), 2012-06-11 13:33:07.336(Timestamp), 1780(Long), icaglar(String), null, endevent1(String), 2067042(String)
11 Jun 2012 13:33:12,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,554 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067071(String), 2067069(String), 2067069(String), null, null, sisInbDosyaId(String), 0(Integer), long(String), 2012-06-11 13:33:05.802(Timestamp), null, null, 1305786(Long), 1305786(String), null
11 Jun 2012 13:33:12,555 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? )
11 Jun 2012 13:33:12,555 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067074(String), sisAtanacakAdayKullanicilar(String), java.io.ByteArrayInputStream@48ada913(ByteArrayInputStream), null
11 Jun 2012 13:33:12,556 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,556 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067075(String), 2067069(String), 2067069(String), null, null, sisAtanacakAdayKullanicilar(String), 0(Integer), serializable(String), 2012-06-11 13:33:06.351(Timestamp), 2067074(String), null, null, null, null
11 Jun 2012 13:33:12,558 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_) values ( ?, 1, ?, ?, ? )
11 Jun 2012 13:33:12,558 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067078(String), sisAtanacakAdayGruplar(String), java.io.ByteArrayInputStream@69197dd8(ByteArrayInputStream), null
11 Jun 2012 13:33:12,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,559 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067079(String), 2067069(String), 2067069(String), null, null, sisAtanacakAdayGruplar(String), 0(Integer), serializable(String), 2012-06-11 13:33:06.796(Timestamp), 2067078(String), null, null, null, null
11 Jun 2012 13:33:12,561 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,561 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067082(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067080(String), exclusivegateway9(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.022(Timestamp), 2012-06-11 13:33:07.022(Timestamp), 0(Long)
11 Jun 2012 13:33:12,562 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,562 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067083(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067080(String), exclusivegateway4(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.022(Timestamp), 2012-06-11 13:33:07.022(Timestamp), 0(Long)
11 Jun 2012 13:33:12,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,563 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067084(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067081(String), exclusivegateway10(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.273(Timestamp), 2012-06-11 13:33:07.273(Timestamp), 0(Long)
11 Jun 2012 13:33:12,565 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,565 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067085(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067069(String), 2067081(String), exclusivegateway3(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:07.273(Timestamp), 2012-06-11 13:33:07.273(Timestamp), 0(Long)
11 Jun 2012 13:33:12,566 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,566 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067086(String), 2067015(String), 2067029(String), 2067030(String), null, nrOfCompletedInstances(String), 1(Integer), integer(String), 2012-06-11 13:33:08.467(Timestamp), null, null, 1(Long), 1(String), null
11 Jun 2012 13:33:12,567 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_DETAIL (ID_, TYPE_, PROC_INST_ID_, EXECUTION_ID_, ACT_INST_ID_, TASK_ID_, NAME_, REV_, VAR_TYPE_, TIME_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_) values ( ?, 'VariableUpdate', ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,568 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067087(String), 2067015(String), 2067029(String), 2067030(String), null, nrOfActiveInstances(String), 1(Integer), integer(String), 2012-06-11 13:33:08.467(Timestamp), null, null, 0(Long), 0(String), null
11 Jun 2012 13:33:12,569 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,569 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067088(String), SERBEST_DOLASIM2_KARAR:4:104514(String), 2067015(String), 2067026(String), exclusivegateway4(String), Exclusive Gateway(String), exclusiveGateway(String), null, 2012-06-11 13:33:08.757(Timestamp), 2012-06-11 13:33:08.757(Timestamp), 0(Long)
11 Jun 2012 13:33:12,570 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
11 Jun 2012 13:33:12,570 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067089(String), SERBEST_DOLASIM2:9:104517(String), 2067001(String), 2067001(String), servicetask1(String), Dosyayı Kapat(String), serviceTask(String), null, 2012-06-11 13:33:11.34(Timestamp), 2012-06-11 13:33:11.558(Timestamp), 218(Long)
11 Jun 2012 13:33:12,573 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ?
11 Jun 2012 13:33:12,573 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String), null, 2012-06-11 13:33:10.909(Timestamp), 225527(Long), 2067014(String)
11 Jun 2012 13:33:12,848 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ?
11 Jun 2012 13:33:12,848 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String), null, 2012-06-11 13:33:08.648(Timestamp), 222511(Long), 2067030(String)
11 Jun 2012 13:33:13,127 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ?
11 Jun 2012 13:33:13,127 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String), icaglar(String), 2012-06-11 13:33:04.931(Timestamp), 217964(Long), 2067057(String)
11 Jun 2012 13:33:13,420 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ? where ID_ = ?
11 Jun 2012 13:33:13,420 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String), User Task KISI(String), null, null, null, icaglar(String), 2012-06-11 13:33:04.752(Timestamp), 217785(Long), completed(String), usertaskKISI(String), 50(Integer), null, 2067058(String)
11 Jun 2012 13:33:13,452 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ?
11 Jun 2012 13:33:13,452 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:29:25.606(Timestamp), 2012-06-11 13:33:09.829(Timestamp), 224223(Long), endevent1(String), 2067015(String)
11 Jun 2012 13:33:13,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ?
11 Jun 2012 13:33:13,545 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:29:26.651(Timestamp), 2012-06-11 13:33:07.515(Timestamp), 220864(Long), endevent1(String), 2067042(String)
11 Jun 2012 13:33:13,622 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: update ACT_HI_PROCINST set START_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, END_ACT_ID_ = ? where ID_ = ?
11 Jun 2012 13:33:13,622 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:29:25.149(Timestamp), 2012-06-11 13:33:11.642(Timestamp), 226493(Long), endevent1(String), 2067001(String)
11 Jun 2012 13:33:13,713 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_TASK where ID_ = ?
11 Jun 2012 13:33:13,713 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067058(String)
11 Jun 2012 13:33:13,723 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:13,723 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067054(String)
11 Jun 2012 13:33:13,937 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:13,938 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067053(String)
11 Jun 2012 13:33:14,255 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:14,256 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067050(String)
11 Jun 2012 13:33:14,458 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:14,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067049(String)
11 Jun 2012 13:33:14,790 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:14,790 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067047(String)
11 Jun 2012 13:33:14,994 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:14,995 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067045(String)
11 Jun 2012 13:33:15,198 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:15,198 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067043(String)
11 Jun 2012 13:33:15,399 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:15,399 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067042(String)
11 Jun 2012 13:33:15,512 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:15,512 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067040(String)
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (RETRIES_ > 0) and (DUEDATE_ is null or DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0)
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:15.662(Timestamp), 2012-06-11 13:33:15.662(Timestamp)
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - ooo Connection Opened
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==>  Executing: select * from ACT_RU_JOB where (TYPE_ = 'timer') and (DUEDATE_ is not null) and (DUEDATE_ < ?) and (LOCK_OWNER_ is null or LOCK_EXP_TIME_ < ?) and (RETRIES_ > 0) order by DUEDATE_
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.PreparedStatement - ==> Parameters: 2012-06-11 13:33:20.662(Timestamp), 2012-06-11 13:33:20.662(Timestamp)
11 Jun 2012 13:33:15,662 JobAcquisitionThread DEBUG sql.Connection - xxx Connection Closed
11 Jun 2012 13:33:15,724 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:15,724 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067038(String)
11 Jun 2012 13:33:15,918 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:15,918 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067037(String)
11 Jun 2012 13:33:16,043 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:16,043 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067031(String)
11 Jun 2012 13:33:16,253 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:16,253 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067035(String)
11 Jun 2012 13:33:16,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:16,459 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067033(String)
11 Jun 2012 13:33:16,663 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:16,663 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067029(String)
11 Jun 2012 13:33:16,773 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:16,773 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067026(String)
11 Jun 2012 13:33:16,902 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:16,902 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067027(String)
11 Jun 2012 13:33:17,058 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:17,058 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067019(String)
11 Jun 2012 13:33:17,305 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:17,305 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067018(String)
11 Jun 2012 13:33:17,626 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:17,627 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067023(String)
11 Jun 2012 13:33:17,911 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:17,911 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067022(String)
11 Jun 2012 13:33:18,329 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:18,329 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067016(String)
11 Jun 2012 13:33:18,528 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:18,529 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067015(String)
11 Jun 2012 13:33:18,639 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:18,639 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067013(String)
11 Jun 2012 13:33:18,758 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:18,758 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067004(String)
11 Jun 2012 13:33:18,963 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:18,963 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067003(String)
11 Jun 2012 13:33:19,323 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:19,323 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067008(String)
11 Jun 2012 13:33:19,537 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_GE_BYTEARRAY where ID_ = ?
11 Jun 2012 13:33:19,537 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067007(String)
11 Jun 2012 13:33:19,851 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_VARIABLE where ID_ = ?
11 Jun 2012 13:33:19,851 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067011(String)
11 Jun 2012 13:33:20,050 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==>  Executing: delete from ACT_RU_EXECUTION where ID_ = ?
11 Jun 2012 13:33:20,050 http-apr-80-exec-8 DEBUG sql.PreparedStatement - ==> Parameters: 2067001(String)
11 Jun 2012 13:33:20,158 http-apr-80-exec-8 DEBUG sql.Connection - xxx Connection Closed[/size]

Outcomes