Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Hyland Connect
- Enterprise Platforms
- Alfresco
- Alfresco Archive
- TaskService complete performance issue
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
TaskService complete performance issue
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2012 09:18 AM
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]
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]
Labels:
- Labels:
-
Archive
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-11-2012 06:22 PM
This is a known issue in activiti 16. Please upgrade to activiti 20…
But seriously… Pleaee create a unit test that demonstrates this problem and provide more info. For all we know, you might do some not optimized queries on a database with 10 billion records.
And next time please use the use forum.
But seriously… Pleaee create a unit test that demonstrates this problem and provide more info. For all we know, you might do some not optimized queries on a database with 10 billion records.
And next time please use the use forum.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2012 02:09 AM
Thanks for answer. Next time I'll use User forum.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-12-2012 11:30 AM
🙂
But I am very curious to what you actually do. Lot's of queries etc… Could be a performance bottleneck somewhere
But I am very curious to what you actually do. Lot's of queries etc… Could be a performance bottleneck somewhere
Related Content
- Achieving Higher Metadata Indexing Speed with Elasticsearch in Alfresco Blog
- Deploying Elasticsearch for Alfresco on AWS Elasticsearch Vs AWS EC2 in Alfresco Blog
- Speed up Community Alfresco with Lucene repository properties - help needed in Alfresco Forum
- Alfresco Customer Newsletter - March 2022 in Alfresco Blog
- Understanding Alfresco Auto-Suggest Feature in Alfresco Blog
Getting started
Tags
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.
