[JBoss Web Development] - Re: Problems with SSL redirection on JBoss 5.1.0GA
by Vinod Pandey
Vinod Pandey [http://community.jboss.org/people/vinod.pandey] created the discussion
"Re: Problems with SSL redirection on JBoss 5.1.0GA"
To view the discussion, visit: http://community.jboss.org/message/564697#564697
--------------------------------------------------------------
Hi....
I have same problem not exctly but looks similar. First thing is that when I use constraints in web.xml, web service does not deploy successfully on JBoss Application server 5.1.0 (without any constraints web service works fine). Can you please suggest any solution for this problem and please also explains that what changes are required in bindings--jboss-beans.xml. I'll appritiate you help....
Thanks
Vinod Pandey
NHST, India
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/564697#564697]
Start a new discussion in JBoss Web Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years, 6 months
- 1
- 0
[jBPM Development] - jbpm version 4.5 or 5
by Fernando Melossi
Fernando Melossi [http://community.jboss.org/people/melossi] created the discussion
"jbpm version 4.5 or 5"
To view the discussion, visit: http://community.jboss.org/message/564599#564599
--------------------------------------------------------------
hi all, I find a limitation in version 4.4, jbpm HistoryTask, I need to get the ID and NAME of the tasks.
When a new version will be available for jbpm to solve these problems?
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/564599#564599]
Start a new discussion in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years, 6 months
- 2
- 1
[JBoss AS7 Development] - Re: ServerManager-Server(-ProcessManager) communication
by Kabir Khan
Kabir Khan [http://community.jboss.org/people/kabir.khan%40jboss.com] created the discussion
"Re: ServerManager-Server(-ProcessManager) communication"
To view the discussion, visit: http://community.jboss.org/message/560646#560646
--------------------------------------------------------------
The respawn policy should be configurable: https://jira.jboss.org/browse/JBAS-8390 https://jira.jboss.org/browse/JBAS-8390
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/560646#560646]
Start a new discussion in JBoss AS7 Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years, 6 months
- 3
- 10
[jBPM Development] - Problem While deleting the Deployed Process Definitation
by sreeni Karnati
sreeni Karnati [http://community.jboss.org/people/sreeni.karnati] created the document:
"Problem While deleting the Deployed Process Definitation"
To view the document, visit: http://community.jboss.org/docs/DOC-15927
--------------------------------------------------------------
Hi i am new to JBPM..Could any one help me in resolving this issue. To set up the JBPM i folloed the instruction from the User's guide. Then i configurd the jbpm4.4/install/ biuld.xml I chanaged database name from hsqldb to mysql.Also changed the mysql.propertie.
After setting up the environment i imported the examples..then i define a sample processDefinitation as show in the document. Then i deployed the process definitation and process instance. Finaly i got a problem while deleting the deployed porcess definitation.
=== Environment ==============================
- jBPM Version : jbpm-4.4
- Database : MySql:5.5.0
- JDK : jdk1.6.0_21
- Container : jboss-4.2.3.GA
- Configuration : yes jbpm.cfg.xml using imports from the jbpm.jar
- Libraries : yes i am using the exact versions of the libs from inside the jbpm
distribution of the version that you're using
=== Process ==================================
<?xml version="1.0" encoding="UTF-8"?>
<process name="sampleprocess" key="sp" xmlns=" http://jbpm.org/4.4/jpdl http://jbpm.org/4.4/jpdl">
<start g="16,18,48,48">
<transition to="a" />
</start>
<state name="a" g="96,16,75,52">
<transition to="b" />
</state>
<state name="b" g="203,16,73,52">
</state>
</process>
=== API ===================================
I am completely new to this environment. This is my first applictaion.
public class SampleProcessTest {
protected static ProcessEngine processEngine;
protected static RepositoryService repositoryService;
protected static ExecutionService executionService;
protected static ManagementService managementService;
protected static TaskService taskService;
protected static HistoryService historyService;
protected static IdentityService identityService;
private static String deploymentId;
public static void main(String[] args) {
buildConfiguration();--> Working fine
deployProcessDefinitation();--> Working fine
tranceProcessInstance();--> Working fine
deleteProcessDefinitation();--> Exception:could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]
}
private static void deleteProcessDefinitation() {
if(deploymentId!=null){
repositoryService.deleteDeploymentCascade(deploymentId);
}
System.out.print("Process Definitation with id "+deploymentId+" has been removed");
}
private static void tranceProcessInstance() {
ProcessInstance processInstance=executionService.startProcessInstanceByKey("sp");
Set<String> executions=processInstance.findActiveActivityNames();
System.out.println("The No of active executions are :"+executions.size());
Execution executionInA = processInstance.findActiveExecutionIn("a");
System.out.println("Execution is "+executionInA);
processInstance = executionService.signalExecutionById(executionInA.getId());
Execution executionInB = processInstance.findActiveExecutionIn("b");
System.out.println("Execution is "+executionInB);
}
private static void deployProcessDefinitation() {
deploymentId=repositoryService.createDeployment()
.addResourceFromClasspath("com/mhgadm/za/sample/sampleprocess.jpdl.xml")
.deploy();
System.out.println("The porecess id is deployed with id "+deploymentId);
}
private static void buildConfiguration() {
processEngine=Configuration.getProcessEngine();
repositoryService=processEngine.getRepositoryService();
executionService=processEngine.getExecutionService();
managementService=processEngine.getManagementService();
taskService=processEngine.getTaskService();
historyService=processEngine.getHistoryService();
identityService=processEngine.getIdentityService();
}
}
=== Stacktrace ==============================
11:18:21,532 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:18:21,532 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:18:21,532 FST | [LongType] returning '2' as column: LONGVAL6_1_0_
11:18:21,532 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:18:21,532 FST | [LongType] returning '30006' as column: DBID1_1_
11:18:21,532 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,532 FST | [LongType] binding '40001' to parameter: 1
11:18:21,532 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,532 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,532 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,532 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:18:21,532 FST | [LongType] binding '40001' to parameter: 1
11:18:21,532 FST | [LongType] returning '40002' as column: DBID1_5_0_
11:18:21,547 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:18:21,547 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_
11:18:21,547 FST | [LongType] returning '40002' as column: DBID1_1_
11:18:21,547 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:18:21,594 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:18:21,594 FST | [LongType] binding '40001' to parameter: 1
11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40003' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40004' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40005' as column: DBID1_1_
11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:18:21,610 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:18:21,610 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:18:21,610 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:18:21,610 FST | [LongType] returning '3' as column: LONGVAL6_1_0_
11:18:21,610 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:18:21,610 FST | [LongType] returning '40006' as column: DBID1_1_
11:18:21,625 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '1' as column: col_1_0_
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '30001' as column: col_1_0_
11:18:21,625 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,625 FST | [LongType] returning '40001' as column: col_1_0_
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
11:18:21,641 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
11:18:21,641 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,641 FST | [LongType] returning '40001' as column: col_1_0_
11:18:21,657 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-4'
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50004' to parameter: 6
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50005' to parameter: 6
11:18:21,657 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:18:21,657 FST | [LongType] binding null to parameter: 1
11:18:21,657 FST | [StringType] binding null to parameter: 2
11:18:21,657 FST | [StringType] binding null to parameter: 3
11:18:21,657 FST | [StringType] binding null to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50006' to parameter: 6
11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:18:21,657 FST | [LongType] binding '50001' to parameter: 1
11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,657 FST | [StringType] binding 'pdid' to parameter: 3
11:18:21,657 FST | [StringType] binding 'sp-4' to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,657 FST | [LongType] binding '50004' to parameter: 6
11:18:21,657 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:18:21,657 FST | [LongType] binding '50001' to parameter: 1
11:18:21,657 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,657 FST | [StringType] binding 'pdkey' to parameter: 3
11:18:21,657 FST | [StringType] binding 'sp' to parameter: 4
11:18:21,657 FST | [LongType] binding null to parameter: 5
11:18:21,672 FST | [LongType] binding '50005' to parameter: 6
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:18:21,672 FST | [StringType] binding 'pdversion' to parameter: 3
11:18:21,672 FST | [StringType] binding null to parameter: 4
11:18:21,672 FST | [LongType] binding '4' to parameter: 5
11:18:21,672 FST | [LongType] binding '50006' to parameter: 6
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50005' to parameter: 2
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50004' to parameter: 2
11:18:21,672 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:18:21,672 FST | [LongType] binding '50001' to parameter: 1
11:18:21,672 FST | [LongType] binding '50006' to parameter: 2
11:18:21,672 FIN | [HibernateSessionResource] ----- committing hibernate tx 81758996 -------------------------------------------------------
The porecess id is deployed with id 50001
11:18:21,672 FIN | [HibernateSessionResource] ----- beginning hibernate tx 878190908 --------------------------------------------------------
11:18:21,672 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
11:18:21,672 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,672 FST | [LongType] returning '50001' as column: col_1_0_
11:18:21,672 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?
11:18:21,688 FST | [LongType] returning '50004' as column: DBID1_1_
11:18:21,688 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:18:21,688 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:18:21,688 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:18:21,688 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_
11:18:21,688 FST | [LongType] returning null as column: LONGVAL6_1_
11:18:21,688 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,688 FST | [LongType] binding '50001' to parameter: 1
11:18:21,688 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,688 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,688 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,688 FIN | [ProcessDefinitionImpl] creating new execution for process 'sampleprocess'
11:18:21,688 FIN | [DatabaseIdComposer] generated execution id sp.50007
11:18:21,703 FIN | [ExecuteActivity] executing activity(175735253)
11:18:21,703 FIN | [ExecuteActivity] executing activity(a)
11:18:21,703 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,703 FST | [StringType] binding null to parameter: 2
11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,703 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,703 FST | [StringType] binding null to parameter: 5
11:18:21,703 FST | [StringType] binding null to parameter: 6
11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,703 FST | [StringType] binding 'created' to parameter: 8
11:18:21,703 FST | [StringType] binding null to parameter: 9
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,703 FST | [LongType] binding null to parameter: 11
11:18:21,703 FST | [LongType] binding null to parameter: 12
11:18:21,703 FST | [LongType] binding '50007' to parameter: 13
11:18:21,703 FST | [LongType] binding null to parameter: 14
11:18:21,703 FST | [LongType] binding null to parameter: 15
11:18:21,703 FST | [LongType] binding '50007' to parameter: 16
11:18:21,703 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
11:18:21,703 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,703 FST | [StringType] binding 'sp.50007' to parameter: 2
11:18:21,703 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,703 FST | [StringType] binding null to parameter: 4
11:18:21,703 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 5
11:18:21,703 FST | [TimestampType] binding null to parameter: 6
11:18:21,703 FST | [LongType] binding null to parameter: 7
11:18:21,703 FST | [StringType] binding 'active' to parameter: 8
11:18:21,703 FST | [StringType] binding null to parameter: 9
11:18:21,703 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,703 FST | [LongType] binding '50007' to parameter: 11
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,719 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,719 FST | [LongType] binding '50007' to parameter: 2
11:18:21,719 FST | [StringType] binding 'state' to parameter: 3
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 4
11:18:21,719 FST | [StringType] binding 'a' to parameter: 5
11:18:21,719 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,719 FST | [TimestampType] binding null to parameter: 7
11:18:21,719 FST | [LongType] binding '0' to parameter: 8
11:18:21,719 FST | [StringType] binding null to parameter: 9
11:18:21,719 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,719 FST | [LongType] binding '50008' to parameter: 11
11:18:21,719 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
11:18:21,719 FST | [IntegerType] binding '1' to parameter: 1
11:18:21,719 FST | [StringType] binding 'a' to parameter: 2
11:18:21,719 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,719 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,719 FST | [StringType] binding null to parameter: 5
11:18:21,719 FST | [StringType] binding null to parameter: 6
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,719 FST | [StringType] binding 'active-root' to parameter: 8
11:18:21,719 FST | [StringType] binding null to parameter: 9
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,719 FST | [LongType] binding '50008' to parameter: 11
11:18:21,719 FST | [LongType] binding null to parameter: 12
11:18:21,719 FST | [LongType] binding '50007' to parameter: 13
11:18:21,719 FST | [LongType] binding null to parameter: 14
11:18:21,719 FST | [LongType] binding null to parameter: 15
11:18:21,719 FST | [LongType] binding '50007' to parameter: 16
11:18:21,719 FST | [IntegerType] binding '0' to parameter: 17
11:18:21,719 FIN | [HibernateSessionResource] ----- committing hibernate tx 1253587936 -------------------------------------------------------
The No of active executions are :1
Execution is execution[sp.50007]
11:18:21,719 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1658340521 --------------------------------------------------------
11:18:21,719 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?
11:18:21,719 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,719 FST | [LongType] returning '50007' as column: DBID1_3_
11:18:21,719 FST | [IntegerType] returning '1' as column: DBVERSION3_3_
11:18:21,719 FST | [StringType] returning 'a' as column: ACTIVITY4_3_
11:18:21,719 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_
11:18:21,719 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:18:21,719 FST | [StringType] returning null as column: NAME7_3_
11:18:21,719 FST | [StringType] returning null as column: KEY8_3_
11:18:21,719 FST | [StringType] returning 'sp.50007' as column: ID9_3_
11:18:21,719 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:18:21,719 FST | [StringType] returning null as column: SUSPHIS11_3_
11:18:21,719 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:18:21,719 FST | [LongType] returning '50008' as column: HISACTINST13_3_
11:18:21,719 FST | [LongType] returning null as column: PARENT14_3_
11:18:21,719 FST | [LongType] returning '50007' as column: INSTANCE15_3_
11:18:21,719 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:18:21,719 FST | [LongType] returning null as column: SUBPROC17_3_
11:18:21,719 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:18:21,735 FST | [LongType] binding '50007' to parameter: 1
11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-4' limit ?
11:18:21,735 FST | [LongType] returning '50004' as column: DBID1_1_
11:18:21,735 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:18:21,735 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:18:21,735 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:18:21,735 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_
11:18:21,735 FST | [LongType] returning null as column: LONGVAL6_1_
11:18:21,735 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,735 FST | [LongType] binding '50001' to parameter: 1
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:18:21,735 FST | [TextType] returning null as column: NAME2_0_0_
11:18:21,735 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:18:21,735 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:18:21,735 FIN | [Signal] signalling activity(a), signalName=null
11:18:21,735 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
11:18:21,735 FST | [LongType] binding '50008' to parameter: 1
11:18:21,735 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,735 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:18:21,735 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,735 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,735 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,735 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_
11:18:21,750 FST | [TimestampType] returning null as column: END9_8_0_
11:18:21,750 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:18:21,750 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,750 FIN | [ExecuteActivity] executing activity(b)
11:18:21,750 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
11:18:21,750 FST | [LongType] binding '50007' to parameter: 1
Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
11:18:21,750 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:18:21,750 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_
11:18:21,750 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_
11:18:21,750 FST | [StringType] returning null as column: KEY5_7_0_
11:18:21,750 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START6_7_0_
11:18:21,750 FST | [TimestampType] returning null as column: END7_7_0_
11:18:21,750 FST | [LongType] returning null as column: DURATION8_7_0_
11:18:21,750 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:18:21,750 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:18:21,750 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:18:21,750 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,750 FST | [IntegerType] binding '0' to parameter: 1
11:18:21,750 FST | [LongType] binding '50007' to parameter: 2
11:18:21,750 FST | [StringType] binding 'state' to parameter: 3
11:18:21,750 FST | [StringType] binding 'sp.50007' to parameter: 4
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:18:21,750 FST | [StringType] binding 'b' to parameter: 5
11:18:21,750 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,750 FST | [TimestampType] binding null to parameter: 7
11:18:21,750 FST | [LongType] binding '0' to parameter: 8
11:18:21,750 FST | [StringType] binding null to parameter: 9
11:18:21,750 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,766 FST | [LongType] binding '50009' to parameter: 11
11:18:21,766 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
11:18:21,766 FST | [IntegerType] binding '2' to parameter: 1
11:18:21,766 FST | [StringType] binding 'b' to parameter: 2
11:18:21,766 FST | [StringType] binding 'sp-4' to parameter: 3
11:18:21,766 FST | [BooleanType] binding 'false' to parameter: 4
11:18:21,766 FST | [StringType] binding null to parameter: 5
11:18:21,766 FST | [StringType] binding null to parameter: 6
11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 7
11:18:21,766 FST | [StringType] binding 'active-root' to parameter: 8
11:18:21,766 FST | [StringType] binding null to parameter: 9
11:18:21,766 FST | [IntegerType] binding '0' to parameter: 10
11:18:21,766 FST | [LongType] binding '50009' to parameter: 11
11:18:21,766 FST | [LongType] binding null to parameter: 12
11:18:21,766 FST | [LongType] binding '50007' to parameter: 13
11:18:21,766 FST | [LongType] binding null to parameter: 14
11:18:21,766 FST | [LongType] binding null to parameter: 15
11:18:21,766 FST | [LongType] binding '50007' to parameter: 16
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 17
11:18:21,766 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 1
11:18:21,766 FST | [LongType] binding '50007' to parameter: 2
11:18:21,766 FST | [StringType] binding 'state' to parameter: 3
11:18:21,766 FST | [StringType] binding 'sp.50007' to parameter: 4
11:18:21,766 FST | [StringType] binding 'a' to parameter: 5
11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 6
11:18:21,766 FST | [TimestampType] binding '2010-10-01 11:18:21' to parameter: 7
11:18:21,766 FST | [LongType] binding '735' to parameter: 8
11:18:21,766 FST | [StringType] binding null to parameter: 9
11:18:21,766 FST | [IntegerType] binding '1' to parameter: 10
11:18:21,766 FST | [LongType] binding '50008' to parameter: 11
11:18:21,766 FST | [IntegerType] binding '0' to parameter: 12
11:18:21,766 FIN | [HibernateSessionResource] ----- committing hibernate tx 1046388151 -------------------------------------------------------
Execution is execution[sp.50007]
11:18:21,766 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1741604980 --------------------------------------------------------
11:18:21,781 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=50001
11:18:21,781 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:18:21,781 FST | [LongType] returning '50001' as column: col_1_0_
11:18:21,797 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
11:18:21,797 FST | [StringType] binding 'sp-4' to parameter: 1
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: col_0_0_
11:18:21,797 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
11:18:21,797 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,797 FST | [LongType] returning '50007' as column: DBID1_7_0_
11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: ID3_7_0_
11:18:21,797 FST | [StringType] returning 'sp-4' as column: PROCDEFID4_7_0_
11:18:21,797 FST | [StringType] returning null as column: KEY5_7_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START6_7_0_
11:18:21,797 FST | [TimestampType] returning null as column: END7_7_0_
11:18:21,797 FST | [LongType] returning null as column: DURATION8_7_0_
11:18:21,797 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:18:21,797 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:18:21,797 FIN | [DbSessionImpl] deleting history process instance sp.50007
11:18:21,797 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
11:18:21,797 FST | [LongType] binding '50007' to parameter: 1
11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_8_0_
11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,797 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: END9_8_0_
11:18:21,797 FST | [LongType] returning '735' as column: DURATION10_8_0_
11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_
11:18:21,797 FST | [LongType] returning '50008' as column: DBID1_1_
11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_8_0_
11:18:21,797 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:18:21,797 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_8_0_
11:18:21,797 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:18:21,797 FST | [StringType] returning 'sp.50007' as column: EXECUTION6_8_0_
11:18:21,797 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_
11:18:21,797 FST | [TimestampType] returning '2010-10-01 11:18:21' as column: START8_8_0_
11:18:21,797 FST | [TimestampType] returning null as column: END9_8_0_
11:18:21,797 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:18:21,797 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:18:21,797 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:18:21,797 FST | [LongType] returning '50007' as column: HPROCI4_1_
11:18:21,797 FST | [LongType] returning '50009' as column: DBID1_1_
11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:18:21,797 FST | [LongType] binding '50008' to parameter: 1
11:18:21,797 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:18:21,797 FST | [LongType] binding '50009' to parameter: 1
11:18:21,813 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,813 FST | [LongType] returning '50007' as column: DBID1_3_
11:18:21,813 FST | [IntegerType] returning '2' as column: DBVERSION3_3_
11:18:21,813 FST | [StringType] returning 'b' as column: ACTIVITY4_3_
11:18:21,813 FST | [StringType] returning 'sp-4' as column: PROCDEFID5_3_
11:18:21,813 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:18:21,813 FST | [StringType] returning null as column: NAME7_3_
11:18:21,813 FST | [StringType] returning null as column: KEY8_3_
11:18:21,813 FST | [StringType] returning 'sp.50007' as column: ID9_3_
11:18:21,813 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:18:21,813 FST | [StringType] returning null as column: SUSPHIS11_3_
11:18:21,813 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:18:21,813 FST | [LongType] returning '50009' as column: HISACTINST13_3_
11:18:21,813 FST | [LongType] returning null as column: PARENT14_3_
11:18:21,813 FST | [LongType] returning '50007' as column: INSTANCE15_3_
11:18:21,813 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:18:21,813 FST | [LongType] returning null as column: SUBPROC17_3_
11:18:21,813 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:18:21,813 FST | [LongType] binding '50007' to parameter: 1
11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,813 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
11:18:21,813 FST | [StringType] binding 'sp.50007' to parameter: 1
11:18:21,828 FIN | [DbSessionImpl] Deleting process instance sp.50007
11:18:21,828 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50008' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '1' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50009' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '0' to parameter: 2
11:18:21,828 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
11:18:21,828 FST | [LongType] binding '50007' to parameter: 1
11:18:21,828 FST | [IntegerType] binding '2' to parameter: 2
11:18:21,844 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000
11:18:21,844 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
### EXCEPTION ###########################################
11:18:21,844 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 21 more
### EXCEPTION ###########################################
### EXCEPTION ###########################################
11:18:21,844 INF | [DefaultCommandService] exception while executing command mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@44a9a32c
org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 21 more
### EXCEPTION ###########################################
11:18:21,844 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 1561837803 -----------------------------------------------------
Exception in thread "main" org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#50007]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 21 more
=== Debug logs ==============================
11:20:17,794 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,794 FST | [LongType] binding '30001' to parameter: 1
11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,794 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,794 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,794 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,794 FST | [LongType] returning '30003' as column: DBID1_1_
11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,794 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,794 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,794 FST | [StringType] returning 'sp-2' as column: STRINGVAL5_1_0_
11:20:17,794 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,794 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,794 FST | [LongType] returning '30004' as column: DBID1_1_
11:20:17,794 FST | [LongType] returning '30005' as column: DBID1_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,809 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,809 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,809 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,809 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,809 FST | [LongType] returning '30005' as column: DBID1_1_
11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_0_
11:20:17,809 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,809 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,809 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,809 FST | [LongType] returning '2' as column: LONGVAL6_1_0_
11:20:17,809 FST | [LongType] returning '30001' as column: DEPLOYMENT2_1_
11:20:17,809 FST | [LongType] returning '30006' as column: DBID1_1_
11:20:17,809 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:17,809 FST | [LongType] binding '40001' to parameter: 1
11:20:17,809 FST | [TextType] returning null as column: NAME2_0_0_
11:20:17,809 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:17,809 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:17,809 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:20:17,809 FST | [LongType] binding '40001' to parameter: 1
11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_5_0_
11:20:17,809 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:20:17,809 FST | [LongType] returning '40001' as column: DEPLOYMENT4_1_
11:20:17,809 FST | [LongType] returning '40002' as column: DBID1_1_
11:20:17,809 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:20:17,887 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,887 FST | [LongType] binding '40001' to parameter: 1
11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40003' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'sp-3' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40004' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40005' as column: DBID1_1_
11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_0_
11:20:17,903 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,903 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,903 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,903 FST | [LongType] returning '3' as column: LONGVAL6_1_0_
11:20:17,903 FST | [LongType] returning '40001' as column: DEPLOYMENT2_1_
11:20:17,903 FST | [LongType] returning '40006' as column: DBID1_1_
11:20:17,903 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:17,903 FST | [LongType] binding '50001' to parameter: 1
11:20:17,903 FST | [TextType] returning null as column: NAME2_0_0_
11:20:17,903 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:17,903 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:17,903 FIN | [SQL] select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
Hibernate: select resources0_.DEPLOYMENT_ as DEPLOYMENT4_1_, resources0_.DBID_ as DBID1_1_, resources0_.NAME_ as NAME5_1_, resources0_.DBID_ as DBID1_5_0_, resources0_.DBVERSION_ as DBVERSION2_5_0_, resources0_.BLOB_VALUE_ as BLOB3_5_0_ from JBPM4_LOB resources0_ where resources0_.DEPLOYMENT_=?
11:20:17,903 FST | [LongType] binding '50001' to parameter: 1
11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_5_0_
11:20:17,903 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_
11:20:17,903 FST | [LongType] returning '50001' as column: DEPLOYMENT4_1_
11:20:17,903 FST | [LongType] returning '50002' as column: DBID1_1_
11:20:17,903 FST | [TextType] returning 'com/mhgadm/za/sample/sampleprocess.jpdl.xml' as column: NAME5_1_
11:20:17,981 FIN | [SQL] select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
Hibernate: select objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_, objectprop0_.DBID_ as DBID1_1_, objectprop0_.DBID_ as DBID1_1_0_, objectprop0_.DEPLOYMENT_ as DEPLOYMENT2_1_0_, objectprop0_.OBJNAME_ as OBJNAME3_1_0_, objectprop0_.KEY_ as KEY4_1_0_, objectprop0_.STRINGVAL_ as STRINGVAL5_1_0_, objectprop0_.LONGVAL_ as LONGVAL6_1_0_ from JBPM4_DEPLOYPROP objectprop0_ where objectprop0_.DEPLOYMENT_=?
11:20:17,981 FST | [LongType] binding '50001' to parameter: 1
11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'langid' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50003' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdid' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'sp-4' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50004' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning 'sp' as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning null as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50005' as column: DBID1_1_
11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_0_
11:20:17,981 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_0_
11:20:17,981 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_
11:20:17,981 FST | [StringType] returning null as column: STRINGVAL5_1_0_
11:20:17,981 FST | [LongType] returning '4' as column: LONGVAL6_1_0_
11:20:17,981 FST | [LongType] returning '50001' as column: DEPLOYMENT2_1_
11:20:17,981 FST | [LongType] returning '50006' as column: DBID1_1_
11:20:17,996 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp'
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '1' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '30001' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '40001' as column: col_1_0_
11:20:18,012 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,012 FST | [LongType] returning '50001' as column: col_1_0_
11:20:18,028 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
11:20:18,028 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,028 FST | [LongType] returning '50001' as column: col_1_0_
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'
11:20:18,029 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.STRINGVAL_='sp-5'
11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,029 FST | [LongType] binding null to parameter: 1
11:20:18,029 FST | [StringType] binding null to parameter: 2
11:20:18,029 FST | [StringType] binding null to parameter: 3
11:20:18,029 FST | [StringType] binding null to parameter: 4
11:20:18,029 FST | [LongType] binding null to parameter: 5
11:20:18,029 FST | [LongType] binding '60004' to parameter: 6
11:20:18,029 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [LongType] binding null to parameter: 1
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [StringType] binding null to parameter: 2
11:20:18,030 FST | [StringType] binding null to parameter: 3
11:20:18,030 FST | [StringType] binding null to parameter: 4
11:20:18,030 FST | [LongType] binding null to parameter: 5
11:20:18,030 FST | [LongType] binding '60005' to parameter: 6
11:20:18,030 FIN | [SQL] insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_DEPLOYPROP (DEPLOYMENT_, OBJNAME_, KEY_, STRINGVAL_, LONGVAL_, DBID_) values (?, ?, ?, ?, ?, ?)
11:20:18,030 FST | [LongType] binding null to parameter: 1
11:20:18,045 FST | [StringType] binding null to parameter: 2
11:20:18,045 FST | [StringType] binding null to parameter: 3
11:20:18,045 FST | [StringType] binding null to parameter: 4
11:20:18,045 FST | [LongType] binding null to parameter: 5
11:20:18,045 FST | [LongType] binding '60006' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdid' to parameter: 3
11:20:18,061 FST | [StringType] binding 'sp-5' to parameter: 4
11:20:18,061 FST | [LongType] binding null to parameter: 5
11:20:18,061 FST | [LongType] binding '60004' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdkey' to parameter: 3
11:20:18,061 FST | [StringType] binding 'sp' to parameter: 4
11:20:18,061 FST | [LongType] binding null to parameter: 5
11:20:18,061 FST | [LongType] binding '60005' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=?, OBJNAME_=?, KEY_=?, STRINGVAL_=?, LONGVAL_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [StringType] binding 'sampleprocess' to parameter: 2
11:20:18,061 FST | [StringType] binding 'pdversion' to parameter: 3
11:20:18,061 FST | [StringType] binding null to parameter: 4
11:20:18,061 FST | [LongType] binding '5' to parameter: 5
11:20:18,061 FST | [LongType] binding '60006' to parameter: 6
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60005' to parameter: 2
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60006' to parameter: 2
11:20:18,061 FIN | [SQL] update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
Hibernate: update JBPM4_DEPLOYPROP set DEPLOYMENT_=? where DBID_=?
11:20:18,061 FST | [LongType] binding '60001' to parameter: 1
11:20:18,061 FST | [LongType] binding '60004' to parameter: 2
11:20:18,061 FIN | [HibernateSessionResource] ----- committing hibernate tx 785383518 -------------------------------------------------------
The porecess id is deployed with id 60001
11:20:18,061 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1221338506 --------------------------------------------------------
11:20:18,061 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.STRINGVAL_='sp' order by deployment3_.LONGVAL_ desc limit ?
11:20:18,061 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,061 FST | [LongType] returning '60001' as column: col_1_0_
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,076 FST | [LongType] returning '60004' as column: DBID1_1_
11:20:18,076 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_
11:20:18,076 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
11:20:18,076 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:20:18,076 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_
11:20:18,076 FST | [LongType] returning null as column: LONGVAL6_1_
11:20:18,076 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,076 FST | [LongType] binding '60001' to parameter: 1
11:20:18,076 FST | [TextType] returning null as column: NAME2_0_0_
11:20:18,076 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:18,076 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:18,076 FIN | [ProcessDefinitionImpl] creating new execution for process 'sampleprocess'
11:20:18,076 FIN | [DatabaseIdComposer] generated execution id sp.60007
11:20:18,092 FIN | [ExecuteActivity] executing activity(1421269392)
11:20:18,092 FIN | [ExecuteActivity] executing activity(a)
11:20:18,092 FIN | [SQL] insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
Hibernate: insert into JBPM4_EXECUTION (DBVERSION_, ACTIVITYNAME_, PROCDEFID_, HASVARS_, NAME_, KEY_, ID_, STATE_, SUSPHISTSTATE_, PRIORITY_, HISACTINST_, PARENT_, INSTANCE_, SUPEREXEC_, SUBPROCINST_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pvm', ?)
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,092 FST | [StringType] binding null to parameter: 2
11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,092 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,092 FST | [StringType] binding null to parameter: 5
11:20:18,092 FST | [StringType] binding null to parameter: 6
11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,092 FST | [StringType] binding 'created' to parameter: 8
11:20:18,092 FST | [StringType] binding null to parameter: 9
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,092 FST | [LongType] binding null to parameter: 11
11:20:18,092 FST | [LongType] binding null to parameter: 12
11:20:18,092 FST | [LongType] binding '60007' to parameter: 13
11:20:18,092 FST | [LongType] binding null to parameter: 14
11:20:18,092 FST | [LongType] binding null to parameter: 15
11:20:18,092 FST | [LongType] binding '60007' to parameter: 16
11:20:18,092 FIN | [SQL] insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Hibernate: insert into JBPM4_HIST_PROCINST (DBVERSION_, ID_, PROCDEFID_, KEY_, START_, END_, DURATION_, STATE_, ENDACTIVITY_, NEXTIDX_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
11:20:18,092 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,092 FST | [StringType] binding 'sp.60007' to parameter: 2
11:20:18,092 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,092 FST | [StringType] binding null to parameter: 4
11:20:18,092 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 5
11:20:18,108 FST | [TimestampType] binding null to parameter: 6
11:20:18,108 FST | [LongType] binding null to parameter: 7
11:20:18,108 FST | [StringType] binding 'active' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,108 FST | [LongType] binding '60007' to parameter: 11
11:20:18,108 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,108 FST | [LongType] binding '60007' to parameter: 2
11:20:18,108 FST | [StringType] binding 'state' to parameter: 3
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,108 FST | [StringType] binding 'a' to parameter: 5
11:20:18,108 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,108 FST | [TimestampType] binding null to parameter: 7
11:20:18,108 FST | [LongType] binding '0' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,108 FST | [LongType] binding '60008' to parameter: 11
11:20:18,108 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
11:20:18,108 FST | [IntegerType] binding '1' to parameter: 1
11:20:18,108 FST | [StringType] binding 'a' to parameter: 2
11:20:18,108 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,108 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,108 FST | [StringType] binding null to parameter: 5
11:20:18,108 FST | [StringType] binding null to parameter: 6
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,108 FST | [StringType] binding 'active-root' to parameter: 8
11:20:18,108 FST | [StringType] binding null to parameter: 9
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,108 FST | [LongType] binding '60008' to parameter: 11
11:20:18,108 FST | [LongType] binding null to parameter: 12
11:20:18,108 FST | [LongType] binding '60007' to parameter: 13
11:20:18,108 FST | [LongType] binding null to parameter: 14
11:20:18,108 FST | [LongType] binding null to parameter: 15
11:20:18,108 FST | [LongType] binding '60007' to parameter: 16
11:20:18,108 FST | [IntegerType] binding '0' to parameter: 17
11:20:18,108 FIN | [HibernateSessionResource] ----- committing hibernate tx 2113092528 -------------------------------------------------------
The No of active executions are :1
Execution is execution[sp.60007]
11:20:18,108 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1584118582 --------------------------------------------------------
11:20:18,108 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? limit ?
11:20:18,108 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,123 FST | [LongType] returning '60007' as column: DBID1_3_
11:20:18,123 FST | [IntegerType] returning '1' as column: DBVERSION3_3_
11:20:18,123 FST | [StringType] returning 'a' as column: ACTIVITY4_3_
11:20:18,123 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_
11:20:18,123 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:20:18,123 FST | [StringType] returning null as column: NAME7_3_
11:20:18,123 FST | [StringType] returning null as column: KEY8_3_
11:20:18,123 FST | [StringType] returning 'sp.60007' as column: ID9_3_
11:20:18,123 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:20:18,123 FST | [StringType] returning null as column: SUSPHIS11_3_
11:20:18,123 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:20:18,123 FST | [LongType] returning '60008' as column: HISACTINST13_3_
11:20:18,123 FST | [LongType] returning null as column: PARENT14_3_
11:20:18,123 FST | [LongType] returning '60007' as column: INSTANCE15_3_
11:20:18,123 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:20:18,123 FST | [LongType] returning null as column: SUBPROC17_3_
11:20:18,123 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:20:18,123 FST | [LongType] binding '60007' to parameter: 1
11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?
11:20:18,123 FST | [LongType] returning '60004' as column: DBID1_1_
11:20:18,123 FST | [LongType] returning '60001' as column: DEPLOYMENT2_1_
11:20:18,123 FST | [StringType] returning 'sampleprocess' as column: OBJNAME3_1_
Hibernate: select deployment0_.DBID_ as DBID1_1_, deployment0_.DEPLOYMENT_ as DEPLOYMENT2_1_, deployment0_.OBJNAME_ as OBJNAME3_1_, deployment0_.KEY_ as KEY4_1_, deployment0_.STRINGVAL_ as STRINGVAL5_1_, deployment0_.LONGVAL_ as LONGVAL6_1_ from JBPM4_DEPLOYPROP deployment0_ where deployment0_.KEY_='pdid' and deployment0_.STRINGVAL_='sp-5' limit ?
Hibernate: select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,123 FST | [StringType] returning 'pdid' as column: KEY4_1_
11:20:18,123 FST | [StringType] returning 'sp-5' as column: STRINGVAL5_1_
11:20:18,123 FST | [LongType] returning null as column: LONGVAL6_1_
11:20:18,123 FIN | [SQL] select deployment0_.DBID_ as DBID1_0_0_, deployment0_.NAME_ as NAME2_0_0_, deployment0_.TIMESTAMP_ as TIMESTAMP3_0_0_, deployment0_.STATE_ as STATE4_0_0_ from JBPM4_DEPLOYMENT deployment0_ where deployment0_.DBID_=?
11:20:18,123 FST | [LongType] binding '60001' to parameter: 1
11:20:18,123 FST | [TextType] returning null as column: NAME2_0_0_
11:20:18,123 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_
11:20:18,123 FST | [StringType] returning 'active' as column: STATE4_0_0_
11:20:18,123 FIN | [Signal] signalling activity(a), signalName=null
Hibernate: select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
11:20:18,139 FIN | [SQL] select historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.DBID_=?
11:20:18,139 FST | [LongType] binding '60008' to parameter: 1
11:20:18,139 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:20:18,139 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,139 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,139 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,139 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_
11:20:18,139 FST | [TimestampType] returning null as column: END9_8_0_
11:20:18,139 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:20:18,139 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,139 FIN | [ExecuteActivity] executing activity(b)
11:20:18,139 FIN | [SQL] select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
Hibernate: select historypro0_.DBID_ as DBID1_7_0_, historypro0_.DBVERSION_ as DBVERSION2_7_0_, historypro0_.ID_ as ID3_7_0_, historypro0_.PROCDEFID_ as PROCDEFID4_7_0_, historypro0_.KEY_ as KEY5_7_0_, historypro0_.START_ as START6_7_0_, historypro0_.END_ as END7_7_0_, historypro0_.DURATION_ as DURATION8_7_0_, historypro0_.STATE_ as STATE9_7_0_, historypro0_.ENDACTIVITY_ as ENDACTI10_7_0_, historypro0_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST historypro0_ where historypro0_.DBID_=?
11:20:18,139 FST | [LongType] binding '60007' to parameter: 1
11:20:18,139 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:20:18,139 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_
11:20:18,139 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_
11:20:18,139 FST | [StringType] returning null as column: KEY5_7_0_
11:20:18,139 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START6_7_0_
11:20:18,139 FST | [TimestampType] returning null as column: END7_7_0_
11:20:18,139 FST | [LongType] returning null as column: DURATION8_7_0_
11:20:18,139 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:20:18,139 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:20:18,139 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:20:18,154 FIN | [SQL] insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
Hibernate: insert into JBPM4_HIST_ACTINST (DBVERSION_, HPROCI_, TYPE_, EXECUTION_, ACTIVITY_NAME_, START_, END_, DURATION_, TRANSITION_, NEXTIDX_, CLASS_, DBID_) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'act', ?)
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 1
11:20:18,154 FST | [LongType] binding '60007' to parameter: 2
11:20:18,154 FST | [StringType] binding 'state' to parameter: 3
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,154 FST | [StringType] binding 'b' to parameter: 5
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,154 FST | [TimestampType] binding null to parameter: 7
11:20:18,154 FST | [LongType] binding '0' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,154 FST | [LongType] binding '60009' to parameter: 11
11:20:18,154 FIN | [SQL] update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_EXECUTION set DBVERSION_=?, ACTIVITYNAME_=?, PROCDEFID_=?, HASVARS_=?, NAME_=?, KEY_=?, ID_=?, STATE_=?, SUSPHISTSTATE_=?, PRIORITY_=?, HISACTINST_=?, PARENT_=?, INSTANCE_=?, SUPEREXEC_=?, SUBPROCINST_=? where DBID_=? and DBVERSION_=?
11:20:18,154 FST | [IntegerType] binding '2' to parameter: 1
11:20:18,154 FST | [StringType] binding 'b' to parameter: 2
11:20:18,154 FST | [StringType] binding 'sp-5' to parameter: 3
11:20:18,154 FST | [BooleanType] binding 'false' to parameter: 4
11:20:18,154 FST | [StringType] binding null to parameter: 5
11:20:18,154 FST | [StringType] binding null to parameter: 6
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 7
11:20:18,154 FST | [StringType] binding 'active-root' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 10
11:20:18,154 FST | [LongType] binding '60009' to parameter: 11
11:20:18,154 FST | [LongType] binding null to parameter: 12
11:20:18,154 FST | [LongType] binding '60007' to parameter: 13
11:20:18,154 FST | [LongType] binding null to parameter: 14
11:20:18,154 FST | [LongType] binding null to parameter: 15
11:20:18,154 FST | [LongType] binding '60007' to parameter: 16
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 17
11:20:18,154 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?
Hibernate: update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 1
11:20:18,154 FST | [LongType] binding '60007' to parameter: 2
11:20:18,154 FST | [StringType] binding 'state' to parameter: 3
11:20:18,154 FST | [StringType] binding 'sp.60007' to parameter: 4
11:20:18,154 FST | [StringType] binding 'a' to parameter: 5
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 6
11:20:18,154 FST | [TimestampType] binding '2010-10-01 11:20:18' to parameter: 7
11:20:18,154 FST | [LongType] binding '139' to parameter: 8
11:20:18,154 FST | [StringType] binding null to parameter: 9
11:20:18,154 FST | [IntegerType] binding '1' to parameter: 10
11:20:18,154 FST | [LongType] binding '60008' to parameter: 11
11:20:18,154 FST | [IntegerType] binding '0' to parameter: 12
11:20:18,154 FIN | [HibernateSessionResource] ----- committing hibernate tx 1448415374 -------------------------------------------------------
Execution is execution[sp.60007]
11:20:18,170 FIN | [HibernateSessionResource] ----- beginning hibernate tx 252689000 --------------------------------------------------------
11:20:18,186 FIN | [SQL] select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001
Hibernate: select deployment1_.OBJNAME_ as col_0_0_, deployment1_.DEPLOYMENT_ as col_1_0_ from JBPM4_DEPLOYMENT deployment0_, JBPM4_DEPLOYPROP deployment1_, JBPM4_DEPLOYPROP deployment2_, JBPM4_DEPLOYPROP deployment3_ where deployment1_.KEY_='pdid' and deployment1_.DEPLOYMENT_=deployment0_.DBID_ and deployment2_.KEY_='pdkey' and deployment2_.OBJNAME_=deployment1_.OBJNAME_ and deployment2_.DEPLOYMENT_=deployment0_.DBID_ and deployment3_.KEY_='pdversion' and deployment3_.OBJNAME_=deployment1_.OBJNAME_ and deployment3_.DEPLOYMENT_=deployment0_.DBID_ and deployment1_.DEPLOYMENT_=60001
11:20:18,186 FST | [StringType] returning 'sampleprocess' as column: col_0_0_
11:20:18,186 FST | [LongType] returning '60001' as column: col_1_0_
11:20:18,186 FIN | [SQL] select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
Hibernate: select executioni0_.ID_ as col_0_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.PROCDEFID_=? and (executioni0_.PARENT_ is null)
11:20:18,186 FST | [StringType] binding 'sp-5' to parameter: 1
11:20:18,186 FST | [StringType] returning 'sp.60007' as column: col_0_0_
11:20:18,186 FIN | [SQL] select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
Hibernate: select this_.DBID_ as DBID1_7_0_, this_.DBVERSION_ as DBVERSION2_7_0_, this_.ID_ as ID3_7_0_, this_.PROCDEFID_ as PROCDEFID4_7_0_, this_.KEY_ as KEY5_7_0_, this_.START_ as START6_7_0_, this_.END_ as END7_7_0_, this_.DURATION_ as DURATION8_7_0_, this_.STATE_ as STATE9_7_0_, this_.ENDACTIVITY_ as ENDACTI10_7_0_, this_.NEXTIDX_ as NEXTIDX11_7_0_ from JBPM4_HIST_PROCINST this_ where this_.ID_=?
11:20:18,186 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,186 FST | [LongType] returning '60007' as column: DBID1_7_0_
11:20:18,186 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_
11:20:18,186 FST | [StringType] returning 'sp.60007' as column: ID3_7_0_
11:20:18,186 FST | [StringType] returning 'sp-5' as column: PROCDEFID4_7_0_
11:20:18,186 FST | [StringType] returning null as column: KEY5_7_0_
11:20:18,186 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START6_7_0_
11:20:18,186 FST | [TimestampType] returning null as column: END7_7_0_
11:20:18,186 FST | [LongType] returning null as column: DURATION8_7_0_
11:20:18,186 FST | [StringType] returning 'active' as column: STATE9_7_0_
11:20:18,186 FST | [StringType] returning null as column: ENDACTI10_7_0_
11:20:18,186 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_
11:20:18,186 FIN | [DbSessionImpl] deleting history process instance sp.60007
11:20:18,201 FIN | [SQL] select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
Hibernate: select historyact0_.HPROCI_ as HPROCI4_1_, historyact0_.DBID_ as DBID1_1_, historyact0_.DBID_ as DBID1_8_0_, historyact0_.DBVERSION_ as DBVERSION3_8_0_, historyact0_.HPROCI_ as HPROCI4_8_0_, historyact0_.TYPE_ as TYPE5_8_0_, historyact0_.EXECUTION_ as EXECUTION6_8_0_, historyact0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historyact0_.START_ as START8_8_0_, historyact0_.END_ as END9_8_0_, historyact0_.DURATION_ as DURATION10_8_0_, historyact0_.TRANSITION_ as TRANSITION11_8_0_, historyact0_.NEXTIDX_ as NEXTIDX12_8_0_, historyact0_.HTASK_ as HTASK13_8_0_, historyact0_.CLASS_ as CLASS2_8_0_ from JBPM4_HIST_ACTINST historyact0_ where historyact0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_8_0_
11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: DBVERSION3_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,201 FST | [StringType] returning 'a' as column: ACTIVITY7_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: END9_8_0_
11:20:18,201 FST | [LongType] returning '139' as column: DURATION10_8_0_
11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_
11:20:18,201 FST | [LongType] returning '60008' as column: DBID1_1_
11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_8_0_
11:20:18,201 FST | [StringType] returning 'act' as column: CLASS2_8_0_
11:20:18,201 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_8_0_
11:20:18,201 FST | [StringType] returning 'state' as column: TYPE5_8_0_
11:20:18,201 FST | [StringType] returning 'sp.60007' as column: EXECUTION6_8_0_
11:20:18,201 FST | [StringType] returning 'b' as column: ACTIVITY7_8_0_
11:20:18,201 FST | [TimestampType] returning '2010-10-01 11:20:18' as column: START8_8_0_
11:20:18,201 FST | [TimestampType] returning null as column: END9_8_0_
11:20:18,201 FST | [LongType] returning '0' as column: DURATION10_8_0_
11:20:18,201 FST | [StringType] returning null as column: TRANSITION11_8_0_
11:20:18,201 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_
11:20:18,201 FST | [LongType] returning '60007' as column: HPROCI4_1_
11:20:18,201 FST | [LongType] returning '60009' as column: DBID1_1_
11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:20:18,201 FST | [LongType] binding '60008' to parameter: 1
11:20:18,201 FIN | [SQL] select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
Hibernate: select details0_.HACTI_ as HACTI8_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HACTI_=?
11:20:18,201 FST | [LongType] binding '60009' to parameter: 1
11:20:18,201 FIN | [SQL] select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
Hibernate: select historyvar0_.HPROCI_ as HPROCI7_1_, historyvar0_.DBID_ as DBID1_1_, historyvar0_.DBID_ as DBID1_10_0_, historyvar0_.DBVERSION_ as DBVERSION2_10_0_, historyvar0_.PROCINSTID_ as PROCINSTID3_10_0_, historyvar0_.EXECUTIONID_ as EXECUTIO4_10_0_, historyvar0_.VARNAME_ as VARNAME5_10_0_, historyvar0_.VALUE_ as VALUE6_10_0_, historyvar0_.HPROCI_ as HPROCI7_10_0_, historyvar0_.HTASK_ as HTASK8_10_0_ from JBPM4_HIST_VAR historyvar0_ where historyvar0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FIN | [SQL] select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
Hibernate: select details0_.HPROCI_ as HPROCI6_1_, details0_.DBID_ as DBID1_1_, details0_.DBID_ as DBID1_11_0_, details0_.DBVERSION_ as DBVERSION3_11_0_, details0_.USERID_ as USERID4_11_0_, details0_.TIME_ as TIME5_11_0_, details0_.HPROCI_ as HPROCI6_11_0_, details0_.HPROCIIDX_ as HPROCIIDX7_11_0_, details0_.HACTI_ as HACTI8_11_0_, details0_.HACTIIDX_ as HACTIIDX9_11_0_, details0_.HTASK_ as HTASK10_11_0_, details0_.HTASKIDX_ as HTASKIDX11_11_0_, details0_.HVAR_ as HVAR12_11_0_, details0_.HVARIDX_ as HVARIDX13_11_0_, details0_.MESSAGE_ as MESSAGE14_11_0_, details0_.OLD_STR_ as OLD15_11_0_, details0_.NEW_STR_ as NEW16_11_0_, details0_.OLD_INT_ as OLD17_11_0_, details0_.NEW_INT_ as NEW18_11_0_, details0_.OLD_TIME_ as OLD19_11_0_, details0_.NEW_TIME_ as NEW20_11_0_, details0_.CLASS_ as CLASS2_11_0_ from JBPM4_HIST_DETAIL details0_ where details0_.HPROCI_=?
11:20:18,201 FST | [LongType] binding '60007' to parameter: 1
11:20:18,201 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
Hibernate: select executioni0_.DBID_ as DBID1_3_, executioni0_.DBVERSION_ as DBVERSION3_3_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_, executioni0_.PROCDEFID_ as PROCDEFID5_3_, executioni0_.HASVARS_ as HASVARS6_3_, executioni0_.NAME_ as NAME7_3_, executioni0_.KEY_ as KEY8_3_, executioni0_.ID_ as ID9_3_, executioni0_.STATE_ as STATE10_3_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_, executioni0_.PRIORITY_ as PRIORITY12_3_, executioni0_.HISACTINST_ as HISACTINST13_3_, executioni0_.PARENT_ as PARENT14_3_, executioni0_.INSTANCE_ as INSTANCE15_3_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_, executioni0_.SUBPROCINST_ as SUBPROC17_3_ from JBPM4_EXECUTION executioni0_ where executioni0_.ID_=? and (executioni0_.PARENT_ is null) limit ?
11:20:18,201 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FST | [LongType] returning '60007' as column: DBID1_3_
11:20:18,217 FST | [IntegerType] returning '2' as column: DBVERSION3_3_
11:20:18,217 FST | [StringType] returning 'b' as column: ACTIVITY4_3_
11:20:18,217 FST | [StringType] returning 'sp-5' as column: PROCDEFID5_3_
11:20:18,217 FST | [BooleanType] returning 'false' as column: HASVARS6_3_
11:20:18,217 FST | [StringType] returning null as column: NAME7_3_
11:20:18,217 FST | [StringType] returning null as column: KEY8_3_
11:20:18,217 FST | [StringType] returning 'sp.60007' as column: ID9_3_
11:20:18,217 FST | [StringType] returning 'active-root' as column: STATE10_3_
11:20:18,217 FST | [StringType] returning null as column: SUSPHIS11_3_
11:20:18,217 FST | [IntegerType] returning '0' as column: PRIORITY12_3_
11:20:18,217 FST | [LongType] returning '60009' as column: HISACTINST13_3_
11:20:18,217 FST | [LongType] returning null as column: PARENT14_3_
11:20:18,217 FST | [LongType] returning '60007' as column: INSTANCE15_3_
11:20:18,217 FST | [LongType] returning null as column: SUPEREXEC16_3_
11:20:18,217 FST | [LongType] returning null as column: SUBPROC17_3_
11:20:18,217 FIN | [SQL] select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
Hibernate: select executions0_.PARENT_ as PARENT14_1_, executions0_.DBID_ as DBID1_1_, executions0_.PARENT_IDX_ as PARENT18_1_, executions0_.DBID_ as DBID1_3_0_, executions0_.DBVERSION_ as DBVERSION3_3_0_, executions0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executions0_.PROCDEFID_ as PROCDEFID5_3_0_, executions0_.HASVARS_ as HASVARS6_3_0_, executions0_.NAME_ as NAME7_3_0_, executions0_.KEY_ as KEY8_3_0_, executions0_.ID_ as ID9_3_0_, executions0_.STATE_ as STATE10_3_0_, executions0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executions0_.PRIORITY_ as PRIORITY12_3_0_, executions0_.HISACTINST_ as HISACTINST13_3_0_, executions0_.PARENT_ as PARENT14_3_0_, executions0_.INSTANCE_ as INSTANCE15_3_0_, executions0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executions0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executions0_ where executions0_.PARENT_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_12_1_, this_.DBVERSION_ as DBVERSION3_12_1_, this_.NAME_ as NAME4_12_1_, this_.DESCR_ as DESCR5_12_1_, this_.STATE_ as STATE6_12_1_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_1_, this_.ASSIGNEE_ as ASSIGNEE8_12_1_, this_.FORM_ as FORM9_12_1_, this_.PRIORITY_ as PRIORITY10_12_1_, this_.CREATE_ as CREATE11_12_1_, this_.DUEDATE_ as DUEDATE12_12_1_, this_.PROGRESS_ as PROGRESS13_12_1_, this_.SIGNALLING_ as SIGNALLING14_12_1_, this_.EXECUTION_ID_ as EXECUTION15_12_1_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_1_, this_.HASVARS_ as HASVARS17_12_1_, this_.SUPERTASK_ as SUPERTASK18_12_1_, this_.EXECUTION_ as EXECUTION19_12_1_, this_.PROCINST_ as PROCINST20_12_1_, this_.SWIMLANE_ as SWIMLANE21_12_1_, this_.TASKDEFNAME_ as TASKDEF22_12_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_TASK this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCINST_=pi1_.DBID_ where pi1_.ID_=?
11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FIN | [SQL] select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
Hibernate: select this_.DBID_ as DBID1_6_1_, this_.DBVERSION_ as DBVERSION3_6_1_, this_.DUEDATE_ as DUEDATE4_6_1_, this_.STATE_ as STATE5_6_1_, this_.ISEXCLUSIVE_ as ISEXCLUS6_6_1_, this_.LOCKOWNER_ as LOCKOWNER7_6_1_, this_.LOCKEXPTIME_ as LOCKEXPT8_6_1_, this_.EXCEPTION_ as EXCEPTION9_6_1_, this_.RETRIES_ as RETRIES10_6_1_, this_.PROCESSINSTANCE_ as PROCESS11_6_1_, this_.EXECUTION_ as EXECUTION12_6_1_, this_.CFG_ as CFG13_6_1_, this_.SIGNAL_ as SIGNAL14_6_1_, this_.EVENT_ as EVENT15_6_1_, this_.REPEAT_ as REPEAT16_6_1_, this_.CLASS_ as CLASS2_6_1_, pi1_.DBID_ as DBID1_3_0_, pi1_.DBVERSION_ as DBVERSION3_3_0_, pi1_.ACTIVITYNAME_ as ACTIVITY4_3_0_, pi1_.PROCDEFID_ as PROCDEFID5_3_0_, pi1_.HASVARS_ as HASVARS6_3_0_, pi1_.NAME_ as NAME7_3_0_, pi1_.KEY_ as KEY8_3_0_, pi1_.ID_ as ID9_3_0_, pi1_.STATE_ as STATE10_3_0_, pi1_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, pi1_.PRIORITY_ as PRIORITY12_3_0_, pi1_.HISACTINST_ as HISACTINST13_3_0_, pi1_.PARENT_ as PARENT14_3_0_, pi1_.INSTANCE_ as INSTANCE15_3_0_, pi1_.SUPEREXEC_ as SUPEREXEC16_3_0_, pi1_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_JOB this_ inner join JBPM4_EXECUTION pi1_ on this_.PROCESSINSTANCE_=pi1_.DBID_ where pi1_.ID_=?
11:20:18,217 FST | [StringType] binding 'sp.60007' to parameter: 1
11:20:18,217 FIN | [DbSessionImpl] Deleting process instance sp.60007
11:20:18,217 FIN | [SQL] select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
Hibernate: select variables0_.EXECUTION_ as EXECUTION7_1_, variables0_.DBID_ as DBID1_1_, variables0_.KEY_ as KEY4_1_, variables0_.DBID_ as DBID1_4_0_, variables0_.DBVERSION_ as DBVERSION3_4_0_, variables0_.KEY_ as KEY4_4_0_, variables0_.CONVERTER_ as CONVERTER5_4_0_, variables0_.HIST_ as HIST6_4_0_, variables0_.EXECUTION_ as EXECUTION7_4_0_, variables0_.TASK_ as TASK8_4_0_, variables0_.LOB_ as LOB9_4_0_, variables0_.DATE_VALUE_ as DATE10_4_0_, variables0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, variables0_.CLASSNAME_ as CLASSNAME12_4_0_, variables0_.LONG_VALUE_ as LONG13_4_0_, variables0_.STRING_VALUE_ as STRING14_4_0_, variables0_.TEXT_VALUE_ as TEXT15_4_0_, variables0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE variables0_ where variables0_.EXECUTION_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
Hibernate: select systemvari0_.EXESYS_ as EXESYS16_1_, systemvari0_.DBID_ as DBID1_1_, systemvari0_.KEY_ as KEY4_1_, systemvari0_.DBID_ as DBID1_4_0_, systemvari0_.DBVERSION_ as DBVERSION3_4_0_, systemvari0_.KEY_ as KEY4_4_0_, systemvari0_.CONVERTER_ as CONVERTER5_4_0_, systemvari0_.HIST_ as HIST6_4_0_, systemvari0_.EXECUTION_ as EXECUTION7_4_0_, systemvari0_.TASK_ as TASK8_4_0_, systemvari0_.LOB_ as LOB9_4_0_, systemvari0_.DATE_VALUE_ as DATE10_4_0_, systemvari0_.DOUBLE_VALUE_ as DOUBLE11_4_0_, systemvari0_.CLASSNAME_ as CLASSNAME12_4_0_, systemvari0_.LONG_VALUE_ as LONG13_4_0_, systemvari0_.STRING_VALUE_ as STRING14_4_0_, systemvari0_.TEXT_VALUE_ as TEXT15_4_0_, systemvari0_.CLASS_ as CLASS2_4_0_ from JBPM4_VARIABLE systemvari0_ where systemvari0_.EXESYS_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
Hibernate: select swimlanes0_.EXECUTION_ as EXECUTION5_1_, swimlanes0_.DBID_ as DBID1_1_, swimlanes0_.NAME_ as NAME3_1_, swimlanes0_.DBID_ as DBID1_14_0_, swimlanes0_.DBVERSION_ as DBVERSION2_14_0_, swimlanes0_.NAME_ as NAME3_14_0_, swimlanes0_.ASSIGNEE_ as ASSIGNEE4_14_0_, swimlanes0_.EXECUTION_ as EXECUTION5_14_0_ from JBPM4_SWIMLANE swimlanes0_ where swimlanes0_.EXECUTION_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,217 FIN | [SQL] update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
Hibernate: update JBPM4_HIST_ACTINST set HPROCI_=null where HPROCI_=?
11:20:18,217 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60008' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '1' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_ACTINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60009' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_HIST_PROCINST where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '0' to parameter: 2
11:20:18,232 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
Hibernate: delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?
11:20:18,232 FST | [LongType] binding '60007' to parameter: 1
11:20:18,232 FST | [IntegerType] binding '2' to parameter: 2
11:20:18,232 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 23000
11:20:18,232 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
### EXCEPTION ###########################################
11:20:18,232 SEV | [AbstractFlushingEventListener] Could not synchronize database state with session
org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#60007]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 21 more
### EXCEPTION ###########################################
### EXCEPTION ###########################################
11:20:18,232 INF | [DefaultCommandService] exception while executing command mailto:org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5 org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd@6a301bf5
org.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#60007]
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2569)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2725)
at org.hibernate.action.EntityDeleteAction.execute(EntityDeleteAction.java:97)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:172)
at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
at org.hibernate.event.def.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:64)
at org.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:996)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1589)
at org.hibernate.impl.CriteriaImpl.list(CriteriaImpl.java:306)
at org.jbpm.pvm.internal.hibernate.DbSessionImpl.deleteProcessDefinitionHistory(DbSessionImpl.java:113)
at org.jbpm.pvm.internal.cmd.DeleteDeploymentCmd.execute(DeleteDeploymentCmd.java:76)
at org.jbpm.pvm.internal.svc.DefaultCommandService.execute(DefaultCommandService.java:42)
at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:50)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.executeInNewEnvironment(EnvironmentInterceptor.java:53)
at org.jbpm.pvm.internal.svc.EnvironmentInterceptor.execute(EnvironmentInterceptor.java:40)
at org.jbpm.pvm.internal.svc.RetryInterceptor.execute(RetryInterceptor.java:56)
at org.jbpm.pvm.internal.svc.SkipInterceptor.execute(SkipInterceptor.java:43)
at org.jbpm.pvm.internal.repository.RepositoryServiceImpl.deleteDeploymentCascade(RepositoryServiceImpl.java:71)
at com.mhgadm.za.sample.SampleProcessTest.deleteProcessDefinitation(SampleProcessTest.java:53)
at com.mhgadm.za.sample.SampleProcessTest.main(SampleProcessTest.java:45)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.Util.getInstance(Util.java:381)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3536)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3468)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1957)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2107)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2648)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2086)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2371)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2289)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2274)
at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551)
... 21 more
### EXCEPTION ###########################################
11:20:18,248 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 2088478793 -----------------------------------------------------
=== Problem description =========================
ProcessDefinitation deployment and Process instance are working fine. The problem is in deleting the deployed ProcessDefinitation.
repositoryService.deleteDeploymentCascade(deploymentId) Exception :) [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`jbpmdb`.`jbpm4_execution`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `jbpm4_execution` (`DBID_`))
--------------------------------------------------------------
Comment by going to Community
[http://community.jboss.org/docs/DOC-15927]
Create a new document in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=102&co...]
13 years, 6 months
- 1
- 0
[jBPM Development] - 1.Reporting problem while deleting the ProcessDefinitation
by sreeni Karnati
sreeni Karnati [http://community.jboss.org/people/sreeni.karnati] created the document:
"1.Reporting problem while deleting the ProcessDefinitation "
To view the document, visit: http://community.jboss.org/docs/DOC-15926
Comment by going to Community
[http://community.jboss.org/docs/DOC-15926]
Create a new document in jBPM Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=102&co...]
13 years, 6 months
- 1
- 0
[Clustering Development] - java.net.SocketException with Jboss cluster
by Gourav Chouhan
Gourav Chouhan [http://community.jboss.org/people/gourav1688] created the discussion
"java.net.SocketException with Jboss cluster"
To view the discussion, visit: http://community.jboss.org/message/564466#564466
--------------------------------------------------------------
Hi friends,
When i am making cluster with only two node it is showing this exception
2010-09-27 12:26:40,750 ERROR [org.jgroups.blocks.ConnectionTable] (ReceiverThread) exception is http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/net/S... java.net.SocketException: Connection reset by peer: socket write error
2010-09-27 12:26:40,750 ERROR [org.jgroups.blocks.ConnectionTable] (ReceiverThread) failed sending data to 172.16.12.78:7900: http://download.oracle.com/docs/cd/E17409_01/javase/6/docs/api/java/net/S... java.net.SocketException: Connection reset by peer: socket write error
2010-09-27 12:27:25,500 ERROR [org.jgroups.protocols.pbcast.NAKACK] (Incoming-2,172.16.10.202:7900) sender 172.16.12.78:7900 not found in xmit_table
2010-09-27 12:27:25,500 ERROR [org.jgroups.protocols.pbcast.NAKACK] (Incoming-2,172.16.10.202:7900) range is null
i m using http://www.coderanch.com/forums/f-63/JBoss jboss 5.1.0 my machine is windows
please help me to find out the problem
--------------------------------------------------------------
Reply to this message by going to Community
[http://community.jboss.org/message/564466#564466]
Start a new discussion in Clustering Development at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&cont...]
13 years, 6 months
- 1
- 0