[jboss-dev-forums] [jBPM Development] - Problem While deleting the Deployed Process Definitation

Friday, 1 October 2010

sreeni Karnati [http://community.jboss.org/people/sreeni.karnati] created the document:

"Problem While deleting the Deployed Process Definitation"

To view the document, visit: http://community.jboss.org/docs/DOC-15927

--------------------------------------------------------------
Hi i am new to JBPM..Could any one help me in resolving this issue. To set up the JBPM i
folloed the instruction from the User's guide. Then i configurd the jbpm4.4/install/
biuld.xml I chanaged database name from hsqldb to mysql.Also changed the mysql.propertie.

After setting up the environment i imported the examples..then i define a sample
processDefinitation as show in the document. Then i deployed the process definitation and
process instance. Finaly i got a problem while deleting the deployed porcess
definitation.

=== Environment ==============================
- jBPM Version : jbpm-4.4
- Database : MySql:5.5.0
- JDK : jdk1.6.0_21
- Container : jboss-4.2.3.GA
- Configuration : yes jbpm.cfg.xml  using imports from the jbpm.jar
- Libraries : yes i am  using the exact versions of the libs from inside the jbpm
   distribution of the version that you're using
=== Process ==================================
<?xml version="1.0" encoding="UTF-8"?>
<process name="sampleprocess" key="sp" xmlns="
http://jbpm.org/4.4/jpdl http://jbpm.org/4.4/jpdl">
   <start g="16,18,48,48">
    <transition to="a" />
  </start>
  <state name="a" g="96,16,75,52">
    <transition to="b" />
  </state>
  <state name="b" g="203,16,73,52">

  </state>
</process>
=== API ===================================
I am completely new to this environment. This is my first applictaion.
public class SampleProcessTest {
 protected static ProcessEngine processEngine;
 protected static  RepositoryService repositoryService;
 protected static  ExecutionService executionService;
 protected static  ManagementService managementService;
 protected static  TaskService taskService;
 protected static  HistoryService historyService;
 protected static IdentityService identityService;

 private static String deploymentId;

 public static void main(String[] args) {

  buildConfiguration();--> Working fine

  deployProcessDefinitation();--> Working fine

  tranceProcessInstance();--> Working fine

  deleteProcessDefinitation();--> Exception:could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#50007]

 }
 private static void deleteProcessDefinitation() {

  if(deploymentId!=null){

   repositoryService.deleteDeploymentCascade(deploymentId);
  }

  System.out.print("Process Definitation with id "+deploymentId+" has been
removed");
 }

 private static void tranceProcessInstance() {

  ProcessInstance
processInstance=executionService.startProcessInstanceByKey("sp");

  Set<String>  executions=processInstance.findActiveActivityNames();

  System.out.println("The No of active executions are :"+executions.size());

  Execution executionInA = processInstance.findActiveExecutionIn("a");

  System.out.println("Execution is "+executionInA);
     processInstance = executionService.signalExecutionById(executionInA.getId());

     Execution executionInB = processInstance.findActiveExecutionIn("b");

     System.out.println("Execution is "+executionInB);
 }
 private static void deployProcessDefinitation() {
  deploymentId=repositoryService.createDeployment()
      .addResourceFromClasspath("com/mhgadm/za/sample/sampleprocess.jpdl.xml")
      .deploy();

  System.out.println("The porecess id is deployed with id "+deploymentId);

 }
 private static void buildConfiguration() {

  processEngine=Configuration.getProcessEngine();

  repositoryService=processEngine.getRepositoryService();

  executionService=processEngine.getExecutionService();

  managementService=processEngine.getManagementService();

  taskService=processEngine.getTaskService();

  historyService=processEngine.getHistoryService();

  identityService=processEngine.getIdentityService();
 }
}
=== Stacktrace ==============================
11:18:21,532 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:18:21,532 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:18:21,532 FST | [LongType] returning '2' as column: LONGVAL6_1_0_
11:18:21,532 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:18:21,532 FST | [LongType] returning '30006' as column: DBID1_1_
11:18:21,532 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,532 FST | [LongType] binding '40001' to parameter: 1
11:18:21,532 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,532 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,532 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,532 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_,
resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as
DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as
BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as
DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_,
resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from
JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:18:21,532 FST | [LongType] binding '40001' to parameter: 1
11:18:21,532 FST | [LongType] returning '40002' as column: DBID1_5_0_
11:18:21,547 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:18:21,547 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_
11:18:21,547 FST | [LongType] returning '40002' as column: DBID1_1_
11:18:21,547 FST | [TextType] returning
'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:18:21,594 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_,
objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_
as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as
KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as
LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as
DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_,
objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_,
objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from
JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:18:21,594 FST | [LongType] binding '40001' to parameter: 1
11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning '3' as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_
11:18:21,625 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '1' as column: col_1_0_
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '30001' as column: col_1_0_
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '40001' as column: col_1_0_
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
11:18:21,641 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
11:18:21,641 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,641 FST | [LongType] returning '40001' as column: col_1_0_
11:18:21,657 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50004' to parameter: 6
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50005' to parameter: 6
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50006' to parameter: 6
11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:18:21,657 FST | [LongType] binding '50001' to parameter: 1
11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,657 FST | [StringType] binding 'pdid' to parameter: 3
11:18:21,657 FST | [StringType] binding 'sp-4' to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50004' to parameter: 6
11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:18:21,657 FST | [LongType] binding '50001' to parameter: 1
11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,657 FST | [StringType] binding 'pdkey' to parameter: 3
11:18:21,657 FST | [StringType] binding 'sp' to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,672 FST | [LongType] binding '50005' to parameter: 6
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,672 FST | [StringType] binding 'pdversion' to parameter: 3
11:18:21,672 FST | [StringType] binding null to parameter: 4
11:18:21,672 FST | [LongType] binding '4' to parameter: 5
11:18:21,672 FST | [LongType] binding '50006' to parameter: 6
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50005' to parameter: 2
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50004' to parameter: 2
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50006' to parameter: 2
11:18:21,672 FIN | [HibernateSessionResource] ----- committing hibernate tx 81758996
-------------------------------------------------------
The porecess id is deployed with id 50001
11:18:21,672 FIN | [HibernateSessionResource] ----- beginning hibernate tx 878190908
--------------------------------------------------------
11:18:21,672 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
11:18:21,672 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,672 FST | [LongType] returning '50001' as column: col_1_0_
11:18:21,672 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_
as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-4' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as
DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-4' limit ?
11:18:21,688 FST | [LongType] returning '50004' as column: DBID1_1_
11:18:21,688 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:18:21,688 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:18:21,688 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:18:21,688 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_
11:18:21,688 FST | [LongType] returning null as column: LONGVAL6_1_
11:18:21,688 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,688 FST | [LongType] binding '50001' to parameter: 1
11:18:21,688 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,688 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,688 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,688 FIN | [ProcessDefinitionImpl] creating new execution for process
'sampleprocess'
11:18:21,688 FIN | [DatabaseIdComposer] generated execution id sp.50007
11:18:21,703 FIN | [ExecuteActivity] executing activity(175735253)
11:18:21,703 FIN | [ExecuteActivity] executing activity(a)
11:18:21,703 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_,
PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_,
PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_,
NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_,
SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, 'pvm', ?)
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,703 FST | [StringType] binding null to parameter: 2
11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,703 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,703 FST | [StringType] binding null to parameter: 5
11:18:21,703 FST | [StringType] binding null to parameter: 6
11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,703 FST | [StringType] binding 'created' to parameter: 8
11:18:21,703 FST | [StringType] binding null to parameter: 9
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,703 FST | [LongType] binding null to parameter: 11
11:18:21,703 FST | [LongType] binding null to parameter: 12
11:18:21,703 FST | [LongType] binding '50007' to parameter: 13
11:18:21,703 FST | [LongType] binding null to parameter: 14
11:18:21,703 FST | [LongType] binding null to parameter: 15
11:18:21,703 FST | [LongType] binding '50007' to parameter: 16
11:18:21,703 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_,
KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_,
END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?)
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 2
11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,703 FST | [StringType] binding null to parameter: 4
11:18:21,703 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 5
11:18:21,703 FST | [TimestampType] binding null to parameter: 6
11:18:21,703 FST | [LongType] binding null to parameter: 7
11:18:21,703 FST | [StringType] binding 'active' to parameter: 8
11:18:21,703 FST | [StringType] binding null to parameter: 9
11:18:21,703 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,703 FST | [LongType] binding '50007' to parameter: 11
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_,
ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,719 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_,
EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,719 FST | [LongType] binding '50007' to parameter: 2
11:18:21,719 FST | [StringType] binding 'state' to parameter: 3
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 4
11:18:21,719 FST | [StringType] binding 'a' to parameter: 5
11:18:21,719 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,719 FST | [TimestampType] binding null to parameter: 7
11:18:21,719 FST | [LongType] binding '0' to parameter: 8
11:18:21,719 FST | [StringType] binding null to parameter: 9
11:18:21,719 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,719 FST | [LongType] binding '50008' to parameter: 11
11:18:21,719 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?,
PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?,
HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
11:18:21,719 FST | [IntegerType] binding '1' to parameter: 1
11:18:21,719 FST | [StringType] binding 'a' to parameter: 2
11:18:21,719 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,719 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,719 FST | [StringType] binding null to parameter: 5
11:18:21,719 FST | [StringType] binding null to parameter: 6
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,719 FST | [StringType] binding 'active-root' to parameter: 8
11:18:21,719 FST | [StringType] binding null to parameter: 9
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,719 FST | [LongType] binding '50008' to parameter: 11
11:18:21,719 FST | [LongType] binding null to parameter: 12
11:18:21,719 FST | [LongType] binding '50007' to parameter: 13
11:18:21,719 FST | [LongType] binding null to parameter: 14
11:18:21,719 FST | [LongType] binding null to parameter: 15
11:18:21,719 FST | [LongType] binding '50007' to parameter: 16
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 17
11:18:21,719 FIN | [HibernateSessionResource] ----- committing hibernate tx 1253587936
-------------------------------------------------------
The No of active executions are :1
Execution is execution[sp.50007]
11:18:21,719 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1658340521
--------------------------------------------------------
11:18:21,719 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? limit ?
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,719 FST | [LongType] returning '50007' as column: DBID1_3_
11:18:21,719 FST | [IntegerType] returning '1' as column: DBVERSION3_3_
11:18:21,719 FST | [StringType] returning 'a' as column: ACTIVITY4_3_
11:18:21,719 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_
11:18:21,719 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:18:21,719 FST | [StringType] returning null as column: NAME7_3_
11:18:21,719 FST | [StringType] returning null as column: KEY8_3_
11:18:21,719 FST | [StringType] returning 'sp.50007' as column: ID9_3_
11:18:21,719 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:18:21,719 FST | [StringType] returning null as column: SUSPHIS11_3_
11:18:21,719 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:18:21,719 FST | [LongType] returning '50008' as column: HISACTINST13_3_
11:18:21,719 FST | [LongType] returning null as column: PARENT14_3_
11:18:21,719 FST | [LongType] returning '50007' as column: INSTANCE15_3_
11:18:21,719 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:18:21,719 FST | [LongType] returning null as column: SUBPROC17_3_
11:18:21,719 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as
DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_,
executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:18:21,735 FST | [LongType] binding '50007' to parameter: 1
11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_
as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-4' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as
DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-4' limit ?
11:18:21,735 FST | [LongType] returning '50004' as column: DBID1_1_
11:18:21,735 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:18:21,735 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:18:21,735 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:18:21,735 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_
11:18:21,735 FST | [LongType] returning null as column: LONGVAL6_1_
11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,735 FST | [LongType] binding '50001' to parameter: 1
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,735 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,735 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,735 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,735 FIN | [Signal] signalling activity(a), signalName=null
11:18:21,735 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_
as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as
TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as
ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_,
historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_,
historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_,
historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where
historyact0_.DBID_=?
Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as
DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
11:18:21,735 FST | [LongType] binding '50008' to parameter: 1
11:18:21,735 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,735 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:18:21,735 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,735 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,735 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,735 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
START8_8_0_
11:18:21,750 FST | [TimestampType] returning null as column: END9_8_0_
11:18:21,750 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:18:21,750 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,750 FIN | [ExecuteActivity] executing activity(b)
11:18:21,750 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_
as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as
PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_,
historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_,
historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_,
historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where
historypro0_.DBID_=?
11:18:21,750 FST | [LongType] binding '50007' to parameter: 1
Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as
DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_,
historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as
END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_,
historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from
JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
11:18:21,750 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:18:21,750 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_
11:18:21,750 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_
11:18:21,750 FST | [StringType] returning null as column: KEY5_7_0_
11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
START6_7_0_
11:18:21,750 FST | [TimestampType] returning null as column: END7_7_0_
11:18:21,750 FST | [LongType] returning null as column: DURATION8_7_0_
11:18:21,750 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:18:21,750 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:18:21,750 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_,
EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,750 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,750 FST | [LongType] binding '50007' to parameter: 2
11:18:21,750 FST | [StringType] binding 'state' to parameter: 3
11:18:21,750 FST | [StringType] binding 'sp.50007' to parameter: 4
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_,
ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,750 FST | [StringType] binding 'b' to parameter: 5
11:18:21,750 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,750 FST | [TimestampType] binding null to parameter: 7
11:18:21,750 FST | [LongType] binding '0' to parameter: 8
11:18:21,750 FST | [StringType] binding null to parameter: 9
11:18:21,750 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,766 FST | [LongType] binding '50009' to parameter: 11
11:18:21,766 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?,
PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?,
HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
11:18:21,766 FST | [IntegerType] binding '2' to parameter: 1
11:18:21,766 FST | [StringType] binding 'b' to parameter: 2
11:18:21,766 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,766 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,766 FST | [StringType] binding null to parameter: 5
11:18:21,766 FST | [StringType] binding null to parameter: 6
11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,766 FST | [StringType] binding 'active-root' to parameter: 8
11:18:21,766 FST | [StringType] binding null to parameter: 9
11:18:21,766 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,766 FST | [LongType] binding '50009' to parameter: 11
11:18:21,766 FST | [LongType] binding null to parameter: 12
11:18:21,766 FST | [LongType] binding '50007' to parameter: 13
11:18:21,766 FST | [LongType] binding null to parameter: 14
11:18:21,766 FST | [LongType] binding null to parameter: 15
11:18:21,766 FST | [LongType] binding '50007' to parameter: 16
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 17
11:18:21,766 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?,
EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=?
where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?,
ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=?
and DBVERSION_=?
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 1
11:18:21,766 FST | [LongType] binding '50007' to parameter: 2
11:18:21,766 FST | [StringType] binding 'state' to parameter: 3
11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 4
11:18:21,766 FST | [StringType] binding 'a' to parameter: 5
11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 7
11:18:21,766 FST | [LongType] binding '735' to parameter: 8
11:18:21,766 FST | [StringType] binding null to parameter: 9
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,766 FST | [LongType] binding '50008' to parameter: 11
11:18:21,766 FST | [IntegerType] binding '0' to parameter: 12
11:18:21,766 FIN | [HibernateSessionResource] ----- committing hibernate tx 1046388151
-------------------------------------------------------
Execution is execution[sp.50007]
11:18:21,766 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1741604980
--------------------------------------------------------
11:18:21,781 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001
11:18:21,781 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,781 FST | [LongType] returning '50001' as column: col_1_0_
11:18:21,797 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION
executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where
executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
11:18:21,797 FST | [StringType] binding 'sp-4' to parameter: 1
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: col_0_0_
11:18:21,797 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as
DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as
KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as
DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_,
this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_,
this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_,
this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_,
this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as
NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
11:18:21,797 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,797 FST | [LongType] returning '50007' as column: DBID1_7_0_
11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_
11:18:21,797 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_
11:18:21,797 FST | [StringType] returning null as column: KEY5_7_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
START6_7_0_
11:18:21,797 FST | [TimestampType] returning null as column: END7_7_0_
11:18:21,797 FST | [LongType] returning null as column: DURATION8_7_0_
11:18:21,797 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:18:21,797 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:18:21,797 FIN | [DbSessionImpl] deleting history process instance sp.50007
11:18:21,797 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as
DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_,
historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_,
historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_,
historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
11:18:21,797 FST | [LongType] binding '50007' to parameter: 1
11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_8_0_
11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,797 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
START8_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
END9_8_0_
11:18:21,797 FST | [LongType] returning '735' as column: DURATION10_8_0_
11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_
11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_1_
11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_8_0_
11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,797 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column:
START8_8_0_
11:18:21,797 FST | [TimestampType] returning null as column: END9_8_0_
11:18:21,797 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_
11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_1_
11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:18:21,797 FST | [LongType] binding '50008' to parameter: 1
11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:18:21,797 FST | [LongType] binding '50009' to parameter: 1
11:18:21,813 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as
DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_,
historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as
EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as
VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_
from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_,
historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_,
historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as
EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as
VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_
from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,813 FST | [LongType] returning '50007' as column: DBID1_3_
11:18:21,813 FST | [IntegerType] returning '2' as column: DBVERSION3_3_
11:18:21,813 FST | [StringType] returning 'b' as column: ACTIVITY4_3_
11:18:21,813 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_
11:18:21,813 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:18:21,813 FST | [StringType] returning null as column: NAME7_3_
11:18:21,813 FST | [StringType] returning null as column: KEY8_3_
11:18:21,813 FST | [StringType] returning 'sp.50007' as column: ID9_3_
11:18:21,813 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:18:21,813 FST | [StringType] returning null as column: SUSPHIS11_3_
11:18:21,813 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:18:21,813 FST | [LongType] returning '50009' as column: HISACTINST13_3_
11:18:21,813 FST | [LongType] returning null as column: PARENT14_3_
11:18:21,813 FST | [LongType] returning '50007' as column: INSTANCE15_3_
11:18:21,813 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:18:21,813 FST | [LongType] returning null as column: SUBPROC17_3_
11:18:21,813 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as
DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_,
executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as
DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_
as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as
ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_,
this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as
PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as
EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as
HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as
EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as
SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_,
pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_
as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as
KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_,
pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as
SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join
JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_,
this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_,
this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_
as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_,
this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_
as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as
ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as
SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as
PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as
TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_,
pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as
HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_,
pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as
PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_,
pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_
as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on
this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as
DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_,
this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_,
this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_
as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as
EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_
as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_
as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as
NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_,
pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_
as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_,
pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB
this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where
pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_,
this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as
ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_,
this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_,
this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_
as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_
as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_
as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as
PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as
KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_,
pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as
SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join
JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,828 FIN | [DbSessionImpl] Deleting process instance sp.50007
11:18:21,828 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_
as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_,
variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_,
variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_,
variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_,
variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_,
variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_,
variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_,
variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from
JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_,
variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as
DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_,
variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_,
variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as
DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as
CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as
STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_
from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as
DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_,
systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_,
systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_,
systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_,
systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_,
systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_,
systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_,
systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from
JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_,
systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as
DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as
CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as
EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_,
systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_,
systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_,
systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_,
systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where
systemvari0_.EXESYS_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_
as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_,
swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_,
swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from
JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_,
swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as
DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as
ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE
swimlanes0_ where swimlanes0_.EXECUTION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50008' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '1' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50009' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '2' to parameter: 2
11:18:21,844 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000
11:18:21,844 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign
key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN
KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
### EXCEPTION ###########################################
11:18:21,844 SEV | [AbstractFlushingEventListener] Could not synchronize database state
with session
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#50007]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
 at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
 at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
 at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
 at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
 at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
 at
org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
 at
com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
 at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
 ... 21 more
### EXCEPTION ###########################################
### EXCEPTION ###########################################
11:18:21,844 INF | [DefaultCommandService] exception while executing command 
mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c
org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#50007]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
 at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
 at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
 at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
 at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
 at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
 at
org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
 at
com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
 at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
 ... 21 more
### EXCEPTION ###########################################
11:18:21,844 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 1561837803
-----------------------------------------------------
Exception in thread "main" org.hibernate.exception.ConstraintViolationException:
could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
 at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
 at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
 at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
 at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
 at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
 at
org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
 at
com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
 at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
 ... 21 more
=== Debug logs ==============================
11:20:17,794 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_,
objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_
as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as
KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as
LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as
DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_,
objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_,
objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from
JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,794 FST | [LongType] binding '30001' to parameter: 1
11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,794 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,794 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,794 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_
11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,794 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,794 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,794 FST | [StringType] returning 'sp-2' as column: STRINGVAL5_1_0_
11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_
11:20:17,794 FST | [LongType] returning '30005' as column: DBID1_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,809 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,809 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,809 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,809 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,809 FST | [LongType] returning '30005' as column: DBID1_1_
11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,809 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,809 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,809 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,809 FST | [LongType] returning '2' as column: LONGVAL6_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_
11:20:17,809 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:17,809 FST | [LongType] binding '40001' to parameter: 1
11:20:17,809 FST | [TextType] returning null as column: NAME2_0_0_
11:20:17,809 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:17,809 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:17,809 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_,
resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as
DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as
BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as
DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_,
resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from
JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:20:17,809 FST | [LongType] binding '40001' to parameter: 1
11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_5_0_
11:20:17,809 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:20:17,809 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_
11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_1_
11:20:17,809 FST | [TextType] returning
'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:20:17,887 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_,
objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_
as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as
KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as
LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as
DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_,
objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_,
objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from
JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,887 FST | [LongType] binding '40001' to parameter: 1
11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning '3' as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_
11:20:17,903 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:17,903 FST | [LongType] binding '50001' to parameter: 1
11:20:17,903 FST | [TextType] returning null as column: NAME2_0_0_
11:20:17,903 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:17,903 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:17,903 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_,
resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as
DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as
BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as
DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_,
resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from
JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:20:17,903 FST | [LongType] binding '50001' to parameter: 1
11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_5_0_
11:20:17,903 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:20:17,903 FST | [LongType] returning '50001' as column: DEPLOYMENT4_1_
11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_1_
11:20:17,903 FST | [TextType] returning
'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:20:17,981 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_,
objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_
as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as
KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as
LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as
DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_,
objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_,
objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from
JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,981 FST | [LongType] binding '50001' to parameter: 1
11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column:
OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning '4' as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_
11:20:17,996 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '1' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '30001' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '40001' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '50001' as column: col_1_0_
11:20:18,028 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
11:20:18,028 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,028 FST | [LongType] returning '50001' as column: col_1_0_
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'
11:20:18,029 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'
11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,029 FST | [LongType] binding null to parameter: 1
11:20:18,029 FST | [StringType] binding null to parameter: 2
11:20:18,029 FST | [StringType] binding null to parameter: 3
11:20:18,029 FST | [StringType] binding null to parameter: 4
11:20:18,029 FST | [LongType] binding null to parameter: 5
11:20:18,029 FST | [LongType] binding '60004' to parameter: 6
11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [LongType] binding null to parameter: 1
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [StringType] binding null to parameter: 2
11:20:18,030 FST | [StringType] binding null to parameter: 3
11:20:18,030 FST | [StringType] binding null to parameter: 4
11:20:18,030 FST | [LongType] binding null to parameter: 5
11:20:18,030 FST | [LongType] binding '60005' to parameter: 6
11:20:18,030 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_,
STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_,
LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [LongType] binding null to parameter: 1
11:20:18,045 FST | [StringType] binding null to parameter: 2
11:20:18,045 FST | [StringType] binding null to parameter: 3
11:20:18,045 FST | [StringType] binding null to parameter: 4
11:20:18,045 FST | [LongType] binding null to parameter: 5
11:20:18,045 FST | [LongType] binding '60006' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdid' to parameter: 3
11:20:18,061 FST | [StringType] binding 'sp-5' to parameter: 4
11:20:18,061 FST | [LongType] binding null to parameter: 5
11:20:18,061 FST | [LongType] binding '60004' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdkey' to parameter: 3
11:20:18,061 FST | [StringType] binding 'sp' to parameter: 4
11:20:18,061 FST | [LongType] binding null to parameter: 5
11:20:18,061 FST | [LongType] binding '60005' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?,
STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?,
LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdversion' to parameter: 3
11:20:18,061 FST | [StringType] binding null to parameter: 4
11:20:18,061 FST | [LongType] binding '5' to parameter: 5
11:20:18,061 FST | [LongType] binding '60006' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60005' to parameter: 2
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60006' to parameter: 2
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60004' to parameter: 2
11:20:18,061 FIN | [HibernateSessionResource] ----- committing hibernate tx 785383518
-------------------------------------------------------
The porecess id is deployed with id 60001
11:20:18,061 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1221338506
--------------------------------------------------------
11:20:18,061 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order
by deployment3_.LONGVAL_ desc limit ?
11:20:18,061 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,061 FST | [LongType] returning '60001' as column: col_1_0_
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as
DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_
as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,076 FST | [LongType] returning '60004' as column: DBID1_1_
11:20:18,076 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_
11:20:18,076 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:20:18,076 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:20:18,076 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_
11:20:18,076 FST | [LongType] returning null as column: LONGVAL6_1_
11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,076 FST | [LongType] binding '60001' to parameter: 1
11:20:18,076 FST | [TextType] returning null as column: NAME2_0_0_
11:20:18,076 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:18,076 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:18,076 FIN | [ProcessDefinitionImpl] creating new execution for process
'sampleprocess'
11:20:18,076 FIN | [DatabaseIdComposer] generated execution id sp.60007
11:20:18,092 FIN | [ExecuteActivity] executing activity(1421269392)
11:20:18,092 FIN | [ExecuteActivity] executing activity(a)
11:20:18,092 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_,
PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_,
PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_,
NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_,
SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, 'pvm', ?)
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,092 FST | [StringType] binding null to parameter: 2
11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,092 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,092 FST | [StringType] binding null to parameter: 5
11:20:18,092 FST | [StringType] binding null to parameter: 6
11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,092 FST | [StringType] binding 'created' to parameter: 8
11:20:18,092 FST | [StringType] binding null to parameter: 9
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,092 FST | [LongType] binding null to parameter: 11
11:20:18,092 FST | [LongType] binding null to parameter: 12
11:20:18,092 FST | [LongType] binding '60007' to parameter: 13
11:20:18,092 FST | [LongType] binding null to parameter: 14
11:20:18,092 FST | [LongType] binding null to parameter: 15
11:20:18,092 FST | [LongType] binding '60007' to parameter: 16
11:20:18,092 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_,
KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_,
END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?)
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 2
11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,092 FST | [StringType] binding null to parameter: 4
11:20:18,092 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 5
11:20:18,108 FST | [TimestampType] binding null to parameter: 6
11:20:18,108 FST | [LongType] binding null to parameter: 7
11:20:18,108 FST | [StringType] binding 'active' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,108 FST | [LongType] binding '60007' to parameter: 11
11:20:18,108 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_,
EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_,
ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,108 FST | [LongType] binding '60007' to parameter: 2
11:20:18,108 FST | [StringType] binding 'state' to parameter: 3
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,108 FST | [StringType] binding 'a' to parameter: 5
11:20:18,108 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,108 FST | [TimestampType] binding null to parameter: 7
11:20:18,108 FST | [LongType] binding '0' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,108 FST | [LongType] binding '60008' to parameter: 11
11:20:18,108 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?,
PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?,
HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 1
11:20:18,108 FST | [StringType] binding 'a' to parameter: 2
11:20:18,108 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,108 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,108 FST | [StringType] binding null to parameter: 5
11:20:18,108 FST | [StringType] binding null to parameter: 6
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,108 FST | [StringType] binding 'active-root' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,108 FST | [LongType] binding '60008' to parameter: 11
11:20:18,108 FST | [LongType] binding null to parameter: 12
11:20:18,108 FST | [LongType] binding '60007' to parameter: 13
11:20:18,108 FST | [LongType] binding null to parameter: 14
11:20:18,108 FST | [LongType] binding null to parameter: 15
11:20:18,108 FST | [LongType] binding '60007' to parameter: 16
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 17
11:20:18,108 FIN | [HibernateSessionResource] ----- committing hibernate tx 2113092528
-------------------------------------------------------
The No of active executions are :1
Execution is execution[sp.60007]
11:20:18,108 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1584118582
--------------------------------------------------------
11:20:18,108 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? limit ?
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,123 FST | [LongType] returning '60007' as column: DBID1_3_
11:20:18,123 FST | [IntegerType] returning '1' as column: DBVERSION3_3_
11:20:18,123 FST | [StringType] returning 'a' as column: ACTIVITY4_3_
11:20:18,123 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_
11:20:18,123 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:20:18,123 FST | [StringType] returning null as column: NAME7_3_
11:20:18,123 FST | [StringType] returning null as column: KEY8_3_
11:20:18,123 FST | [StringType] returning 'sp.60007' as column: ID9_3_
11:20:18,123 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:20:18,123 FST | [StringType] returning null as column: SUSPHIS11_3_
11:20:18,123 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:20:18,123 FST | [LongType] returning '60008' as column: HISACTINST13_3_
11:20:18,123 FST | [LongType] returning null as column: PARENT14_3_
11:20:18,123 FST | [LongType] returning '60007' as column: INSTANCE15_3_
11:20:18,123 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:20:18,123 FST | [LongType] returning null as column: SUBPROC17_3_
11:20:18,123 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as
DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_,
executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:20:18,123 FST | [LongType] binding '60007' to parameter: 1
11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_
as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,123 FST | [LongType] returning '60004' as column: DBID1_1_
11:20:18,123 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_
11:20:18,123 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as
DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_,
deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from
JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and
deployment0_.STRINGVAL_='sp-5' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_,
deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from
JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,123 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:20:18,123 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_
11:20:18,123 FST | [LongType] returning null as column: LONGVAL6_1_
11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as
NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_
from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,123 FST | [LongType] binding '60001' to parameter: 1
11:20:18,123 FST | [TextType] returning null as column: NAME2_0_0_
11:20:18,123 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:18,123 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:18,123 FIN | [Signal] signalling activity(a), signalName=null
Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as
DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
11:20:18,139 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_
as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as
TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as
ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_,
historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_,
historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_,
historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where
historyact0_.DBID_=?
11:20:18,139 FST | [LongType] binding '60008' to parameter: 1
11:20:18,139 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:20:18,139 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,139 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,139 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,139 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
START8_8_0_
11:20:18,139 FST | [TimestampType] returning null as column: END9_8_0_
11:20:18,139 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:20:18,139 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,139 FIN | [ExecuteActivity] executing activity(b)
11:20:18,139 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_
as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as
PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_,
historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_,
historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_,
historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where
historypro0_.DBID_=?
Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as
DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_,
historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as
END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_,
historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from
JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
11:20:18,139 FST | [LongType] binding '60007' to parameter: 1
11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:20:18,139 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_
11:20:18,139 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_
11:20:18,139 FST | [StringType] returning null as column: KEY5_7_0_
11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
START6_7_0_
11:20:18,139 FST | [TimestampType] returning null as column: END7_7_0_
11:20:18,139 FST | [LongType] returning null as column: DURATION8_7_0_
11:20:18,139 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:20:18,139 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:20:18,154 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_,
EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_)
values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_,
ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,154 FST | [LongType] binding '60007' to parameter: 2
11:20:18,154 FST | [StringType] binding 'state' to parameter: 3
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,154 FST | [StringType] binding 'b' to parameter: 5
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,154 FST | [TimestampType] binding null to parameter: 7
11:20:18,154 FST | [LongType] binding '0' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,154 FST | [LongType] binding '60009' to parameter: 11
11:20:18,154 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?,
PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?,
HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?,
HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and
DBVERSION_=?
11:20:18,154 FST | [IntegerType] binding '2' to parameter: 1
11:20:18,154 FST | [StringType] binding 'b' to parameter: 2
11:20:18,154 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,154 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,154 FST | [StringType] binding null to parameter: 5
11:20:18,154 FST | [StringType] binding null to parameter: 6
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,154 FST | [StringType] binding 'active-root' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,154 FST | [LongType] binding '60009' to parameter: 11
11:20:18,154 FST | [LongType] binding null to parameter: 12
11:20:18,154 FST | [LongType] binding '60007' to parameter: 13
11:20:18,154 FST | [LongType] binding null to parameter: 14
11:20:18,154 FST | [LongType] binding null to parameter: 15
11:20:18,154 FST | [LongType] binding '60007' to parameter: 16
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 17
11:20:18,154 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?,
EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=?
where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?,
ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=?
and DBVERSION_=?
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 1
11:20:18,154 FST | [LongType] binding '60007' to parameter: 2
11:20:18,154 FST | [StringType] binding 'state' to parameter: 3
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,154 FST | [StringType] binding 'a' to parameter: 5
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 7
11:20:18,154 FST | [LongType] binding '139' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,154 FST | [LongType] binding '60008' to parameter: 11
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 12
11:20:18,154 FIN | [HibernateSessionResource] ----- committing hibernate tx 1448415374
-------------------------------------------------------
Execution is execution[sp.60007]
11:20:18,170 FIN | [HibernateSessionResource] ----- beginning hibernate tx 252689000
--------------------------------------------------------
11:20:18,186 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_,
deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP
deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where
deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and
deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_
from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP
deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and
deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and
deployment2_.OBJNAME_=deployment1_.OBJNAME_ and
deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and
deployment3_.OBJNAME_=deployment1_.OBJNAME_ and
deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001
11:20:18,186 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,186 FST | [LongType] returning '60001' as column: col_1_0_
11:20:18,186 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION
executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where
executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
11:20:18,186 FST | [StringType] binding 'sp-5' to parameter: 1
11:20:18,186 FST | [StringType] returning 'sp.60007' as column: col_0_0_
11:20:18,186 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as
DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as
KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as
DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_,
this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_,
this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_,
this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_,
this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as
NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
11:20:18,186 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,186 FST | [LongType] returning '60007' as column: DBID1_7_0_
11:20:18,186 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:20:18,186 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_
11:20:18,186 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_
11:20:18,186 FST | [StringType] returning null as column: KEY5_7_0_
11:20:18,186 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
START6_7_0_
11:20:18,186 FST | [TimestampType] returning null as column: END7_7_0_
11:20:18,186 FST | [LongType] returning null as column: DURATION8_7_0_
11:20:18,186 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:20:18,186 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:20:18,186 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:20:18,186 FIN | [DbSessionImpl] deleting history process instance sp.60007
11:20:18,201 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as
DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_,
historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_,
historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_,
historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_,
historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_,
historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_
as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_
as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_
from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_8_0_
11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,201 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
START8_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
END9_8_0_
11:20:18,201 FST | [LongType] returning '139' as column: DURATION10_8_0_
11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_
11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_1_
11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_8_0_
11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,201 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,201 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column:
START8_8_0_
11:20:18,201 FST | [TimestampType] returning null as column: END9_8_0_
11:20:18,201 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_
11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_1_
11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:20:18,201 FST | [LongType] binding '60008' to parameter: 1
11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:20:18,201 FST | [LongType] binding '60009' to parameter: 1
11:20:18,201 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as
DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_,
historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as
EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as
VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_
from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_,
historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_,
historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as
EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as
VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_
from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as
DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_,
details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_,
details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as
HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_,
details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_,
details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_,
details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_,
details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_
as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_,
details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from
JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as
DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as
PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_,
executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as
STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as
PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as
PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as
SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION
executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
11:20:18,201 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FST | [LongType] returning '60007' as column: DBID1_3_
11:20:18,217 FST | [IntegerType] returning '2' as column: DBVERSION3_3_
11:20:18,217 FST | [StringType] returning 'b' as column: ACTIVITY4_3_
11:20:18,217 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_
11:20:18,217 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:20:18,217 FST | [StringType] returning null as column: NAME7_3_
11:20:18,217 FST | [StringType] returning null as column: KEY8_3_
11:20:18,217 FST | [StringType] returning 'sp.60007' as column: ID9_3_
11:20:18,217 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:20:18,217 FST | [StringType] returning null as column: SUSPHIS11_3_
11:20:18,217 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:20:18,217 FST | [LongType] returning '60009' as column: HISACTINST13_3_
11:20:18,217 FST | [LongType] returning null as column: PARENT14_3_
11:20:18,217 FST | [LongType] returning '60007' as column: INSTANCE15_3_
11:20:18,217 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:20:18,217 FST | [LongType] returning null as column: SUBPROC17_3_
11:20:18,217 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as
DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_,
executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_,
executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_,
executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as
ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as
HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as
INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as
SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as
DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_
as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as
ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_,
this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as
PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as
EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as
HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as
EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as
SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_,
pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_
as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as
KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_,
pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as
SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join
JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_,
this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_,
this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_
as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_,
this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_
as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as
ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as
SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as
PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as
TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_,
pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as
HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_,
pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as
PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_,
pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_
as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on
this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as
DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_,
this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_,
this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_
as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as
EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_
as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_
as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_,
pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as
NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_,
pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_
as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_,
pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB
this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where
pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_,
this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as
ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_,
this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_,
this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_
as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_
as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_
as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as
PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as
KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as
SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_,
pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as
SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join
JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FIN | [DbSessionImpl] Deleting process instance sp.60007
11:20:18,217 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_
as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_,
variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_,
variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_,
variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_,
variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_,
variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_,
variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_,
variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from
JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_,
variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as
DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_,
variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_,
variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as
DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as
CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as
STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_
from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as
DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_,
systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_,
systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_,
systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_,
systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_,
systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_,
systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_,
systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from
JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_,
systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as
DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as
CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as
EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_,
systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_,
systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_,
systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_,
systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where
systemvari0_.EXESYS_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_
as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_,
swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_,
swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from
JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_,
swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as
DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as
ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE
swimlanes0_ where swimlanes0_.EXECUTION_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60008' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '1' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60009' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '2' to parameter: 2
11:20:18,232 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000
11:20:18,232 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign
key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN
KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
### EXCEPTION ###########################################
11:20:18,232 SEV | [AbstractFlushingEventListener] Could not synchronize database state
with session
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#60007]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
 at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
 at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
 at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
 at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
 at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
 at
org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
 at
com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
 at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
 ... 21 more
### EXCEPTION ###########################################
### EXCEPTION ###########################################
11:20:18,232 INF | [DefaultCommandService] exception while executing command 
mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5
org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5
org.hibernate.exception.ConstraintViolationException: could not delete:
[org.jbpm.pvm.internal.model.ExecutionImpl#60007]
 at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
 at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
 at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
 at
org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
 at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
 at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
 at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
 at
org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
 at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
 at
org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
 at
org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
 at
org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
 at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
 at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
 at
org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
 at
com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
 at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Cannot delete or update a parent row: a foreign key constraint fails
(`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
 at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
 at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
 at java.lang.reflect.Constructor.newInstance(Unknown Source)
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
 at com.mysql.jdbc.Util.getInstance(Util.java:381)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
 at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
 at
org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
 ... 21 more
### EXCEPTION ###########################################
11:20:18,248 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 2088478793
-----------------------------------------------------

=== Problem description =========================
ProcessDefinitation deployment and Process instance are working fine. The problem is in
deleting the deployed ProcessDefinitation.
repositoryService.deleteDeploymentCascade(deploymentId) Exception  :) 
[JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint
fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`)
REFERENCES `jbpm4_execution` (`DBID_`))
--------------------------------------------------------------

Comment by going to Community
[http://community.jboss.org/docs/DOC-15927]

Create a new document in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=102&am...]

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

[jboss-dev-forums] [jBPM Development] - Problem While deleting the Deployed Process Definitation