activiti框架查询规律 规律性是非常强的
processEngine.getXXService().createXXQuery().list();
processEngine.getRepositoryService().createDeploymentQuery().list();
processEngine.getRuntimeService().createProcessInstanceQuery().list();//创建流程实例查询对象
processEngine.getTaskService().createTaskQuery().list();
6.3 启动流程实例
什么是流程实例？根据一个流程定义具体的一次执行过程就是一个流程实例。刚才部署了一个请假流程，这是流程定义。具体的一次请假过程就是一个流程实例。一个流程定义对应多个流程实例(一对多)。
现在先不要特别地关心这个代码是怎么写的，这个代码都是死的，关键是要了解通过代码做了什么事情。这个代码启动了一个流程实例，相当于是我真正提交了一个申请，我要请假。
6.4 查询个人任务列表
除了管理员可以查询所有用户的任务列表其他人不行，所以要加上个人登录用户assignee,如果是WEB项目这个assignee就是个人登录用户，从session可以拿出来。这里就写死了，是张三或者是李四或者是王五。根据人来过滤任务列表查询。
6.5 办理任务
修改流程定义文件/activiti1110/process/test2.bpmn
指定我们当前这个任务的办理人是谁？可以是活的，但是我们现在暂时写死它。
修改了流程定义文件/activiti1110/process/test2.bpmn之后要重新部署一下，重新执行一下部署流程定义代码test4()
16:41:27,924 INFO ProcessEngines:108 - Initializing process engine using Spring configuration 'file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml'
16:41:27,950 DEBUG SpringConfigurationHelper:36 - ==== BUILDING SPRING APPLICATION CONTEXT AND PROCESS ENGINE =========================================
16:41:28,043 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
16:41:28,044 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
16:41:28,045 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
16:41:28,045 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
16:41:28,109 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
16:41:28,109 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
16:41:28,109 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
16:41:28,110 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
16:41:28,116 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from URL [file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml]
16:41:28,133 DEBUG DefaultDocumentLoader:72 - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
16:41:28,174 DEBUG PluggableSchemaResolver:140 - Loading schema mappings from [META-INF/spring.schemas]
16:41:28,178 DEBUG PluggableSchemaResolver:146 - Loaded schema mappings: {http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-3.1.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.1.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.activiti.org/schema/spring/components/activiti-5.0.xsd=org/activiti/spring/components/config/xml/activit-5.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-3.1.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-3.1.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.1.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/context/spring-context-3.1.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.1.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.1.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache-3.1.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.activiti.org/schema/spring/components/activiti.xsd=org/activiti/spring/components/config/xml/activiti-5.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/aop/spring-aop-3.1.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd}
16:41:28,180 DEBUG PluggableSchemaResolver:118 - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.1.xsd
16:41:28,225 DEBUG DefaultBeanDefinitionDocumentReader:108 - Loading bean definitions
16:41:28,248 INFO GenericXmlApplicationContext:500 - Refreshing org.springframework.context.support.GenericXmlApplicationContext@b886fb3: startup date [Wed Feb 15 16:41:28 CST 2017]; root of context hierarchy
16:41:28,249 DEBUG GenericXmlApplicationContext:530 - Bean factory for org.springframework.context.support.GenericXmlApplicationContext@b886fb3: org.springframework.beans.factory.support.DefaultListableBeanFactory@192f8d57: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
16:41:28,282 DEBUG GenericXmlApplicationContext:799 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@4c509a05]
16:41:28,285 DEBUG GenericXmlApplicationContext:823 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@4857b188]
16:41:28,285 INFO DefaultListableBeanFactory:581 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@192f8d57: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
16:41:28,286 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngineConfiguration'
16:41:28,287 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngineConfiguration'
16:41:28,376 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngineConfiguration' to allow for resolving potential circular references
16:41:28,561 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngineConfiguration'
16:41:28,562 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngine'
16:41:28,562 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngine'
16:41:28,563 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngine' to allow for resolving potential circular references
16:41:28,563 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngineConfiguration'
16:41:28,568 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngine'
16:41:28,571 DEBUG GenericXmlApplicationContext:850 - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@5c0f1804]
16:41:28,571 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'lifecycleProcessor'
16:41:28,572 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngine'
16:41:28,745 DEBUG ProcessEngineConfigurationImpl:508 - initializing datasource to db: jdbc:mysql:///activiti_1110
16:41:28,752 DEBUG LogFactory:115 - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
16:41:28,769 DEBUG PooledDataSource:304 - PooledDataSource forcefully closed/removed all connections.
16:41:28,981 DEBUG PooledDataSource:378 - Created connection 31686006.
16:41:28,983 DEBUG ProcessEngineConfigurationImpl:586 - database product name: 'MySQL'
16:41:28,984 DEBUG ProcessEngineConfigurationImpl:591 - using database type: mysql
16:41:28,985 DEBUG PooledDataSource:332 - Returned connection 31686006 to pool.
16:41:29,929 DEBUG LogInterceptor:33 -
16:41:29,929 DEBUG LogInterceptor:34 - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
16:41:29,937 DEBUG JdbcTransaction:129 - Opening JDBC Connection
16:41:29,937 DEBUG PooledDataSource:367 - Checked out connection 31686006 from pool.
16:41:30,024 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,025 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
16:41:30,047 DEBUG selectProperty:132 - ==> Parameters: schema.version(String)
16:41:30,111 DEBUG DbSqlSession:428 - flush summary: 0 insert, 0 update, 0 delete.
16:41:30,111 DEBUG DbSqlSession:438 - now executing flush...
16:41:30,111 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
16:41:30,111 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
16:41:30,111 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
16:41:30,111 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,113 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,113 DEBUG PooledDataSource:332 - Returned connection 31686006 to pool.
16:41:30,113 DEBUG LogInterceptor:40 - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
16:41:30,113 DEBUG LogInterceptor:41 -
16:41:30,113 INFO ProcessEngineImpl:81 - ProcessEngine default created
16:41:30,113 DEBUG SpringConfigurationHelper:48 - ==== SPRING PROCESS ENGINE CREATED ==================================================================
16:41:30,115 DEBUG LogInterceptor:33 -
16:41:30,115 DEBUG LogInterceptor:34 - --- starting DeployCmd --------------------------------------------------------
16:41:30,116 DEBUG LogInterceptor:33 -
16:41:30,116 DEBUG LogInterceptor:34 - --- starting GetNextIdBlockCmd --------------------------------------------------------
16:41:30,116 DEBUG JdbcTransaction:129 - Opening JDBC Connection
16:41:30,116 DEBUG PooledDataSource:367 - Checked out connection 31686006 from pool.
16:41:30,117 DEBUG JdbcTransaction:95 - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,118 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,118 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
16:41:30,118 DEBUG selectProperty:132 - ==> Parameters: next.dbid(String)
16:41:30,120 DEBUG DbSqlSession:428 - flush summary: 0 insert, 1 update, 0 delete.
16:41:30,120 DEBUG DbSqlSession:433 - update PropertyEntity[name=next.dbid, value=701]
16:41:30,120 DEBUG DbSqlSession:438 - now executing flush...
16:41:30,120 DEBUG DbSqlSession:557 - updating: PropertyEntity[name=next.dbid, value=701]
16:41:30,121 DEBUG updateProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,121 DEBUG updateProperty:132 - ==> Preparing: update ACT_GE_PROPERTY SET REV_ = ?, VALUE_ = ? where NAME_ = ? and REV_ = ?
16:41:30,122 DEBUG updateProperty:132 - ==> Parameters: 8(Integer), 701(String), next.dbid(String), 7(Integer)
16:41:30,125 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
16:41:30,125 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
16:41:30,125 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,191 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
16:41:30,191 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,192 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,192 DEBUG PooledDataSource:332 - Returned connection 31686006 to pool.
16:41:30,192 DEBUG LogInterceptor:40 - --- GetNextIdBlockCmd finished --------------------------------------------------------
16:41:30,192 DEBUG LogInterceptor:41 -
16:41:30,192 DEBUG BpmnDeployer:68 - Processing deployment null
16:41:30,193 INFO BpmnDeployer:75 - Processing resource test2.bpmn
16:41:30,298 DEBUG ProcessParseHandler:77 - Parsing process qjlc
16:41:30,299 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask1
16:41:30,323 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask2
16:41:30,324 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask3
16:41:30,324 DEBUG AbstractBpmnParseHandler:94 - Parsing activity startevent1
16:41:30,326 DEBUG AbstractBpmnParseHandler:94 - Parsing activity endevent1
16:41:30,327 INFO BpmnDeployer:75 - Processing resource test2.png
16:41:30,328 DEBUG JdbcTransaction:129 - Opening JDBC Connection
16:41:30,328 DEBUG PooledDataSource:367 - Checked out connection 31686006 from pool.
16:41:30,328 DEBUG JdbcTransaction:95 - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,330 DEBUG selectLatestProcessDefinitionByKey:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,330 DEBUG selectLatestProcessDefinitionByKey:132 - ==> Preparing: select * from ACT_RE_PROCDEF where KEY_ = ? and VERSION_ = (select max(VERSION_) from ACT_RE_PROCDEF where KEY_ = ?)
16:41:30,330 DEBUG selectLatestProcessDefinitionByKey:132 - ==> Parameters: qjlc(String), qjlc(String)
16:41:30,337 DEBUG selectJobsByConfiguration:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,338 DEBUG selectJobsByConfiguration:132 - ==> Preparing: select * from ACT_RU_JOB where HANDLER_TYPE_ = ? and HANDLER_CFG_ = ?
16:41:30,338 DEBUG selectJobsByConfiguration:132 - ==> Parameters: timer-start-event(String), qjlc(String)
16:41:30,342 DEBUG selectEventSubscriptionsByConfiguration:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,342 DEBUG selectEventSubscriptionsByConfiguration:132 - ==> Preparing: select * from ACT_RU_EVENT_SUBSCR where (EVENT_TYPE_ = ?) and (CONFIGURATION_ = ?)
16:41:30,342 DEBUG selectEventSubscriptionsByConfiguration:132 - ==> Parameters: message(String), qjlc:6:504(String)
16:41:30,345 DEBUG DbSqlSession:428 - flush summary: 4 insert, 0 update, 0 delete.
16:41:30,345 DEBUG DbSqlSession:430 - insert DeploymentEntity[id=601, name=null]
16:41:30,345 DEBUG DbSqlSession:430 - insert ResourceEntity[id=602, name=test2.bpmn]
16:41:30,346 DEBUG DbSqlSession:430 - insert ResourceEntity[id=603, name=test2.png]
16:41:30,346 DEBUG DbSqlSession:430 - insert ProcessDefinitionEntity[qjlc:7:604]
16:41:30,346 DEBUG DbSqlSession:438 - now executing flush...
16:41:30,346 DEBUG DbSqlSession:537 - inserting: DeploymentEntity[id=601, name=null]
16:41:30,346 DEBUG insertDeployment:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,346 DEBUG insertDeployment:132 - ==> Preparing: insert into ACT_RE_DEPLOYMENT(ID_, NAME_, CATEGORY_, DEPLOY_TIME_) values(?, ?, ?, ?)
16:41:30,351 DEBUG insertDeployment:132 - ==> Parameters: 601(String), null, null, 2017-02-15 16:41:30.115(Timestamp)
16:41:30,353 DEBUG DbSqlSession:537 - inserting: ResourceEntity[id=602, name=test2.bpmn]
16:41:30,353 DEBUG insertResource:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,353 DEBUG insertResource:132 - ==> Preparing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) values (?, 1, ?, ?, ?, ?)
16:41:30,354 DEBUG insertResource:132 - ==> Parameters: 602(String), test2.bpmn(String), java.io.ByteArrayInputStream@6d1ea615(ByteArrayInputStream), 601(String), false(Boolean)
16:41:30,356 DEBUG DbSqlSession:537 - inserting: ResourceEntity[id=603, name=test2.png]
16:41:30,356 DEBUG insertResource:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,356 DEBUG insertResource:132 - ==> Preparing: insert into ACT_GE_BYTEARRAY(ID_, REV_, NAME_, BYTES_, DEPLOYMENT_ID_, GENERATED_) values (?, 1, ?, ?, ?, ?)
16:41:30,357 DEBUG insertResource:132 - ==> Parameters: 603(String), test2.png(String), java.io.ByteArrayInputStream@21c22eaf(ByteArrayInputStream), 601(String), false(Boolean)
16:41:30,382 DEBUG DbSqlSession:537 - inserting: ProcessDefinitionEntity[qjlc:7:604]
16:41:30,382 DEBUG insertProcessDefinition:132 - ooo Using Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,382 DEBUG insertProcessDefinition:132 - ==> Preparing: insert into ACT_RE_PROCDEF(ID_, REV_, CATEGORY_, NAME_, KEY_, VERSION_, DEPLOYMENT_ID_, RESOURCE_NAME_, DGRM_RESOURCE_NAME_, DESCRIPTION_, HAS_START_FORM_KEY_, SUSPENSION_STATE_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
16:41:30,383 DEBUG insertProcessDefinition:132 - ==> Parameters: qjlc:7:604(String), http://www.activiti.org/test(String), 请假流程(String), qjlc(String), 7(Integer), 601(String), test2.bpmn(String), test2.png(String), null, false(Boolean), 1(Integer)
16:41:30,384 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
16:41:30,384 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
16:41:30,385 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,440 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
16:41:30,440 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,441 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@1e37d76]
16:41:30,442 DEBUG PooledDataSource:332 - Returned connection 31686006 to pool.
16:41:30,442 DEBUG LogInterceptor:40 - --- DeployCmd finished --------------------------------------------------------
16:41:30,442 DEBUG LogInterceptor:41 -
601
最新的流程定义表的数据
根据流程定义的id启动一个流程实例，可以通过执行test5()方法查询流程定义列表来获得最新的流程定义的id
执行test6()方法,打印出流程实例的Id
18:27:22,260 INFO ProcessEngines:108 - Initializing process engine using Spring configuration 'file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml'
18:27:22,279 DEBUG SpringConfigurationHelper:36 - ==== BUILDING SPRING APPLICATION CONTEXT AND PROCESS ENGINE =========================================
18:27:22,343 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
18:27:22,344 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
18:27:22,346 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
18:27:22,346 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
18:27:22,416 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
18:27:22,416 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
18:27:22,416 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
18:27:22,416 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
18:27:22,422 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from URL [file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml]
18:27:22,464 DEBUG DefaultDocumentLoader:72 - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
18:27:22,507 DEBUG PluggableSchemaResolver:140 - Loading schema mappings from [META-INF/spring.schemas]
18:27:22,511 DEBUG PluggableSchemaResolver:146 - Loaded schema mappings: {http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-3.1.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.1.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.activiti.org/schema/spring/components/activiti-5.0.xsd=org/activiti/spring/components/config/xml/activit-5.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-3.1.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-3.1.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.1.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/context/spring-context-3.1.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.1.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.1.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache-3.1.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.activiti.org/schema/spring/components/activiti.xsd=org/activiti/spring/components/config/xml/activiti-5.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/aop/spring-aop-3.1.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd}
18:27:22,514 DEBUG PluggableSchemaResolver:118 - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.1.xsd
18:27:22,562 DEBUG DefaultBeanDefinitionDocumentReader:108 - Loading bean definitions
18:27:22,597 INFO GenericXmlApplicationContext:500 - Refreshing org.springframework.context.support.GenericXmlApplicationContext@41f5ad2b: startup date [Wed Feb 15 18:27:22 CST 2017]; root of context hierarchy
18:27:22,597 DEBUG GenericXmlApplicationContext:530 - Bean factory for org.springframework.context.support.GenericXmlApplicationContext@41f5ad2b: org.springframework.beans.factory.support.DefaultListableBeanFactory@4715c34e: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
18:27:22,627 DEBUG GenericXmlApplicationContext:799 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@59f55efc]
18:27:22,629 DEBUG GenericXmlApplicationContext:823 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@6dc7cb10]
18:27:22,630 INFO DefaultListableBeanFactory:581 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@4715c34e: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
18:27:22,630 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngineConfiguration'
18:27:22,631 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngineConfiguration'
18:27:22,721 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngineConfiguration' to allow for resolving potential circular references
18:27:22,888 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngineConfiguration'
18:27:22,888 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngine'
18:27:22,888 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngine'
18:27:22,889 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngine' to allow for resolving potential circular references
18:27:22,890 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngineConfiguration'
18:27:22,894 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngine'
18:27:22,896 DEBUG GenericXmlApplicationContext:850 - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@5c0f1804]
18:27:22,897 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'lifecycleProcessor'
18:27:22,897 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngine'
18:27:23,053 DEBUG ProcessEngineConfigurationImpl:508 - initializing datasource to db: jdbc:mysql:///activiti_1110
18:27:23,058 DEBUG LogFactory:115 - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
18:27:23,071 DEBUG PooledDataSource:304 - PooledDataSource forcefully closed/removed all connections.
18:27:23,216 DEBUG PooledDataSource:378 - Created connection 2033855703.
18:27:23,217 DEBUG ProcessEngineConfigurationImpl:586 - database product name: 'MySQL'
18:27:23,217 DEBUG ProcessEngineConfigurationImpl:591 - using database type: mysql
18:27:23,218 DEBUG PooledDataSource:332 - Returned connection 2033855703 to pool.
18:27:24,059 DEBUG LogInterceptor:33 -
18:27:24,059 DEBUG LogInterceptor:34 - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
18:27:24,068 DEBUG JdbcTransaction:129 - Opening JDBC Connection
18:27:24,068 DEBUG PooledDataSource:367 - Checked out connection 2033855703 from pool.
18:27:24,104 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,104 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
18:27:24,126 DEBUG selectProperty:132 - ==> Parameters: schema.version(String)
18:27:24,156 DEBUG DbSqlSession:428 - flush summary: 0 insert, 0 update, 0 delete.
18:27:24,156 DEBUG DbSqlSession:438 - now executing flush...
18:27:24,156 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
18:27:24,157 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
18:27:24,157 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
18:27:24,157 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,158 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,158 DEBUG PooledDataSource:332 - Returned connection 2033855703 to pool.
18:27:24,158 DEBUG LogInterceptor:40 - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
18:27:24,158 DEBUG LogInterceptor:41 -
18:27:24,158 INFO ProcessEngineImpl:81 - ProcessEngine default created
18:27:24,158 DEBUG SpringConfigurationHelper:48 - ==== SPRING PROCESS ENGINE CREATED ==================================================================
18:27:24,159 DEBUG LogInterceptor:33 -
18:27:24,159 DEBUG LogInterceptor:34 - --- starting StartProcessInstanceCmd --------------------------------------------------------
18:27:24,160 DEBUG JdbcTransaction:129 - Opening JDBC Connection
18:27:24,160 DEBUG PooledDataSource:367 - Checked out connection 2033855703 from pool.
18:27:24,160 DEBUG JdbcTransaction:95 - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,161 DEBUG selectProcessDefinitionById:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,161 DEBUG selectProcessDefinitionById:132 - ==> Preparing: select * from ACT_RE_PROCDEF where ID_ = ?
18:27:24,161 DEBUG selectProcessDefinitionById:132 - ==> Parameters: qjlc:7:604(String)
18:27:24,163 DEBUG selectDeploymentById:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,163 DEBUG selectDeploymentById:132 - ==> Preparing: select * from ACT_RE_DEPLOYMENT where ID_ = ?
18:27:24,163 DEBUG selectDeploymentById:132 - ==> Parameters: 601(String)
18:27:24,168 DEBUG BpmnDeployer:68 - Processing deployment null
18:27:24,168 DEBUG selectResourcesByDeploymentId:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,169 DEBUG selectResourcesByDeploymentId:132 - ==> Preparing: select * from ACT_GE_BYTEARRAY where DEPLOYMENT_ID_ = ? order by NAME_ asc
18:27:24,169 DEBUG selectResourcesByDeploymentId:132 - ==> Parameters: 601(String)
18:27:24,183 INFO BpmnDeployer:75 - Processing resource test2.bpmn
18:27:24,319 DEBUG ProcessParseHandler:77 - Parsing process qjlc
18:27:24,320 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask1
18:27:24,348 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask2
18:27:24,348 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask3
18:27:24,349 DEBUG AbstractBpmnParseHandler:94 - Parsing activity startevent1
18:27:24,350 DEBUG AbstractBpmnParseHandler:94 - Parsing activity endevent1
18:27:24,352 INFO BpmnDeployer:75 - Processing resource test2.png
18:27:24,352 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,353 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ==> Preparing: select * from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? and KEY_ = ?
18:27:24,353 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ==> Parameters: 601(String), qjlc(String)
18:27:24,355 DEBUG LogInterceptor:33 -
18:27:24,356 DEBUG LogInterceptor:34 - --- starting GetNextIdBlockCmd --------------------------------------------------------
18:27:24,356 DEBUG JdbcTransaction:129 - Opening JDBC Connection
18:27:24,380 DEBUG PooledDataSource:378 - Created connection 1390968243.
18:27:24,382 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@52e87db3]
18:27:24,383 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
18:27:24,383 DEBUG selectProperty:132 - ==> Parameters: next.dbid(String)
18:27:24,386 DEBUG DbSqlSession:428 - flush summary: 0 insert, 1 update, 0 delete.
18:27:24,386 DEBUG DbSqlSession:433 - update PropertyEntity[name=next.dbid, value=801]
18:27:24,387 DEBUG DbSqlSession:438 - now executing flush...
18:27:24,387 DEBUG DbSqlSession:557 - updating: PropertyEntity[name=next.dbid, value=801]
18:27:24,387 DEBUG updateProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@52e87db3]
18:27:24,387 DEBUG updateProperty:132 - ==> Preparing: update ACT_GE_PROPERTY SET REV_ = ?, VALUE_ = ? where NAME_ = ? and REV_ = ?
18:27:24,388 DEBUG updateProperty:132 - ==> Parameters: 9(Integer), 801(String), next.dbid(String), 8(Integer)
18:27:24,391 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
18:27:24,391 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
18:27:24,391 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@52e87db3]
18:27:24,418 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
18:27:24,418 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@52e87db3]
18:27:24,420 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@52e87db3]
18:27:24,421 DEBUG PooledDataSource:332 - Returned connection 1390968243 to pool.
18:27:24,421 DEBUG LogInterceptor:40 - --- GetNextIdBlockCmd finished --------------------------------------------------------
18:27:24,421 DEBUG LogInterceptor:41 -
18:27:24,421 DEBUG ExecutionEntity:281 - initializing ProcessInstance[701]
18:27:24,423 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
18:27:24,429 DEBUG AtomicOperationActivityExecute:41 - ProcessInstance[701] executes Activity(startevent1): org.activiti.engine.impl.bpmn.behavior.NoneStartEventActivityBehavior
18:27:24,430 DEBUG BpmnActivityBehavior:87 - Leaving activity 'startevent1'
18:27:24,430 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
18:27:24,430 DEBUG AtomicOperationTransitionNotifyListenerTake:58 - ProcessInstance[701] takes transition (startevent1)--flow1-->(usertask1)
18:27:24,430 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
18:27:24,430 DEBUG AtomicOperationActivityExecute:41 - ProcessInstance[701] executes Activity(usertask1): org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior
18:27:24,431 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,431 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,431 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,432 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,433 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,433 DEBUG selectIdentityLinksByProcessInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,434 DEBUG selectIdentityLinksByProcessInstance:132 - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ?
18:27:24,435 DEBUG selectIdentityLinksByProcessInstance:132 - ==> Parameters: 701(String)
18:27:24,436 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
18:27:24,437 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
18:27:24,437 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
18:27:24,438 DEBUG DbSqlSession:428 - flush summary: 8 insert, 0 update, 0 delete.
18:27:24,438 DEBUG DbSqlSession:430 - insert ProcessInstance[701]
18:27:24,438 DEBUG DbSqlSession:430 - insert HistoricProcessInstanceEntity[superProcessInstanceId=null]
18:27:24,438 DEBUG DbSqlSession:430 - insert HistoricActivityInstanceEntity[activityId=startevent1, activityName=Start]
18:27:24,438 DEBUG DbSqlSession:430 - insert HistoricActivityInstanceEntity[activityId=usertask1, activityName=提交请假申请]
18:27:24,438 DEBUG DbSqlSession:430 - insert Task[id=704, name=提交请假申请]
18:27:24,438 DEBUG DbSqlSession:430 - insert org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@4664a2bd
18:27:24,438 DEBUG DbSqlSession:430 - insert IdentityLinkEntity[id=705, type=participant, userId=张三, processInstanceId=701]
18:27:24,438 DEBUG DbSqlSession:430 - insert org.activiti.engine.impl.persistence.entity.HistoricIdentityLinkEntity@78f84a65
18:27:24,438 DEBUG DbSqlSession:438 - now executing flush...
18:27:24,439 DEBUG DbSqlSession:537 - inserting: ProcessInstance[701]
18:27:24,439 DEBUG insertExecution:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,439 DEBUG insertExecution:132 - ==> Preparing: insert into ACT_RU_EXECUTION (ID_, REV_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, ACT_ID_, IS_ACTIVE_, IS_CONCURRENT_, IS_SCOPE_,IS_EVENT_SCOPE_, PARENT_ID_, SUPER_EXEC_, SUSPENSION_STATE_, CACHED_ENT_STATE_) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,441 DEBUG insertExecution:132 - ==> Parameters: 701(String), 701(String), null, qjlc:7:604(String), usertask1(String), true(Boolean), false(Boolean), true(Boolean), false(Boolean), null, null, 1(Integer), 2(Integer)
18:27:24,444 DEBUG DbSqlSession:537 - inserting: HistoricProcessInstanceEntity[superProcessInstanceId=null]
18:27:24,445 DEBUG insertHistoricProcessInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,445 DEBUG insertHistoricProcessInstance:132 - ==> Preparing: insert into ACT_HI_PROCINST ( ID_, PROC_INST_ID_, BUSINESS_KEY_, PROC_DEF_ID_, START_TIME_, END_TIME_, DURATION_, START_USER_ID_, START_ACT_ID_, END_ACT_ID_, SUPER_PROCESS_INSTANCE_ID_, DELETE_REASON_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,447 DEBUG insertHistoricProcessInstance:132 - ==> Parameters: 701(String), 701(String), null, qjlc:7:604(String), 2017-02-15 18:27:24.423(Timestamp), null, null, null, startevent1(String), null, null, null
18:27:24,450 DEBUG DbSqlSession:537 - inserting: HistoricActivityInstanceEntity[activityId=startevent1, activityName=Start]
18:27:24,451 DEBUG insertHistoricActivityInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,451 DEBUG insertHistoricActivityInstance:132 - ==> Preparing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,452 DEBUG insertHistoricActivityInstance:132 - ==> Parameters: 702(String), qjlc:7:604(String), 701(String), 701(String), startevent1(String), null, null, Start(String), startEvent(String), null, 2017-02-15 18:27:24.423(Timestamp), 2017-02-15 18:27:24.43(Timestamp), 7(Long)
18:27:24,472 DEBUG DbSqlSession:537 - inserting: HistoricActivityInstanceEntity[activityId=usertask1, activityName=提交请假申请]
18:27:24,473 DEBUG insertHistoricActivityInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,473 DEBUG insertHistoricActivityInstance:132 - ==> Preparing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,474 DEBUG insertHistoricActivityInstance:132 - ==> Parameters: 703(String), qjlc:7:604(String), 701(String), 701(String), usertask1(String), 704(String), null, 提交请假申请(String), userTask(String), 张三(String), 2017-02-15 18:27:24.43(Timestamp), null, null
18:27:24,474 DEBUG DbSqlSession:537 - inserting: Task[id=704, name=提交请假申请]
18:27:24,475 DEBUG insertTask:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,475 DEBUG insertTask:132 - ==> Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, SUSPENSION_STATE_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,475 DEBUG insertTask:132 - ==> Parameters: 704(String), 提交请假申请(String), null, null, 50(Integer), 2017-02-15 18:27:24.431(Timestamp), null, 张三(String), null, 701(String), 701(String), qjlc:7:604(String), usertask1(String), null, 1(Integer)
18:27:24,569 DEBUG DbSqlSession:537 - inserting: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@4664a2bd
18:27:24,570 DEBUG insertHistoricTaskInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,570 DEBUG insertHistoricTaskInstance:132 - ==> Preparing: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
18:27:24,571 DEBUG insertHistoricTaskInstance:132 - ==> Parameters: 704(String), qjlc:7:604(String), 701(String), 701(String), 提交请假申请(String), null, null, null, 张三(String), 2017-02-15 18:27:24.431(Timestamp), null, null, null, null, usertask1(String), null, 50(Integer), null
18:27:24,572 DEBUG DbSqlSession:537 - inserting: IdentityLinkEntity[id=705, type=participant, userId=张三, processInstanceId=701]
18:27:24,573 DEBUG insertIdentityLink:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,573 DEBUG insertIdentityLink:132 - ==> Preparing: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) values (?, 1, ?, ?, ?, ?, ?, ?)
18:27:24,574 DEBUG insertIdentityLink:132 - ==> Parameters: 705(String), participant(String), 张三(String), null, null, 701(String), null
18:27:24,576 DEBUG DbSqlSession:537 - inserting: org.activiti.engine.impl.persistence.entity.HistoricIdentityLinkEntity@78f84a65
18:27:24,576 DEBUG insertHistoricIdentityLink:132 - ooo Using Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,577 DEBUG insertHistoricIdentityLink:132 - ==> Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_) values (?, ?, ?, ?, ?, ?)
18:27:24,577 DEBUG insertHistoricIdentityLink:132 - ==> Parameters: 705(String), participant(String), 张三(String), null, null, 701(String)
18:27:24,580 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
18:27:24,580 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
18:27:24,580 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,611 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
18:27:24,611 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,612 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@793a2cd7]
18:27:24,612 DEBUG PooledDataSource:332 - Returned connection 2033855703 to pool.
18:27:24,612 DEBUG LogInterceptor:40 - --- StartProcessInstanceCmd finished --------------------------------------------------------
18:27:24,612 DEBUG LogInterceptor:41 -
701
每启动一个流程实例，都会向这张表act_ru_execution插入一条记录
外键PROC_DEF_ID_记录了这个流程实例是根据哪一个流程定义启动的。ACT_ID记录了当前流程走到哪一个节点(步骤)
act_ru_task表存储了张三的待办任务。
NAME对应的是任务的名称,任务的Id是TASK_DEF_KEY_(usertask1),PROC_INST_ID_是外键,PROC_INST_ID_是流程实例的Id,ASSIGNEE_是任务的办理人(代理人)
一个流程定义可以对应多个流程实例
一个流程实例可以对应多个任务
执行test7()方法查询任务列表,打印任务的Id和任务的名称
19:30:36,503 INFO ProcessEngines:108 - Initializing process engine using Spring configuration 'file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml'
19:30:36,532 DEBUG SpringConfigurationHelper:36 - ==== BUILDING SPRING APPLICATION CONTEXT AND PROCESS ENGINE =========================================
19:30:36,613 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
19:30:36,614 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
19:30:36,616 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
19:30:36,616 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
19:30:36,688 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
19:30:36,688 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
19:30:36,688 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
19:30:36,689 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
19:30:36,694 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from URL [file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml]
19:30:36,742 DEBUG DefaultDocumentLoader:72 - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
19:30:36,787 DEBUG PluggableSchemaResolver:140 - Loading schema mappings from [META-INF/spring.schemas]
19:30:36,793 DEBUG PluggableSchemaResolver:146 - Loaded schema mappings: {http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-3.1.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.1.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.activiti.org/schema/spring/components/activiti-5.0.xsd=org/activiti/spring/components/config/xml/activit-5.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-3.1.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-3.1.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.1.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/context/spring-context-3.1.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.1.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.1.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache-3.1.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.activiti.org/schema/spring/components/activiti.xsd=org/activiti/spring/components/config/xml/activiti-5.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/aop/spring-aop-3.1.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd}
19:30:36,795 DEBUG PluggableSchemaResolver:118 - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.1.xsd
19:30:36,846 DEBUG DefaultBeanDefinitionDocumentReader:108 - Loading bean definitions
19:30:36,873 INFO GenericXmlApplicationContext:500 - Refreshing org.springframework.context.support.GenericXmlApplicationContext@6d36d73: startup date [Wed Feb 15 19:30:36 CST 2017]; root of context hierarchy
19:30:36,874 DEBUG GenericXmlApplicationContext:530 - Bean factory for org.springframework.context.support.GenericXmlApplicationContext@6d36d73: org.springframework.beans.factory.support.DefaultListableBeanFactory@1843095f: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
19:30:36,903 DEBUG GenericXmlApplicationContext:799 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@4bad4a49]
19:30:36,906 DEBUG GenericXmlApplicationContext:823 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@272ab5b8]
19:30:36,906 INFO DefaultListableBeanFactory:581 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@1843095f: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
19:30:36,907 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngineConfiguration'
19:30:36,907 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngineConfiguration'
19:30:36,986 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngineConfiguration' to allow for resolving potential circular references
19:30:37,134 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngineConfiguration'
19:30:37,135 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngine'
19:30:37,135 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngine'
19:30:37,135 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngine' to allow for resolving potential circular references
19:30:37,136 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngineConfiguration'
19:30:37,140 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngine'
19:30:37,141 DEBUG GenericXmlApplicationContext:850 - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@70e4d64b]
19:30:37,142 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'lifecycleProcessor'
19:30:37,142 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngine'
19:30:37,287 DEBUG ProcessEngineConfigurationImpl:508 - initializing datasource to db: jdbc:mysql:///activiti_1110
19:30:37,292 DEBUG LogFactory:115 - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
19:30:37,306 DEBUG PooledDataSource:304 - PooledDataSource forcefully closed/removed all connections.
19:30:37,469 DEBUG PooledDataSource:378 - Created connection 1798788533.
19:30:37,471 DEBUG ProcessEngineConfigurationImpl:586 - database product name: 'MySQL'
19:30:37,471 DEBUG ProcessEngineConfigurationImpl:591 - using database type: mysql
19:30:37,473 DEBUG PooledDataSource:332 - Returned connection 1798788533 to pool.
19:30:38,380 DEBUG LogInterceptor:33 -
19:30:38,380 DEBUG LogInterceptor:34 - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
19:30:38,388 DEBUG JdbcTransaction:129 - Opening JDBC Connection
19:30:38,388 DEBUG PooledDataSource:367 - Checked out connection 1798788533 from pool.
19:30:38,432 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,433 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
19:30:38,452 DEBUG selectProperty:132 - ==> Parameters: schema.version(String)
19:30:38,483 DEBUG DbSqlSession:428 - flush summary: 0 insert, 0 update, 0 delete.
19:30:38,483 DEBUG DbSqlSession:438 - now executing flush...
19:30:38,483 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
19:30:38,484 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
19:30:38,484 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
19:30:38,484 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,486 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,486 DEBUG PooledDataSource:332 - Returned connection 1798788533 to pool.
19:30:38,487 DEBUG LogInterceptor:40 - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
19:30:38,487 DEBUG LogInterceptor:41 -
19:30:38,487 INFO ProcessEngineImpl:81 - ProcessEngine default created
19:30:38,487 DEBUG SpringConfigurationHelper:48 - ==== SPRING PROCESS ENGINE CREATED ==================================================================
19:30:38,488 DEBUG LogInterceptor:33 -
19:30:38,488 DEBUG LogInterceptor:34 - --- starting TaskQueryImpl --------------------------------------------------------
19:30:38,515 DEBUG JdbcTransaction:129 - Opening JDBC Connection
19:30:38,515 DEBUG PooledDataSource:367 - Checked out connection 1798788533 from pool.
19:30:38,515 DEBUG JdbcTransaction:95 - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,516 DEBUG selectTaskByQueryCriteria:132 - ooo Using Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,517 DEBUG selectTaskByQueryCriteria:132 - ==> Preparing: select distinct RES.* from ACT_RU_TASK RES WHERE RES.ASSIGNEE_ = ? order by RES.ID_ asc LIMIT ? OFFSET ?
19:30:38,517 DEBUG selectTaskByQueryCriteria:132 - ==> Parameters: 张三(String), 2147483647(Integer), 0(Integer)
19:30:38,524 DEBUG DbSqlSession:428 - flush summary: 0 insert, 0 update, 0 delete.
19:30:38,525 DEBUG DbSqlSession:438 - now executing flush...
19:30:38,525 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
19:30:38,525 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
19:30:38,525 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
19:30:38,525 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,526 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@6b3755b5]
19:30:38,526 DEBUG PooledDataSource:332 - Returned connection 1798788533 to pool.
19:30:38,527 DEBUG LogInterceptor:40 - --- TaskQueryImpl finished --------------------------------------------------------
19:30:38,527 DEBUG LogInterceptor:41 -
704 ??????
执行test8()方法办理任务
19:36:24,483 INFO ProcessEngines:108 - Initializing process engine using Spring configuration 'file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml'
19:36:24,494 DEBUG SpringConfigurationHelper:36 - ==== BUILDING SPRING APPLICATION CONTEXT AND PROCESS ENGINE =========================================
19:36:24,557 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
19:36:24,558 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
19:36:24,560 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
19:36:24,560 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
19:36:24,606 DEBUG StandardEnvironment:114 - Initializing new StandardEnvironment
19:36:24,606 DEBUG StandardEnvironment:104 - Adding [systemProperties] PropertySource with lowest search precedence
19:36:24,606 DEBUG StandardEnvironment:104 - Adding [systemEnvironment] PropertySource with lowest search precedence
19:36:24,607 DEBUG StandardEnvironment:120 - Initialized StandardEnvironment with PropertySources [systemProperties,systemEnvironment]
19:36:24,612 INFO XmlBeanDefinitionReader:315 - Loading XML bean definitions from URL [file:/D:/%e5%b7%a5%e4%bd%9c%e6%b5%813/activiti1110/bin/activiti-context.xml]
19:36:24,627 DEBUG DefaultDocumentLoader:72 - Using JAXP provider [com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderFactoryImpl]
19:36:24,653 DEBUG PluggableSchemaResolver:140 - Loading schema mappings from [META-INF/spring.schemas]
19:36:24,659 DEBUG PluggableSchemaResolver:146 - Loaded schema mappings: {http://www.springframework.org/schema/util/spring-util.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/task/spring-task.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-3.1.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-3.0.xsd=org/springframework/aop/config/spring-aop-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.1.xsd=org/springframework/scheduling/config/spring-task-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop-2.0.xsd=org/springframework/aop/config/spring-aop-2.0.xsd, http://www.springframework.org/schema/tool/spring-tool-2.5.xsd=org/springframework/beans/factory/xml/spring-tool-2.5.xsd, http://www.springframework.org/schema/beans/spring-beans.xsd=org/springframework/beans/factory/xml/spring-beans-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.5.xsd=org/springframework/ejb/config/spring-jee-2.5.xsd, http://www.activiti.org/schema/spring/components/activiti-5.0.xsd=org/activiti/spring/components/config/xml/activit-5.0.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.1.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-3.1.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-3.1.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.springframework.org/schema/aop/spring-aop.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/beans/spring-beans-2.0.xsd=org/springframework/beans/factory/xml/spring-beans-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-3.0.xsd=org/springframework/beans/factory/xml/spring-beans-3.0.xsd, http://www.springframework.org/schema/task/spring-task-3.0.xsd=org/springframework/scheduling/config/spring-task-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-2.5.xsd=org/springframework/transaction/config/spring-tx-2.5.xsd, http://www.springframework.org/schema/context/spring-context-2.5.xsd=org/springframework/context/config/spring-context-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc-3.0.xsd=org/springframework/jdbc/config/spring-jdbc-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool-3.0.xsd=org/springframework/beans/factory/xml/spring-tool-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/tool/spring-tool-2.0.xsd=org/springframework/beans/factory/xml/spring-tool-2.0.xsd, http://www.springframework.org/schema/util/spring-util-2.5.xsd=org/springframework/beans/factory/xml/spring-util-2.5.xsd, http://www.springframework.org/schema/lang/spring-lang-2.5.xsd=org/springframework/scripting/config/spring-lang-2.5.xsd, http://www.springframework.org/schema/jee/spring-jee-3.0.xsd=org/springframework/ejb/config/spring-jee-3.0.xsd, http://www.springframework.org/schema/tx/spring-tx-3.1.xsd=org/springframework/transaction/config/spring-tx-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee-2.0.xsd=org/springframework/ejb/config/spring-jee-2.0.xsd, http://www.springframework.org/schema/context/spring-context-3.1.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.1.xsd=org/springframework/beans/factory/xml/spring-util-3.1.xsd, http://www.springframework.org/schema/lang/spring-lang-3.1.xsd=org/springframework/scripting/config/spring-lang-3.1.xsd, http://www.springframework.org/schema/cache/spring-cache-3.1.xsd=org/springframework/cache/config/spring-cache-3.1.xsd, http://www.springframework.org/schema/context/spring-context.xsd=org/springframework/context/config/spring-context-3.1.xsd, http://www.springframework.org/schema/jee/spring-jee.xsd=org/springframework/ejb/config/spring-jee-3.1.xsd, http://www.activiti.org/schema/spring/components/activiti.xsd=org/activiti/spring/components/config/xml/activiti-5.0.xsd, http://www.springframework.org/schema/aop/spring-aop-2.5.xsd=org/springframework/aop/config/spring-aop-2.5.xsd, http://www.springframework.org/schema/jdbc/spring-jdbc.xsd=org/springframework/jdbc/config/spring-jdbc-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-2.0.xsd=org/springframework/transaction/config/spring-tx-2.0.xsd, http://www.springframework.org/schema/aop/spring-aop-3.1.xsd=org/springframework/aop/config/spring-aop-3.1.xsd, http://www.springframework.org/schema/tx/spring-tx-3.0.xsd=org/springframework/transaction/config/spring-tx-3.0.xsd, http://www.springframework.org/schema/context/spring-context-3.0.xsd=org/springframework/context/config/spring-context-3.0.xsd, http://www.springframework.org/schema/tool/spring-tool.xsd=org/springframework/beans/factory/xml/spring-tool-3.1.xsd, http://www.springframework.org/schema/util/spring-util-3.0.xsd=org/springframework/beans/factory/xml/spring-util-3.0.xsd, http://www.springframework.org/schema/lang/spring-lang-3.0.xsd=org/springframework/scripting/config/spring-lang-3.0.xsd, http://www.springframework.org/schema/util/spring-util-2.0.xsd=org/springframework/beans/factory/xml/spring-util-2.0.xsd, http://www.springframework.org/schema/lang/spring-lang-2.0.xsd=org/springframework/scripting/config/spring-lang-2.0.xsd, http://www.springframework.org/schema/beans/spring-beans-2.5.xsd=org/springframework/beans/factory/xml/spring-beans-2.5.xsd}
19:36:24,662 DEBUG PluggableSchemaResolver:118 - Found XML schema [http://www.springframework.org/schema/beans/spring-beans.xsd] in classpath: org/springframework/beans/factory/xml/spring-beans-3.1.xsd
19:36:24,702 DEBUG DefaultBeanDefinitionDocumentReader:108 - Loading bean definitions
19:36:24,723 INFO GenericXmlApplicationContext:500 - Refreshing org.springframework.context.support.GenericXmlApplicationContext@2ddf191: startup date [Wed Feb 15 19:36:24 CST 2017]; root of context hierarchy
19:36:24,723 DEBUG GenericXmlApplicationContext:530 - Bean factory for org.springframework.context.support.GenericXmlApplicationContext@2ddf191: org.springframework.beans.factory.support.DefaultListableBeanFactory@5cdd29: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
19:36:24,740 DEBUG GenericXmlApplicationContext:799 - Unable to locate MessageSource with name 'messageSource': using default [org.springframework.context.support.DelegatingMessageSource@472a9389]
19:36:24,742 DEBUG GenericXmlApplicationContext:823 - Unable to locate ApplicationEventMulticaster with name 'applicationEventMulticaster': using default [org.springframework.context.event.SimpleApplicationEventMulticaster@696be535]
19:36:24,742 INFO DefaultListableBeanFactory:581 - Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5cdd29: defining beans [processEngineConfiguration,processEngine]; root of factory hierarchy
19:36:24,743 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngineConfiguration'
19:36:24,743 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngineConfiguration'
19:36:24,778 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngineConfiguration' to allow for resolving potential circular references
19:36:24,924 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngineConfiguration'
19:36:24,924 DEBUG DefaultListableBeanFactory:217 - Creating shared instance of singleton bean 'processEngine'
19:36:24,924 DEBUG DefaultListableBeanFactory:430 - Creating instance of bean 'processEngine'
19:36:24,925 DEBUG DefaultListableBeanFactory:504 - Eagerly caching bean 'processEngine' to allow for resolving potential circular references
19:36:24,925 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngineConfiguration'
19:36:24,930 DEBUG DefaultListableBeanFactory:458 - Finished creating instance of bean 'processEngine'
19:36:24,932 DEBUG GenericXmlApplicationContext:850 - Unable to locate LifecycleProcessor with name 'lifecycleProcessor': using default [org.springframework.context.support.DefaultLifecycleProcessor@7b2c4c4b]
19:36:24,932 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'lifecycleProcessor'
19:36:24,933 DEBUG DefaultListableBeanFactory:245 - Returning cached instance of singleton bean 'processEngine'
19:36:25,038 DEBUG ProcessEngineConfigurationImpl:508 - initializing datasource to db: jdbc:mysql:///activiti_1110
19:36:25,044 DEBUG LogFactory:115 - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
19:36:25,050 DEBUG PooledDataSource:304 - PooledDataSource forcefully closed/removed all connections.
19:36:25,193 DEBUG PooledDataSource:378 - Created connection 157889199.
19:36:25,196 DEBUG ProcessEngineConfigurationImpl:586 - database product name: 'MySQL'
19:36:25,196 DEBUG ProcessEngineConfigurationImpl:591 - using database type: mysql
19:36:25,198 DEBUG PooledDataSource:332 - Returned connection 157889199 to pool.
19:36:26,035 DEBUG LogInterceptor:33 -
19:36:26,036 DEBUG LogInterceptor:34 - --- starting SchemaOperationsProcessEngineBuild --------------------------------------------------------
19:36:26,043 DEBUG JdbcTransaction:129 - Opening JDBC Connection
19:36:26,044 DEBUG PooledDataSource:367 - Checked out connection 157889199 from pool.
19:36:26,071 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,071 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
19:36:26,090 DEBUG selectProperty:132 - ==> Parameters: schema.version(String)
19:36:26,116 DEBUG DbSqlSession:428 - flush summary: 0 insert, 0 update, 0 delete.
19:36:26,116 DEBUG DbSqlSession:438 - now executing flush...
19:36:26,117 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
19:36:26,117 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
19:36:26,117 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
19:36:26,117 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,119 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,120 DEBUG PooledDataSource:332 - Returned connection 157889199 to pool.
19:36:26,120 DEBUG LogInterceptor:40 - --- SchemaOperationsProcessEngineBuild finished --------------------------------------------------------
19:36:26,120 DEBUG LogInterceptor:41 -
19:36:26,120 INFO ProcessEngineImpl:81 - ProcessEngine default created
19:36:26,120 DEBUG SpringConfigurationHelper:48 - ==== SPRING PROCESS ENGINE CREATED ==================================================================
19:36:26,134 DEBUG LogInterceptor:33 -
19:36:26,134 DEBUG LogInterceptor:34 - --- starting CompleteTaskCmd --------------------------------------------------------
19:36:26,135 DEBUG JdbcTransaction:129 - Opening JDBC Connection
19:36:26,135 DEBUG PooledDataSource:367 - Checked out connection 157889199 from pool.
19:36:26,135 DEBUG JdbcTransaction:95 - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,137 DEBUG selectTask:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,138 DEBUG selectTask:132 - ==> Preparing: select * from ACT_RU_TASK where ID_ = ?
19:36:26,138 DEBUG selectTask:132 - ==> Parameters: 704(String)
19:36:26,145 DEBUG selectProcessDefinitionById:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,145 DEBUG selectProcessDefinitionById:132 - ==> Preparing: select * from ACT_RE_PROCDEF where ID_ = ?
19:36:26,145 DEBUG selectProcessDefinitionById:132 - ==> Parameters: qjlc:7:604(String)
19:36:26,148 DEBUG selectDeploymentById:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,148 DEBUG selectDeploymentById:132 - ==> Preparing: select * from ACT_RE_DEPLOYMENT where ID_ = ?
19:36:26,149 DEBUG selectDeploymentById:132 - ==> Parameters: 601(String)
19:36:26,151 DEBUG BpmnDeployer:68 - Processing deployment null
19:36:26,152 DEBUG selectResourcesByDeploymentId:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,152 DEBUG selectResourcesByDeploymentId:132 - ==> Preparing: select * from ACT_GE_BYTEARRAY where DEPLOYMENT_ID_ = ? order by NAME_ asc
19:36:26,153 DEBUG selectResourcesByDeploymentId:132 - ==> Parameters: 601(String)
19:36:26,157 INFO BpmnDeployer:75 - Processing resource test2.bpmn
19:36:26,325 DEBUG ProcessParseHandler:77 - Parsing process qjlc
19:36:26,325 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask1
19:36:26,363 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask2
19:36:26,363 DEBUG AbstractBpmnParseHandler:94 - Parsing activity usertask3
19:36:26,363 DEBUG AbstractBpmnParseHandler:94 - Parsing activity startevent1
19:36:26,365 DEBUG AbstractBpmnParseHandler:94 - Parsing activity endevent1
19:36:26,366 INFO BpmnDeployer:75 - Processing resource test2.png
19:36:26,366 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,367 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ==> Preparing: select * from ACT_RE_PROCDEF where DEPLOYMENT_ID_ = ? and KEY_ = ?
19:36:26,367 DEBUG selectProcessDefinitionByDeploymentAndKey:132 - ==> Parameters: 601(String), qjlc(String)
19:36:26,371 DEBUG selectTasksByParentTaskId:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,371 DEBUG selectTasksByParentTaskId:132 - ==> Preparing: select * from ACT_RU_TASK where PARENT_TASK_ID_ = ?
19:36:26,372 DEBUG selectTasksByParentTaskId:132 - ==> Parameters: 704(String)
19:36:26,375 DEBUG selectIdentityLinksByTask:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,375 DEBUG selectIdentityLinksByTask:132 - ==> Preparing: select * from ACT_RU_IDENTITYLINK where TASK_ID_ = ?
19:36:26,375 DEBUG selectIdentityLinksByTask:132 - ==> Parameters: 704(String)
19:36:26,379 DEBUG selectVariablesByTaskId:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,379 DEBUG selectVariablesByTaskId:132 - ==> Preparing: select * from ACT_RU_VARIABLE where TASK_ID_ = ?
19:36:26,379 DEBUG selectVariablesByTaskId:132 - ==> Parameters: 704(String)
19:36:26,391 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,392 DEBUG selectHistoricTaskInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,392 DEBUG selectHistoricTaskInstance:132 - ==> Preparing: select * from ACT_HI_TASKINST where ID_ = ?
19:36:26,392 DEBUG selectHistoricTaskInstance:132 - ==> Parameters: 704(String)
19:36:26,396 DEBUG selectExecution:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,397 DEBUG selectExecution:132 - ==> Preparing: select * from ACT_RU_EXECUTION where ID_ = ?
19:36:26,397 DEBUG selectExecution:132 - ==> Parameters: 701(String)
19:36:26,402 DEBUG selectTasksByExecutionId:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,402 DEBUG selectTasksByExecutionId:132 - ==> Preparing: select distinct T.* from ACT_RU_TASK T where T.EXECUTION_ID_ = ?
19:36:26,402 DEBUG selectTasksByExecutionId:132 - ==> Parameters: 701(String)
19:36:26,406 DEBUG BpmnActivityBehavior:87 - Leaving activity 'usertask1'
19:36:26,418 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
19:36:26,444 DEBUG selectHistoricActivityInstancesByQueryCriteria:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,445 DEBUG selectHistoricActivityInstancesByQueryCriteria:132 - ==> Preparing: select RES.* from ACT_HI_ACTINST RES WHERE RES.EXECUTION_ID_ = ? and RES.ACT_ID_ = ? and RES.END_TIME_ is null order by RES.ID_ asc LIMIT ? OFFSET ?
19:36:26,445 DEBUG selectHistoricActivityInstancesByQueryCriteria:132 - ==> Parameters: 701(String), usertask1(String), 1(Integer), 0(Integer)
19:36:26,461 DEBUG AtomicOperationTransitionNotifyListenerTake:58 - ProcessInstance[701] takes transition (usertask1)--flow2-->(usertask2)
19:36:26,461 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
19:36:26,461 DEBUG LogInterceptor:33 -
19:36:26,462 DEBUG LogInterceptor:34 - --- starting GetNextIdBlockCmd --------------------------------------------------------
19:36:26,462 DEBUG JdbcTransaction:129 - Opening JDBC Connection
19:36:26,473 DEBUG PooledDataSource:378 - Created connection 1232380322.
19:36:26,473 DEBUG selectProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@4974a1a2]
19:36:26,473 DEBUG selectProperty:132 - ==> Preparing: select * from ACT_GE_PROPERTY where NAME_ = ?
19:36:26,474 DEBUG selectProperty:132 - ==> Parameters: next.dbid(String)
19:36:26,476 DEBUG DbSqlSession:428 - flush summary: 0 insert, 1 update, 0 delete.
19:36:26,476 DEBUG DbSqlSession:433 - update PropertyEntity[name=next.dbid, value=901]
19:36:26,476 DEBUG DbSqlSession:438 - now executing flush...
19:36:26,476 DEBUG DbSqlSession:557 - updating: PropertyEntity[name=next.dbid, value=901]
19:36:26,477 DEBUG updateProperty:132 - ooo Using Connection [com.mysql.jdbc.Connection@4974a1a2]
19:36:26,477 DEBUG updateProperty:132 - ==> Preparing: update ACT_GE_PROPERTY SET REV_ = ?, VALUE_ = ? where NAME_ = ? and REV_ = ?
19:36:26,477 DEBUG updateProperty:132 - ==> Parameters: 10(Integer), 901(String), next.dbid(String), 9(Integer)
19:36:26,479 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
19:36:26,479 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
19:36:26,480 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@4974a1a2]
19:36:26,536 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
19:36:26,536 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@4974a1a2]
19:36:26,537 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@4974a1a2]
19:36:26,537 DEBUG PooledDataSource:332 - Returned connection 1232380322 to pool.
19:36:26,537 DEBUG LogInterceptor:40 - --- GetNextIdBlockCmd finished --------------------------------------------------------
19:36:26,537 DEBUG LogInterceptor:41 -
19:36:26,538 DEBUG AtomicOperationActivityExecute:41 - ProcessInstance[701] executes Activity(usertask2): org.activiti.engine.impl.bpmn.behavior.UserTaskActivityBehavior
19:36:26,538 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,538 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,538 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,540 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,540 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,540 DEBUG selectIdentityLinksByProcessInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,541 DEBUG selectIdentityLinksByProcessInstance:132 - ==> Preparing: select * from ACT_RU_IDENTITYLINK where PROC_INST_ID_ = ?
19:36:26,541 DEBUG selectIdentityLinksByProcessInstance:132 - ==> Parameters: 701(String)
19:36:26,546 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: AUDIT
19:36:26,546 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
19:36:26,546 DEBUG HistoryManager:70 - Current history level: AUDIT, level required: ACTIVITY
19:36:26,547 DEBUG DbSqlSession:428 - flush summary: 5 insert, 3 update, 1 delete.
19:36:26,547 DEBUG DbSqlSession:430 - insert HistoricActivityInstanceEntity[activityId=usertask2, activityName=项目经理审批]
19:36:26,547 DEBUG DbSqlSession:430 - insert Task[id=802, name=项目经理审批]
19:36:26,547 DEBUG DbSqlSession:430 - insert org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@4bddef9a
19:36:26,547 DEBUG DbSqlSession:430 - insert IdentityLinkEntity[id=803, type=participant, userId=李四, processInstanceId=701]
19:36:26,548 DEBUG DbSqlSession:430 - insert org.activiti.engine.impl.persistence.entity.HistoricIdentityLinkEntity@579d8e5f
19:36:26,548 DEBUG DbSqlSession:433 - update HistoricActivityInstanceEntity[activityId=usertask1, activityName=??????]
19:36:26,548 DEBUG DbSqlSession:433 - update org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@28ee2be9
19:36:26,548 DEBUG DbSqlSession:433 - update ProcessInstance[701]
19:36:26,548 DEBUG DbSqlSession:436 - delete Task[id=704, name=??????]
19:36:26,548 DEBUG DbSqlSession:438 - now executing flush...
19:36:26,548 DEBUG DbSqlSession:537 - inserting: HistoricActivityInstanceEntity[activityId=usertask2, activityName=项目经理审批]
19:36:26,548 DEBUG insertHistoricActivityInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,549 DEBUG insertHistoricActivityInstance:132 - ==> Preparing: insert into ACT_HI_ACTINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, ACT_ID_, TASK_ID_, CALL_PROC_INST_ID_, ACT_NAME_, ACT_TYPE_, ASSIGNEE_, START_TIME_, END_TIME_, DURATION_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
19:36:26,550 DEBUG insertHistoricActivityInstance:132 - ==> Parameters: 801(String), qjlc:7:604(String), 701(String), 701(String), usertask2(String), 802(String), null, 项目经理审批(String), userTask(String), 李四(String), 2017-02-15 19:36:26.538(Timestamp), null, null
19:36:26,553 DEBUG DbSqlSession:537 - inserting: Task[id=802, name=项目经理审批]
19:36:26,554 DEBUG insertTask:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,554 DEBUG insertTask:132 - ==> Preparing: insert into ACT_RU_TASK (ID_, REV_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, PRIORITY_, CREATE_TIME_, OWNER_, ASSIGNEE_, DELEGATION_, EXECUTION_ID_, PROC_INST_ID_, PROC_DEF_ID_, TASK_DEF_KEY_, DUE_DATE_, SUSPENSION_STATE_) values (?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
19:36:26,555 DEBUG insertTask:132 - ==> Parameters: 802(String), 项目经理审批(String), null, null, 50(Integer), 2017-02-15 19:36:26.538(Timestamp), null, 李四(String), null, 701(String), 701(String), qjlc:7:604(String), usertask2(String), null, 1(Integer)
19:36:26,559 DEBUG DbSqlSession:537 - inserting: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@4bddef9a
19:36:26,560 DEBUG insertHistoricTaskInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,560 DEBUG insertHistoricTaskInstance:132 - ==> Preparing: insert into ACT_HI_TASKINST ( ID_, PROC_DEF_ID_, PROC_INST_ID_, EXECUTION_ID_, NAME_, PARENT_TASK_ID_, DESCRIPTION_, OWNER_, ASSIGNEE_, START_TIME_, CLAIM_TIME_, END_TIME_, DURATION_, DELETE_REASON_, TASK_DEF_KEY_, FORM_KEY_, PRIORITY_, DUE_DATE_ ) values ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
19:36:26,562 DEBUG insertHistoricTaskInstance:132 - ==> Parameters: 802(String), qjlc:7:604(String), 701(String), 701(String), 项目经理审批(String), null, null, null, 李四(String), 2017-02-15 19:36:26.538(Timestamp), null, null, null, null, usertask2(String), null, 50(Integer), null
19:36:26,565 DEBUG DbSqlSession:537 - inserting: IdentityLinkEntity[id=803, type=participant, userId=李四, processInstanceId=701]
19:36:26,565 DEBUG insertIdentityLink:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,566 DEBUG insertIdentityLink:132 - ==> Preparing: insert into ACT_RU_IDENTITYLINK (ID_, REV_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_, PROC_DEF_ID_) values (?, 1, ?, ?, ?, ?, ?, ?)
19:36:26,566 DEBUG insertIdentityLink:132 - ==> Parameters: 803(String), participant(String), 李四(String), null, null, 701(String), null
19:36:26,569 DEBUG DbSqlSession:537 - inserting: org.activiti.engine.impl.persistence.entity.HistoricIdentityLinkEntity@579d8e5f
19:36:26,569 DEBUG insertHistoricIdentityLink:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,569 DEBUG insertHistoricIdentityLink:132 - ==> Preparing: insert into ACT_HI_IDENTITYLINK (ID_, TYPE_, USER_ID_, GROUP_ID_, TASK_ID_, PROC_INST_ID_) values (?, ?, ?, ?, ?, ?)
19:36:26,570 DEBUG insertHistoricIdentityLink:132 - ==> Parameters: 803(String), participant(String), 李四(String), null, null, 701(String)
19:36:26,573 DEBUG DbSqlSession:557 - updating: HistoricActivityInstanceEntity[activityId=usertask1, activityName=??????]
19:36:26,573 DEBUG updateHistoricActivityInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,574 DEBUG updateHistoricActivityInstance:132 - ==> Preparing: update ACT_HI_ACTINST set EXECUTION_ID_ = ?, ASSIGNEE_ = ?, END_TIME_ = ?, DURATION_ = ? where ID_ = ?
19:36:26,575 DEBUG updateHistoricActivityInstance:132 - ==> Parameters: 701(String), ??(String), 2017-02-15 19:36:26.461(Timestamp), 4142461(Long), 703(String)
19:36:26,579 DEBUG DbSqlSession:557 - updating: org.activiti.engine.impl.persistence.entity.HistoricTaskInstanceEntity@28ee2be9
19:36:26,580 DEBUG updateHistoricTaskInstance:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,580 DEBUG updateHistoricTaskInstance:132 - ==> Preparing: update ACT_HI_TASKINST set EXECUTION_ID_ = ?, NAME_ = ?, PARENT_TASK_ID_ = ?, DESCRIPTION_ = ?, OWNER_ = ?, ASSIGNEE_ = ?, CLAIM_TIME_ = ?, END_TIME_ = ?, DURATION_ = ?, DELETE_REASON_ = ?, TASK_DEF_KEY_ = ?, FORM_KEY_ = ?, PRIORITY_ = ?, DUE_DATE_ = ? where ID_ = ?
19:36:26,581 DEBUG updateHistoricTaskInstance:132 - ==> Parameters: 701(String), ??????(String), null, null, null, ??(String), null, 2017-02-15 19:36:26.396(Timestamp), 4142396(Long), completed(String), usertask1(String), null, 50(Integer), null, 704(String)
19:36:26,585 DEBUG DbSqlSession:557 - updating: ProcessInstance[701]
19:36:26,586 DEBUG updateExecution:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,586 DEBUG updateExecution:132 - ==> Preparing: update ACT_RU_EXECUTION set REV_ = ?, PROC_DEF_ID_ = ?, ACT_ID_ = ?, IS_ACTIVE_ = ?, IS_CONCURRENT_ = ?, IS_SCOPE_ = ?, IS_EVENT_SCOPE_ = ?, PARENT_ID_ = ?, SUPER_EXEC_ = ?, SUSPENSION_STATE_ = ?, CACHED_ENT_STATE_ = ? where ID_ = ? and REV_ = ?
19:36:26,586 DEBUG updateExecution:132 - ==> Parameters: 2(Integer), qjlc:7:604(String), usertask2(String), true(Boolean), false(Boolean), true(Boolean), false(Boolean), null, null, 1(Integer), 2(Integer), 701(String), 1(Integer)
19:36:26,657 DEBUG DbSqlSession:574 - executing: delete Task[id=704, name=??????]
19:36:26,657 DEBUG deleteTask:132 - ooo Using Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,657 DEBUG deleteTask:132 - ==> Preparing: delete from ACT_RU_TASK where ID_ = ? and REV_ = ?
19:36:26,658 DEBUG deleteTask:132 - ==> Parameters: 704(String), 1(Integer)
19:36:26,673 DEBUG StandaloneMybatisTransactionContext:56 - firing event committing...
19:36:26,674 DEBUG StandaloneMybatisTransactionContext:58 - committing the ibatis sql session...
19:36:26,674 DEBUG JdbcTransaction:66 - Committing JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,700 DEBUG StandaloneMybatisTransactionContext:60 - firing event committed...
19:36:26,700 DEBUG JdbcTransaction:117 - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,702 DEBUG JdbcTransaction:85 - Closing JDBC Connection [com.mysql.jdbc.Connection@96932af]
19:36:26,703 DEBUG PooledDataSource:332 - Returned connection 157889199 to pool.
19:36:26,703 DEBUG LogInterceptor:40 - --- CompleteTaskCmd finished --------------------------------------------------------
19:36:26,703 DEBUG LogInterceptor:41 -