Version 1


    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">

       <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 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 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_`))