寫jbpm4.4執行完成最后一個任務遇到如下問題。

2019-11-10 18:04:30

字體：大中小

來源：轉載

供稿：網友

10:24:52,184 FIN | [WireContext] eagerly initializing org.jbpm.pvm.internal.id.DatabaseIdComposer10:24:52,197 INF | [Environment] Hibernate 3.3.1.GA10:24:52,200 INF | [Environment] hibernate.PRoperties not found10:24:52,203 INF | [Environment] Bytecode provider name : javassist10:24:52,206 INF | [Environment] using JDK 1.4 java.sql.Timestamp handling10:24:52,248 INF | [Configuration] configuring from resource: jbpm.hibernate.cfg.xml10:24:52,248 INF | [Configuration] Configuration resource: jbpm.hibernate.cfg.xml10:24:52,304 INF | [Configuration] Reading mappings from resource : jbpm.repository.hbm.xml10:24:52,469 INF | [Configuration] Reading mappings from resource : jbpm.execution.hbm.xml10:24:52,553 INF | [Configuration] Reading mappings from resource : jbpm.history.hbm.xml10:24:52,599 INF | [Configuration] Reading mappings from resource : jbpm.task.hbm.xml10:24:52,617 INF | [Configuration] Reading mappings from resource : jbpm.identity.hbm.xml10:24:52,634 INF | [Configuration] Configured sessionFactory: null10:24:52,649 INF | [DriverManagerConnectionProvider] Using Hibernate built-in connection pool (not for production use!)10:24:52,649 INF | [DriverManagerConnectionProvider] Hibernate connection pool size: 2010:24:52,650 INF | [DriverManagerConnectionProvider] autocommit mode: false10:24:52,658 INF | [DriverManagerConnectionProvider] using driver: com.MySQL.jdbc.Driver at URL: jdbc:mysql://192.168.11.36:3306/test?useUnicode=true&characterEncoding=UTF-810:24:52,658 INF | [DriverManagerConnectionProvider] connection properties: {user=root, passWord=****}10:25:02,903 INF | [Dialect] Using dialect: org.hibernate.dialect.MySQLDialect10:25:02,906 INF | [TransactionFactoryFactory] Using default transaction strategy (direct JDBC transactions)10:25:02,907 INF | [TransactionManagerLookupFactory] No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)10:25:02,909 INF | [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory10:25:02,957 INF | [SessionFactoryImpl] building session factory10:25:03,365 INF | [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured10:25:03,370 INF | [SchemaUpdate] Running hbm2ddl schema update10:25:03,370 INF | [SchemaUpdate] fetching database metadata10:25:03,372 INF | [SchemaUpdate] updating schema10:25:03,391 INF | [TableMetadata] table found: test.JBPM4_DEPLOYMENT10:25:03,391 INF | [TableMetadata] columns: [timestamp_, state_, dbid_, name_]10:25:03,392 INF | [TableMetadata] foreign keys: []10:25:03,392 INF | [TableMetadata] indexes: [primary]10:25:03,401 INF | [TableMetadata] table found: test.JBPM4_DEPLOYPROP10:25:03,401 INF | [TableMetadata] columns: [longval_, key_, stringval_, deployment_, dbid_, objname_]10:25:03,402 INF | [TableMetadata] foreign keys: [fk_deplprop_depl]10:25:03,402 INF | [TableMetadata] indexes: [fk_deplprop_depl, primary]10:25:03,412 INF | [TableMetadata] table found: test.JBPM4_EXECUTION10:25:03,413 INF | [TableMetadata] columns: [susphiststate_, state_, parent_, id_, subprocinst_, class_, dbid_, parent_idx_, activityname_, name_, instance_, key_, dbversion_, hisactinst_, hasvars_, priority_, superexec_, procdefid_]10:25:03,413 INF | [TableMetadata] foreign keys: [fk_exec_subpi, fk_exec_parent, fk_exec_instance, fk_exec_superexec]10:25:03,413 INF | [TableMetadata] indexes: [fk_exec_subpi, id_, fk_exec_parent, fk_exec_instance, primary, fk_exec_superexec]10:25:03,422 INF | [TableMetadata] table found: test.JBPM4_HIST_ACTINST10:25:03,423 INF | [TableMetadata] columns: [nextidx_, class_, dbid_, end_, duration_, execution_, start_, dbversion_, hproci_, transition_, htask_, activity_name_, type_]10:25:03,423 INF | [TableMetadata] foreign keys: [fk_hacti_hproci, fk_hti_htask]10:25:03,423 INF | [TableMetadata] indexes: [fk_hacti_hproci, fk_hti_htask, primary]10:25:03,443 INF | [TableMetadata] table found: test.JBPM4_HIST_DETAIL10:25:03,444 INF | [TableMetadata] columns: [userid_, parent_, hprociidx_, time_, new_time_, class_, dbid_, parent_idx_, htaskidx_, message_, hvar_, old_time_, hactiidx_, dbversion_, hproci_, new_str_, hvaridx_, htask_, old_int_, new_int_, hacti_, old_str_]10:25:03,444 INF | [TableMetadata] foreign keys: [fk_hdetail_htask, fk_hdetail_hproci, fk_hdetail_hvar, fk_hdetail_hacti]10:25:03,444 INF | [TableMetadata] indexes: [fk_hdetail_htask, fk_hdetail_hproci, fk_hdetail_hvar, primary, fk_hdetail_hacti]10:25:03,451 INF | [TableMetadata] table found: test.JBPM4_HIST_PROCINST10:25:03,451 INF | [TableMetadata] columns: [start_, key_, state_, dbversion_, id_, nextidx_, endactivity_, dbid_, end_, duration_, procdefid_]10:25:03,452 INF | [TableMetadata] foreign keys: []10:25:03,452 INF | [TableMetadata] indexes: [primary]10:25:03,460 INF | [TableMetadata] table found: test.JBPM4_HIST_TASK10:25:03,461 INF | [TableMetadata] columns: [state_, dbversion_, nextidx_, dbid_, outcome_, supertask_, end_, assignee_, priority_, create_, duration_, execution_]10:25:03,461 INF | [TableMetadata] foreign keys: [fk_hsupert_sub]10:25:03,461 INF | [TableMetadata] indexes: [fk_hsupert_sub, primary]10:25:03,472 INF | [TableMetadata] table found: test.JBPM4_HIST_VAR10:25:03,472 INF | [TableMetadata] columns: [dbversion_, hproci_, varname_, dbid_, procinstid_, htask_, value_, executionid_]10:25:03,473 INF | [TableMetadata] foreign keys: [fk_hvar_hproci, fk_hvar_htask]10:25:03,473 INF | [TableMetadata] indexes: [fk_hvar_hproci, primary, fk_hvar_htask]10:25:03,482 INF | [TableMetadata] table found: test.JBPM4_ID_GROUP10:25:03,482 INF | [TableMetadata] columns: [parent_, dbversion_, id_, dbid_, type_, name_]10:25:03,483 INF | [TableMetadata] foreign keys: [fk_group_parent]10:25:03,483 INF | [TableMetadata] indexes: [fk_group_parent, primary]10:25:03,496 INF | [TableMetadata] table found: test.JBPM4_ID_MEMBERSHip10:25:03,496 INF | [TableMetadata] columns: [user_, dbversion_, dbid_, group_, name_]10:25:03,496 INF | [TableMetadata] foreign keys: [fk_mem_user, fk_mem_group]10:25:03,496 INF | [TableMetadata] indexes: [fk_mem_user, fk_mem_group, primary]10:25:03,502 INF | [TableMetadata] table found: test.JBPM4_ID_USER10:25:03,503 INF | [TableMetadata] columns: [dbversion_, id_, givenname_, familyname_, dbid_, password_, businessemail_]10:25:03,503 INF | [TableMetadata] foreign keys: []10:25:03,503 INF | [TableMetadata] indexes: [primary]10:25:03,511 INF | [TableMetadata] table found: test.JBPM4_JOB10:25:03,511 INF | [TableMetadata] columns: [isexclusive_, event_, state_, class_, dbid_, duedate_, execution_, signal_, lockexptime_, processinstance_, dbversion_, cfg_, lockowner_, exception_, retries_, repeat_]10:25:03,512 INF | [TableMetadata] foreign keys: [fk_job_cfg]10:25:03,512 INF | [TableMetadata] indexes: [fk_job_cfg, primary]10:25:03,520 INF | [TableMetadata] table found: test.JBPM4_LOB10:25:03,520 INF | [TableMetadata] columns: [dbversion_, deployment_, dbid_, blob_value_, name_]10:25:03,520 INF | [TableMetadata] foreign keys: [fk_lob_deployment]10:25:03,520 INF | [TableMetadata] indexes: [fk_lob_deployment, primary]10:25:03,531 INF | [TableMetadata] table found: test.JBPM4_PARTICIPATION10:25:03,532 INF | [TableMetadata] columns: [userid_, dbversion_, dbid_, task_, groupid_, swimlane_, type_]10:25:03,532 INF | [TableMetadata] foreign keys: [fk_part_swimlane, fk_part_task]10:25:03,532 INF | [TableMetadata] indexes: [fk_part_swimlane, fk_part_task, primary]10:25:03,544 INF | [TableMetadata] table found: test.JBPM4_PROPERTY10:25:03,544 INF | [TableMetadata] columns: [key_, version_, value_]10:25:03,545 INF | [TableMetadata] foreign keys: []10:25:03,545 INF | [TableMetadata] indexes: [primary]10:25:03,553 INF | [TableMetadata] table found: test.JBPM4_SWIMLANE10:25:03,554 INF | [TableMetadata] columns: [dbversion_, dbid_, assignee_, name_, execution_]10:25:03,554 INF | [TableMetadata] foreign keys: [fk_swimlane_exec]10:25:03,554 INF | [TableMetadata] indexes: [fk_swimlane_exec, primary]10:25:03,567 INF | [TableMetadata] table found: test.JBPM4_TASK10:25:03,567 INF | [TableMetadata] columns: [susphiststate_, state_, execution_id_, taskdefname_, class_, dbid_, supertask_, form_, duedate_, create_, name_, execution_, progress_, signalling_, dbversion_, procinst_, descr_, hasvars_, activity_name_, swimlane_, assignee_, priority_]10:25:03,568 INF | [TableMetadata] foreign keys: [fk_task_supertask, fk_task_swiml]10:25:03,568 INF | [TableMetadata] indexes: [fk_task_supertask, fk_task_swiml, primary]10:25:03,577 INF | [TableMetadata] table found: test.JBPM4_VARIABLE10:25:03,578 INF | [TableMetadata] columns: [classname_, exesys_, date_value_, class_, dbid_, task_, text_value_, execution_, key_, lob_, dbversion_, string_value_, converter_, hist_, long_value_, double_value_]10:25:03,578 INF | [TableMetadata] foreign keys: [fk_var_task, fk_var_execution, fk_var_exesys, fk_var_lob]10:25:03,578 INF | [TableMetadata] indexes: [fk_var_task, fk_var_execution, fk_var_lob, fk_var_exesys, primary]10:25:03,579 INF | [SchemaUpdate] schema update complete10:25:03,769 FIN | [HibernateSessionResource] ----- beginning hibernate tx 403174823 --------------------------------------------------------10:25:03,778 FIN | [SQL] select propertyim0_.KEY_ as KEY1_2_, propertyim0_.VERSION_ as VERSION2_2_, propertyim0_.VALUE_ as VALUE3_2_ from JBPM4_PROPERTY propertyim0_ limit ?10:25:03,786 FST | [StringType] returning 'next.dbid' as column: KEY1_2_10:25:03,792 FST | [IntegerType] returning '3' as column: VERSION2_2_10:25:03,792 FST | [StringType] returning '30001' as column: VALUE3_2_10:25:03,798 FIN | [SQL] select propertyim0_.KEY_ as KEY1_2_0_, propertyim0_.VERSION_ as VERSION2_2_0_, propertyim0_.VALUE_ as VALUE3_2_0_ from JBPM4_PROPERTY propertyim0_ where propertyim0_.KEY_=?10:25:03,798 FST | [StringType] binding 'db.version' to parameter: 110:25:03,800 INF | [CheckDbCmd] jBPM version info: library[4.4-SNAPSHOT], schema[null]10:25:03,803 FIN | [HibernateSessionResource] ----- committing hibernate tx 795321555 -------------------------------------------------------10:25:03,807 FIN | [HibernateSessionResource] ----- beginning hibernate tx 1330247343 --------------------------------------------------------10:25:03,808 FIN | [SQL] select taskimpl0_.DBID_ as DBID1_12_0_, taskimpl0_.DBVERSION_ as DBVERSION3_12_0_, taskimpl0_.NAME_ as NAME4_12_0_, taskimpl0_.DESCR_ as DESCR5_12_0_, taskimpl0_.STATE_ as STATE6_12_0_, taskimpl0_.SUSPHISTSTATE_ as SUSPHIST7_12_0_, taskimpl0_.ASSIGNEE_ as ASSIGNEE8_12_0_, taskimpl0_.FORM_ as FORM9_12_0_, taskimpl0_.PRIORITY_ as PRIORITY10_12_0_, taskimpl0_.CREATE_ as CREATE11_12_0_, taskimpl0_.DUEDATE_ as DUEDATE12_12_0_, taskimpl0_.PROGRESS_ as PROGRESS13_12_0_, taskimpl0_.SIGNALLING_ as SIGNALLING14_12_0_, taskimpl0_.EXECUTION_ID_ as EXECUTION15_12_0_, taskimpl0_.ACTIVITY_NAME_ as ACTIVITY16_12_0_, taskimpl0_.HASVARS_ as HASVARS17_12_0_, taskimpl0_.SUPERTASK_ as SUPERTASK18_12_0_, taskimpl0_.EXECUTION_ as EXECUTION19_12_0_, taskimpl0_.PROCINST_ as PROCINST20_12_0_, taskimpl0_.SWIMLANE_ as SWIMLANE21_12_0_, taskimpl0_.TASKDEFNAME_ as TASKDEF22_12_0_ from JBPM4_TASK taskimpl0_ where taskimpl0_.DBID_=?10:25:03,808 FST | [LongType] binding '20001' to parameter: 110:25:03,811 FST | [IntegerType] returning '1' as column: DBVERSION3_12_0_10:25:03,811 FST | [StringType] returning '校長審批' as column: NAME4_12_0_10:25:03,811 FST | [TextType] returning null as column: DESCR5_12_0_10:25:03,811 FST | [StringType] returning 'open' as column: STATE6_12_0_10:25:03,812 FST | [StringType] returning null as column: SUSPHIST7_12_0_10:25:03,812 FST | [StringType] returning '李四' as column: ASSIGNEE8_12_0_10:25:03,812 FST | [StringType] returning null as column: FORM9_12_0_10:25:03,812 FST | [IntegerType] returning '0' as column: PRIORITY10_12_0_10:25:03,816 FST | [TimestampType] returning '2017-02-09 10:23:11' as column: CREATE11_12_0_10:25:03,816 FST | [TimestampType] returning null as column: DUEDATE12_12_0_10:25:03,816 FST | [IntegerType] returning null as column: PROGRESS13_12_0_10:25:03,817 FST | [BooleanType] returning 'true' as column: SIGNALLING14_12_0_10:25:03,817 FST | [StringType] returning 'test.10001' as column: EXECUTION15_12_0_10:25:03,817 FST | [StringType] returning '校長審批' as column: ACTIVITY16_12_0_10:25:03,817 FST | [BooleanType] returning 'false' as column: HASVARS17_12_0_10:25:03,817 FST | [LongType] returning null as column: SUPERTASK18_12_0_10:25:03,818 FST | [LongType] returning '10001' as column: EXECUTION19_12_0_10:25:03,818 FST | [LongType] returning '10001' as column: PROCINST20_12_0_10:25:03,818 FST | [LongType] returning null as column: SWIMLANE21_12_0_10:25:03,818 FST | [StringType] returning '校長審批' as column: TASKDEF22_12_0_10:25:03,826 FIN | [SQL] select executioni0_.DBID_ as DBID1_3_0_, executioni0_.DBVERSION_ as DBVERSION3_3_0_, executioni0_.ACTIVITYNAME_ as ACTIVITY4_3_0_, executioni0_.PROCDEFID_ as PROCDEFID5_3_0_, executioni0_.HASVARS_ as HASVARS6_3_0_, executioni0_.NAME_ as NAME7_3_0_, executioni0_.KEY_ as KEY8_3_0_, executioni0_.ID_ as ID9_3_0_, executioni0_.STATE_ as STATE10_3_0_, executioni0_.SUSPHISTSTATE_ as SUSPHIS11_3_0_, executioni0_.PRIORITY_ as PRIORITY12_3_0_, executioni0_.HISACTINST_ as HISACTINST13_3_0_, executioni0_.PARENT_ as PARENT14_3_0_, executioni0_.INSTANCE_ as INSTANCE15_3_0_, executioni0_.SUPEREXEC_ as SUPEREXEC16_3_0_, executioni0_.SUBPROCINST_ as SUBPROC17_3_0_ from JBPM4_EXECUTION executioni0_ where executioni0_.DBID_=?10:25:03,827 FST | [LongType] binding '10001' to parameter: 110:25:03,829 FST | [IntegerType] returning '2' as column: DBVERSION3_3_0_10:25:03,829 FST | [StringType] returning '校長審批' as column: ACTIVITY4_3_0_10:25:03,829 FST | [StringType] returning 'test-1' as column: PROCDEFID5_3_0_10:25:03,829 FST | [BooleanType] returning 'false' as column: HASVARS6_3_0_10:25:03,829 FST | [StringType] returning null as column: NAME7_3_0_10:25:03,830 FST | [StringType] returning null as column: KEY8_3_0_10:25:03,830 FST | [StringType] returning 'test.10001' as column: ID9_3_0_10:25:03,830 FST | [StringType] returning 'active-root' as column: STATE10_3_0_10:25:03,830 FST | [StringType] returning null as column: SUSPHIS11_3_0_10:25:03,830 FST | [IntegerType] returning '0' as column: PRIORITY12_3_0_10:25:03,830 FST | [LongType] returning '20002' as column: HISACTINST13_3_0_10:25:03,830 FST | [LongType] returning null as column: PARENT14_3_0_10:25:03,831 FST | [LongType] returning '10001' as column: INSTANCE15_3_0_10:25:03,831 FST | [LongType] returning null as column: SUPEREXEC16_3_0_10:25:03,831 FST | [LongType] returning null as column: SUBPROC17_3_0_10:25:03,834 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_=?10:25:03,834 FST | [LongType] binding '10001' to parameter: 110:25:03,839 FIN | [SQL] select historytas0_.DBID_ as DBID1_8_0_, historytas0_.DBVERSION_ as DBVERSION3_8_0_, historytas0_.HPROCI_ as HPROCI4_8_0_, historytas0_.TYPE_ as TYPE5_8_0_, historytas0_.EXECUTION_ as EXECUTION6_8_0_, historytas0_.ACTIVITY_NAME_ as ACTIVITY7_8_0_, historytas0_.START_ as START8_8_0_, historytas0_.END_ as END9_8_0_, historytas0_.DURATION_ as DURATION10_8_0_, historytas0_.TRANSITION_ as TRANSITION11_8_0_, historytas0_.NEXTIDX_ as NEXTIDX12_8_0_, historytas0_.HTASK_ as HTASK13_8_0_ from JBPM4_HIST_ACTINST historytas0_ where historytas0_.DBID_=? and historytas0_.CLASS_='task'10:25:03,839 FST | [LongType] binding '20002' to parameter: 110:25:03,842 FST | [IntegerType] returning '0' as column: DBVERSION3_8_0_10:25:03,842 FST | [LongType] returning '10001' as column: HPROCI4_8_0_10:25:03,843 FST | [StringType] returning 'task' as column: TYPE5_8_0_10:25:03,843 FST | [StringType] returning 'test.10001' as column: EXECUTION6_8_0_10:25:03,843 FST | [StringType] returning '校長審批' as column: ACTIVITY7_8_0_10:25:03,843 FST | [TimestampType] returning '2017-02-09 10:23:01' as column: START8_8_0_10:25:03,844 FST | [TimestampType] returning null as column: END9_8_0_10:25:03,844 FST | [LongType] returning '0' as column: DURATION10_8_0_10:25:03,844 FST | [StringType] returning null as column: TRANSITION11_8_0_10:25:03,844 FST | [IntegerType] returning '1' as column: NEXTIDX12_8_0_10:25:03,844 FST | [LongType] returning '20001' as column: HTASK13_8_0_10:25:03,845 FIN | [SQL] select historytas0_.DBID_ as DBID1_9_0_, historytas0_.DBVERSION_ as DBVERSION2_9_0_, historytas0_.EXECUTION_ as EXECUTION3_9_0_, historytas0_.OUTCOME_ as OUTCOME4_9_0_, historytas0_.ASSIGNEE_ as ASSIGNEE5_9_0_, historytas0_.PRIORITY_ as PRIORITY6_9_0_, historytas0_.STATE_ as STATE7_9_0_, historytas0_.CREATE_ as CREATE8_9_0_, historytas0_.END_ as END9_9_0_, historytas0_.DURATION_ as DURATION10_9_0_, historytas0_.NEXTIDX_ as NEXTIDX11_9_0_ from JBPM4_HIST_TASK historytas0_ where historytas0_.DBID_=?10:25:03,846 FST | [LongType] binding '20001' to parameter: 110:25:03,848 FST | [IntegerType] returning '0' as column: DBVERSION2_9_0_10:25:03,848 FST | [StringType] returning 'test.10001' as column: EXECUTION3_9_0_10:25:03,848 FST | [StringType] returning null as column: OUTCOME4_9_0_10:25:03,848 FST | [StringType] returning '李四' as column: ASSIGNEE5_9_0_10:25:03,848 FST | [IntegerType] returning '0' as column: PRIORITY6_9_0_10:25:03,849 FST | [StringType] returning null as column: STATE7_9_0_10:25:03,849 FST | [TimestampType] returning '2017-02-09 10:23:11' as column: CREATE8_9_0_10:25:03,849 FST | [TimestampType] returning null as column: END9_9_0_10:25:03,849 FST | [LongType] returning '0' as column: DURATION10_9_0_10:25:03,849 FST | [IntegerType] returning '1' as column: NEXTIDX11_9_0_10:25:03,853 FIN | [SQL] select participat0_.TASK_ as TASK6_1_, participat0_.DBID_ as DBID1_1_, participat0_.DBID_ as DBID1_13_0_, participat0_.DBVERSION_ as DBVERSION2_13_0_, participat0_.GROUPID_ as GROUPID3_13_0_, participat0_.USERID_ as USERID4_13_0_, participat0_.TYPE_ as TYPE5_13_0_, participat0_.TASK_ as TASK6_13_0_, participat0_.SWIMLANE_ as SWIMLANE7_13_0_ from JBPM4_PARTICIPATION participat0_ where participat0_.TASK_=?10:25:03,853 FST | [LongType] binding '20001' to parameter: 110:25:03,856 FIN | [SQL] select variables0_.TASK_ as TASK8_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_.TASK_=?10:25:03,856 FST | [LongType] binding '20001' to parameter: 110:25:03,859 FIN | [SQL] select subtasks0_.SUPERTASK_ as SUPERTASK18_1_, subtasks0_.DBID_ as DBID1_1_, subtasks0_.DBID_ as DBID1_12_0_, subtasks0_.DBVERSION_ as DBVERSION3_12_0_, subtasks0_.NAME_ as NAME4_12_0_, subtasks0_.DESCR_ as DESCR5_12_0_, subtasks0_.STATE_ as STATE6_12_0_, subtasks0_.SUSPHISTSTATE_ as SUSPHIST7_12_0_, subtasks0_.ASSIGNEE_ as ASSIGNEE8_12_0_, subtasks0_.FORM_ as FORM9_12_0_, subtasks0_.PRIORITY_ as PRIORITY10_12_0_, subtasks0_.CREATE_ as CREATE11_12_0_, subtasks0_.DUEDATE_ as DUEDATE12_12_0_, subtasks0_.PROGRESS_ as PROGRESS13_12_0_, subtasks0_.SIGNALLING_ as SIGNALLING14_12_0_, subtasks0_.EXECUTION_ID_ as EXECUTION15_12_0_, subtasks0_.ACTIVITY_NAME_ as ACTIVITY16_12_0_, subtasks0_.HASVARS_ as HASVARS17_12_0_, subtasks0_.SUPERTASK_ as SUPERTASK18_12_0_, subtasks0_.EXECUTION_ as EXECUTION19_12_0_, subtasks0_.PROCINST_ as PROCINST20_12_0_, subtasks0_.SWIMLANE_ as SWIMLANE21_12_0_, subtasks0_.TASKDEFNAME_ as TASKDEF22_12_0_ from JBPM4_TASK subtasks0_ where subtasks0_.SUPERTASK_=?10:25:03,860 FST | [LongType] binding '20001' to parameter: 110:25:03,894 INF | [Parser] loading schema resource: jpdl-4.0.xsd10:25:03,894 INF | [Parser] loading schema resource: jpdl-4.2.xsd10:25:03,894 INF | [Parser] loading schema resource: jpdl-4.3.xsd10:25:03,894 INF | [Parser] loading schema resource: jpdl-4.4.xsd10:25:03,915 INF | [Parser] loading schema resource: BPMN20.xsd10:25:03,915 INF | [Parser] loading schema resource: DiagramDefinition.xsd10:25:03,915 INF | [Parser] loading schema resource: DiagramInterchange.xsd10:25:03,915 INF | [Parser] loading schema resource: BpmnDi.xsd10:25:03,929 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_='test-1' limit ?10:25:03,931 FST | [LongType] returning '4' as column: DBID1_1_10:25:03,931 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_10:25:03,931 FST | [StringType] returning 'test' as column: OBJNAME3_1_10:25:03,932 FST | [StringType] returning 'pdid' as column: KEY4_1_10:25:03,932 FST | [StringType] returning 'test-1' as column: STRINGVAL5_1_10:25:03,932 FST | [LongType] returning null as column: LONGVAL6_1_10:25:03,933 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_=?10:25:03,934 FST | [LongType] binding '1' to parameter: 110:25:03,935 FST | [TextType] returning null as column: NAME2_0_0_10:25:03,936 FST | [LongType] returning '0' as column: TIMESTAMP3_0_0_10:25:03,936 FST | [StringType] returning 'active' as column: STATE4_0_0_10:25:03,937 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_=?10:25:03,938 FST | [LongType] binding '1' to parameter: 110:25:03,940 FST | [LongType] returning '2' as column: DBID1_5_0_10:25:03,940 FST | [IntegerType] returning '0' as column: DBVERSION2_5_0_10:25:03,942 FST | [LongType] returning '1' as column: DEPLOYMENT4_1_10:25:03,943 FST | [LongType] returning '2' as column: DBID1_1_10:25:03,943 FST | [TextType] returning 'test.jpdl.xml' as column: NAME5_1_10:25:04,093 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_=?10:25:04,094 FST | [LongType] binding '1' to parameter: 110:25:04,096 FST | [LongType] returning '3' as column: DBID1_1_0_10:25:04,097 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_0_10:25:04,097 FST | [StringType] returning 'test' as column: OBJNAME3_1_0_10:25:04,097 FST | [StringType] returning 'langid' as column: KEY4_1_0_10:25:04,097 FST | [StringType] returning 'jpdl-4.4' as column: STRINGVAL5_1_0_10:25:04,098 FST | [LongType] returning null as column: LONGVAL6_1_0_10:25:04,098 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_10:25:04,098 FST | [LongType] returning '3' as column: DBID1_1_10:25:04,098 FST | [LongType] returning '4' as column: DBID1_1_0_10:25:04,099 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_10:25:04,099 FST | [LongType] returning '4' as column: DBID1_1_10:25:04,099 FST | [LongType] returning '5' as column: DBID1_1_0_10:25:04,100 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_0_10:25:04,100 FST | [StringType] returning 'test' as column: OBJNAME3_1_0_10:25:04,100 FST | [StringType] returning 'pdkey' as column: KEY4_1_0_10:25:04,100 FST | [StringType] returning 'test' as column: STRINGVAL5_1_0_10:25:04,100 FST | [LongType] returning null as column: LONGVAL6_1_0_10:25:04,101 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_10:25:04,101 FST | [LongType] returning '5' as column: DBID1_1_10:25:04,101 FST | [LongType] returning '6' as column: DBID1_1_0_10:25:04,102 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_0_10:25:04,102 FST | [StringType] returning 'test' as column: OBJNAME3_1_0_10:25:04,102 FST | [StringType] returning 'pdversion' as column: KEY4_1_0_10:25:04,102 FST | [StringType] returning null as column: STRINGVAL5_1_0_10:25:04,103 FST | [LongType] returning '1' as column: LONGVAL6_1_0_10:25:04,103 FST | [LongType] returning '1' as column: DEPLOYMENT2_1_10:25:04,103 FST | [LongType] returning '6' as column: DBID1_1_10:25:04,117 FIN | [Signal] signalling activity(校長審批), signalName=jbpm_no_task_outcome_specified_jbpm10:25:04,131 FIN | [SQL] update JBPM4_HIST_ACTINST set DBVERSION_=?, HPROCI_=?, TYPE_=?, EXECUTION_=?, ACTIVITY_NAME_=?, START_=?, END_=?, DURATION_=?, TRANSITION_=?, NEXTIDX_=?, HTASK_=? where DBID_=? and DBVERSION_=?10:25:04,131 FST | [IntegerType] binding '1' to parameter: 110:25:04,131 FST | [LongType] binding '10001' to parameter: 210:25:04,132 FST | [StringType] binding 'task' to parameter: 310:25:04,132 FST | [StringType] binding 'test.10001' to parameter: 410:25:04,132 FST | [StringType] binding '校長審批' to parameter: 510:25:04,133 FST | [TimestampType] binding '2017-02-09 10:23:01' to parameter: 610:25:04,134 FST | [TimestampType] binding '2017-02-09 10:25:03' to parameter: 710:25:04,134 FST | [LongType] binding '122838' to parameter: 810:25:04,135 FST | [StringType] binding 'jbpm_no_task_outcome_specified_jbpm' to parameter: 910:25:04,135 FST | [IntegerType] binding '1' to parameter: 1010:25:04,135 FST | [LongType] binding '20001' to parameter: 1110:25:04,135 FST | [LongType] binding '20002' to parameter: 1210:25:04,136 FST | [IntegerType] binding '0' to parameter: 1310:25:04,138 FIN | [SQL] update JBPM4_HIST_TASK set DBVERSION_=?, EXECUTION_=?, OUTCOME_=?, ASSIGNEE_=?, PRIORITY_=?, STATE_=?, CREATE_=?, END_=?, DURATION_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?10:25:04,138 FST | [IntegerType] binding '1' to parameter: 110:25:04,139 FST | [StringType] binding 'test.10001' to parameter: 210:25:04,139 FST | [StringType] binding 'jbpm_no_task_outcome_specified_jbpm' to parameter: 310:25:04,139 FST | [StringType] binding '李四' to parameter: 410:25:04,139 FST | [IntegerType] binding '0' to parameter: 510:25:04,140 FST | [StringType] binding 'completed' to parameter: 610:25:04,140 FST | [TimestampType] binding '2017-02-09 10:23:11' to parameter: 710:25:04,140 FST | [TimestampType] binding '2017-02-09 10:25:03' to parameter: 810:25:04,140 FST | [LongType] binding '112850' to parameter: 910:25:04,141 FST | [IntegerType] binding '1' to parameter: 1010:25:04,141 FST | [LongType] binding '20001' to parameter: 1110:25:04,141 FST | [IntegerType] binding '0' to parameter: 1210:25:04,143 FIN | [SQL] delete from JBPM4_TASK where DBID_=? and DBVERSION_=?10:25:04,143 FST | [LongType] binding '20001' to parameter: 110:25:04,143 FST | [IntegerType] binding '1' to parameter: 210:25:04,147 FIN | [SQL] select this_.DBID_ as DBID1_12_0_, this_.DBVERSION_ as DBVERSION3_12_0_, this_.NAME_ as NAME4_12_0_, this_.DESCR_ as DESCR5_12_0_, this_.STATE_ as STATE6_12_0_, this_.SUSPHISTSTATE_ as SUSPHIST7_12_0_, this_.ASSIGNEE_ as ASSIGNEE8_12_0_, this_.FORM_ as FORM9_12_0_, this_.PRIORITY_ as PRIORITY10_12_0_, this_.CREATE_ as CREATE11_12_0_, this_.DUEDATE_ as DUEDATE12_12_0_, this_.PROGRESS_ as PROGRESS13_12_0_, this_.SIGNALLING_ as SIGNALLING14_12_0_, this_.EXECUTION_ID_ as EXECUTION15_12_0_, this_.ACTIVITY_NAME_ as ACTIVITY16_12_0_, this_.HASVARS_ as HASVARS17_12_0_, this_.SUPERTASK_ as SUPERTASK18_12_0_, this_.EXECUTION_ as EXECUTION19_12_0_, this_.PROCINST_ as PROCINST20_12_0_, this_.SWIMLANE_ as SWIMLANE21_12_0_, this_.TASKDEFNAME_ as TASKDEF22_12_0_ from JBPM4_TASK this_ where this_.EXECUTION_=?10:25:04,147 FST | [LongType] binding '10001' to parameter: 110:25:04,149 FIN | [ExecuteActivity] executing activity(end1)10:25:04,150 FIN | [ExecutionImpl] execution[test.10001] ends with state ended10:25:04,151 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_=?10:25:04,151 FST | [LongType] binding '10001' to parameter: 110:25:04,153 FST | [IntegerType] returning '0' as column: DBVERSION2_7_0_10:25:04,153 FST | [StringType] returning 'test.10001' as column: ID3_7_0_10:25:04,154 FST | [StringType] returning 'test-1' as column: PROCDEFID4_7_0_10:25:04,154 FST | [StringType] returning null as column: KEY5_7_0_10:25:04,154 FST | [TimestampType] returning '2017-02-09 10:21:20' as column: START6_7_0_10:25:04,154 FST | [TimestampType] returning null as column: END7_7_0_10:25:04,155 FST | [LongType] returning null as column: DURATION8_7_0_10:25:04,155 FST | [StringType] returning 'active' as column: STATE9_7_0_10:25:04,155 FST | [StringType] returning null as column: ENDACTI10_7_0_10:25:04,155 FST | [IntegerType] returning '1' as column: NEXTIDX11_7_0_10:25:04,158 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_=?10:25:04,158 FST | [IntegerType] binding '3' to parameter: 110:25:04,158 FST | [StringType] binding 'end1' to parameter: 210:25:04,159 FST | [StringType] binding 'test-1' to parameter: 310:25:04,159 FST | [BooleanType] binding 'false' to parameter: 410:25:04,159 FST | [StringType] binding null to parameter: 510:25:04,159 FST | [StringType] binding null to parameter: 610:25:04,159 FST | [StringType] binding 'test.10001' to parameter: 710:25:04,160 FST | [StringType] binding 'ended' to parameter: 810:25:04,160 FST | [StringType] binding null to parameter: 910:25:04,160 FST | [IntegerType] binding '0' to parameter: 1010:25:04,160 FST | [LongType] binding '20002' to parameter: 1110:25:04,160 FST | [LongType] binding null to parameter: 1210:25:04,160 FST | [LongType] binding '10001' to parameter: 1310:25:04,161 FST | [LongType] binding null to parameter: 1410:25:04,161 FST | [LongType] binding null to parameter: 1510:25:04,161 FST | [LongType] binding '10001' to parameter: 1610:25:04,161 FST | [IntegerType] binding '2' to parameter: 1710:25:04,484 FIN | [SQL] update JBPM4_HIST_PROCINST set DBVERSION_=?, ID_=?, PROCDEFID_=?, KEY_=?, START_=?, END_=?, DURATION_=?, STATE_=?, ENDACTIVITY_=?, NEXTIDX_=? where DBID_=? and DBVERSION_=?10:25:04,485 FST | [IntegerType] binding '1' to parameter: 110:25:04,485 FST | [StringType] binding 'test.10001' to parameter: 210:25:04,485 FST | [StringType] binding 'test-1' to parameter: 310:25:04,487 FST | [StringType] binding null to parameter: 410:25:04,488 FST | [TimestampType] binding '2017-02-09 10:21:20' to parameter: 510:25:04,490 FST | [TimestampType] binding '2017-02-09 10:25:04' to parameter: 610:25:04,491 FST | [LongType] binding '224150' to parameter: 710:25:04,491 FST | [StringType] binding 'ended' to parameter: 810:25:04,491 FST | [StringType] binding 'end1' to parameter: 910:25:04,492 FST | [IntegerType] binding '1' to parameter: 1010:25:04,492 FST | [LongType] binding '10001' to parameter: 1110:25:04,492 FST | [IntegerType] binding '0' to parameter: 1210:25:04,495 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 ?10:25:04,496 FST | [StringType] binding 'test.10001' to parameter: 110:25:04,499 FST | [LongType] returning '10001' as column: DBID1_3_10:25:04,506 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_=?10:25:04,507 FST | [StringType] binding 'test.10001' to parameter: 110:25:04,512 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_=?10:25:04,513 FST | [StringType] binding 'test.10001' to parameter: 110:25:04,515 FIN | [DbSessionImpl] Deleting process instance test.1000110:25:04,515 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_=?10:25:04,516 FST | [LongType] binding '10001' to parameter: 110:25:04,518 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_=?10:25:04,519 FST | [LongType] binding '10001' to parameter: 110:25:04,521 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_=?10:25:04,521 FST | [LongType] binding '10001' to parameter: 110:25:04,528 FIN | [SQL] delete from JBPM4_EXECUTION where DBID_=? and DBVERSION_=?10:25:04,528 FST | [LongType] binding '10001' to parameter: 110:25:04,528 FST | [IntegerType] binding '3' to parameter: 210:25:04,538 WRN | [JDBCExceptionReporter] SQL Error: 1451, SQLState: 2300010:25:04,538 SEV | [JDBCExceptionReporter] Cannot delete or update a parent row: a foreign key constraint fails (`test`.`JBPM4_EXECUTION`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `JBPM4_EXECUTION` (`DBID_`))### EXCEPTION ###########################################10:25:04,538 SEV | [AbstractFlushingEventListener] Could not synchronize database state with sessionorg.hibernate.exception.ConstraintViolationException: could not delete: [org.jbpm.pvm.internal.model.ExecutionImpl#10001] 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.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:50) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1027) at org.jbpm.pvm.internal.tx.HibernateSessionResource.prepare(HibernateSessionResource.java:56) at org.jbpm.pvm.internal.tx.StandardTransaction.commit(StandardTransaction.java:107) at org.jbpm.pvm.internal.tx.StandardTransaction.complete(StandardTransaction.java:64) at org.jbpm.pvm.internal.tx.StandardTransactionInterceptor.execute(StandardTransactionInterceptor.java:57) 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.svc.TaskServiceImpl.completeTask(TaskServiceImpl.java:88) at com.tgb.video.testJbpm.completeTask(testJbpm.java:63) at sun.reflect.NativeMethod accessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at junit.framework.TestCase.runTest(TestCase.java:164) at junit.framework.TestCase.runBare(TestCase.java:130) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:120) at org.eclipse.jdt.internal.junit.runner.junit3.JUnit3TestReference.run(JUnit3TestReference.java:131) at org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:459) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:675) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:382) at org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:192)Caused by: com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`JBPM4_EXECUTION`, CONSTRAINT `FK_EXEC_INSTANCE` FOREIGN KEY (`INSTANCE_`) REFERENCES `JBPM4_EXECUTION` (`DBID_`)) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:931) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723) at com.mysql.jdbc.Connection.execSQL(Connection.java:3283) at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519) at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504) at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:2551) ... 34 more### EXCEPTION ###########################################10:25:04,540 FIN | [HibernateSessionResource] ----- rolling back hibernate tx 1940445711 -----------------------------------------------------

測試流程如圖：這里寫圖片描述我測試代碼是：completeTask

package com.tgb.video;import java.util.List;import org.jbpm.api.Configuration;import org.jbpm.api.ExecutionService;import org.jbpm.api.ProcessEngine;import org.jbpm.api.ProcessInstance;import org.jbpm.api.RepositoryService;import org.jbpm.api.TaskService;import org.jbpm.api.task.Task;import junit.framework.TestCase;public class testJbpm extends TestCase{ /** * 第1步：部署流程； */ public void deploy(){ ProcessEngine processEngine=Configuration.getProcessEngine();//得到流程引擎processEngine， RepositoryService repositoryService=processEngine.getRepositoryService();//通過流程引擎得到服務 repositoryService.createDeployment().addResourceFromClasspath("test.jpdl.xml").deploy(); } /** * 第2步：創建流程實例； */ public void createInstance(){ ProcessEngine processEngine=Configuration.getProcessEngine();//得到流程引擎processEngine; ExecutionService executionService=processEngine.getExecutionService();//通過流程引擎得到流程執行服務; ProcessInstance processInstance=executionService.startProcessInstanceByKey("test"); System.out.println("流程實例ID==="+processInstance.getId()); } /** * 獲取對應人員的任務 */ public void getTask(){ ProcessEngine processEngine=Configuration.getProcessEngine();//得到流程引擎processEngine; TaskService taskService=processEngine.getTaskService();//通過流程引擎得到任務服務接口// List<Task> tasks=taskService.findPersonalTasks("張三");//得到張三用戶擁有的任務 List<Task> tasks=taskService.findPersonalTasks("李四");//得到李四用戶擁有的任務 System.out.println("任務數量=="+tasks.size()); System.out.println("任務名稱=="+tasks.get(0).getActivityName()); System.out.println("任務人員=="+tasks.get(0).getAssignee()+";任務ID=="+tasks.get(0).getId()); } /** * 查看流程實例當前所在節點。如查看請假流程到哪一步了。 */ public void getCurrectActivity(){ ProcessEngine processEngine=Configuration.getProcessEngine(); ExecutionService executionService=processEngine.getExecutionService(); String activityName=executionService.createProcessInstanceQuery().processInstanceId("test.10001").uniqueResult().findActiveActivityNames().toString(); System.out.println("當前任務所在節點==="+activityName); } /** * 完成任務：這一任務完成后，進入到下一任務。如果下一任務為end節點。那么這個流程實例就結束了。 */ public void completeTask(){ ProcessEngine processEngine=Configuration.getProcessEngine(); TaskService taskService=processEngine.getTaskService();// taskService.completeTask("10002");//完成任務id 10002,在JBPM4_TASK表的DBID字段;這個任務完成后執行到下一個任務節點 taskService.completeTask("20001");//完成任務id 20001,在JBPM4_TASK表的DBID字段; }}

上一篇：poj1703 Find them, Catch them

下一篇：Conda cheat sheet