Springboot2.6.13整合flowable6.8.1

打印 上一主题 下一主题

主题 1040|帖子 1040|积分 3120

马上注册,结交更多好友,享用更多功能,让你轻松玩转社区。

您需要 登录 才可以下载或查看,没有账号?立即注册

x
配景

  项目上需要使用到工作流相关内容,比对了好久采用flowable实现,该插件和activiti等很相似,根本上可以直接移植
    代码如下

  1. <!--    父引用用-->
  2.    <parent>
  3.         <groupId>org.springframework.boot</groupId>
  4.         <artifactId>spring-boot-starter-parent</artifactId>
  5.         <version>2.6.13</version>
  6.         <relativePath/>
  7.     </parent>
复制代码
  1. <!-- 依赖包 -->
  2. <properties>
  3.    <flowable.version>6.8.1</flowable.version>
  4. </properties>
  5. <dependencies>
  6.         <dependency>
  7.             <groupId>org.flowable</groupId>
  8.             <artifactId>flowable-spring-boot-starter</artifactId>
  9.             <version>${flowable.version}</version>
  10.         </dependency>
  11.         <dependency>
  12.             <groupId>org.flowable</groupId>
  13.             <artifactId>flowable-spring-boot-starter-ui-modeler</artifactId>
  14.             <version>${flowable.version}</version>
  15.         </dependency>
  16.         <!-- Flowable 核心模块 -->
  17.         <dependency>
  18.             <groupId>org.flowable</groupId>
  19.             <artifactId>flowable-engine</artifactId>
  20.             <version>${flowable.version}</version>
  21.         </dependency>
  22.         <dependency>
  23.             <groupId>org.flowable</groupId>
  24.             <artifactId>flowable-spring-boot-starter-ui-admin</artifactId>
  25.             <version>${flowable.version}</version>
  26.         </dependency>
  27.         <dependency>
  28.             <groupId>org.flowable</groupId>
  29.             <artifactId>flowable-spring-boot-starter-ui-idm</artifactId>
  30.             <version>${flowable.version}</version>
  31.         </dependency>
  32.         <!-- thymeleaf架包 -->
  33.         <dependency>
  34.             <groupId>org.springframework.boot</groupId>
  35.             <artifactId>spring-boot-starter-thymeleaf</artifactId>
  36.         </dependency>
  37.         <dependency>
  38.             <groupId>org.flowable</groupId>
  39.             <artifactId>flowable-spring-boot-starter-ui-task</artifactId>
  40.             <version>${flowable.version}</version>
  41.         </dependency>
  42. </dependencies>
复制代码
   配置文件 application-dev.yml
  1. spring:
  2.   application:
  3.     name: flowable-service
  4.   main:
  5.     allow-circular-references: true
  6.   auto-config:
  7.     swagger2: enable
  8.   datasource:
  9.     driver-class-name: com.mysql.cj.jdbc.Driver
  10.     url: jdbc:mysql://192.167.116.28:3306/z_flow?useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai&nullCatalogMeansCurrent=true
  11.     username: root
  12.     password: root
  13.     hikari:
  14.       pool-name: coreHikariPool
  15.       maximum-pool-size: 100
  16.       connection-timeout: 30000
  17.       minimum-idle: 62
  18.       idle-timeout: 500000
  19.       max-lifetime: 3600000
  20.       connection-test-query: SELECT 1
  21.       auto-commit: true
  22. flowable:
  23.   #异步执行
  24.   async-executor-activate: true
  25.   #自动更新数据库
  26.   database-schema-update: true
  27.   #校验流程文件,默认校验resources下的processes文件夹里的流程文件
  28.   process-definition-location-prefix: classpath*:/processes/
  29.   process-definition-location-suffixes: "**.bpmn20.xml, **.bpmn"
  30.   #该配置只是防止页面报错,没有实际意义
  31.   common:
  32.     app:
  33.       idm-admin:
  34.         password: test
  35.         user: test
  36.       #没有实际意义
  37.       idm-url: http://localhost:8080/flowable-demo
复制代码
  在resources中新建processes文件夹,内部的xml文件会被flowable识别,并主动发布流程实例 
  新建request.bpmn20.xml文件
  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <definitions xmlns="http://www.omg.org/spec/BPMN/20100524/MODEL" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  3.              xmlns:flowable="http://flowable.org/bpmn"
  4.              typeLanguage="http://www.w3.org/2001/XMLSchema" expressionLanguage="http://www.w3.org/1999/XPath"
  5.              targetNamespace="http://www.flowable.org/processdef">
  6.     <!-- -请假条流程图 -->
  7.     <process id="vacationRequest" name="请假条流程" isExecutable="true">
  8.         <!-- -流程的开始 -->
  9.         <startEvent id="startEvent"/>
  10.         <sequenceFlow sourceRef="startEvent" targetRef="approveTask"/>
  11.         <!-- -流程的节点 -->
  12.         <userTask id="approveTask" name="开始请假" flowable:candidateGroups="managers"/>
  13.         <!-- -流程节点间的线条,上一个节点和下一个节点-->
  14.         <sequenceFlow sourceRef="approveTask" targetRef="decision"/>
  15.         <!-- -排他性网关 -->
  16.         <exclusiveGateway id="decision"/>
  17.         <!-- -同意时 -->
  18.         <sequenceFlow sourceRef="decision" targetRef="holidayApprovedTask">
  19.             <conditionExpression xsi:type="tFormalExpression">
  20.                 <![CDATA[${approved}]]>
  21.             </conditionExpression>
  22.         </sequenceFlow>
  23.         <!-- -拒绝时 -->
  24.         <sequenceFlow sourceRef="decision" targetRef="rejectEnd">
  25.             <conditionExpression xsi:type="tFormalExpression">
  26.                 <![CDATA[${!approved}]]>
  27.             </conditionExpression>
  28.         </sequenceFlow>
  29.         <!-- -外部服务 -->
  30.         <!-- <serviceTask id="externalSystemCall" name="Enter holidays in external system"
  31.                      flowable:class="org.javaboy.flowable02.flowable.Approve"/>
  32.         <sequenceFlow sourceRef="externalSystemCall" targetRef="holidayApprovedTask"/> -->
  33.         <userTask id="holidayApprovedTask" flowable:assignee="${employee}" name="同意请假"/>
  34.         <sequenceFlow sourceRef="holidayApprovedTask" targetRef="approveEnd"/>
  35.         <!-- <serviceTask id="rejectLeave" name="Send out rejection email"
  36.                      flowable:class="org.javaboy.flowable02.flowable.Reject"/>
  37.         <sequenceFlow sourceRef="rejectLeave" targetRef="rejectEnd"/> -->
  38.         <endEvent id="approveEnd"/>
  39.         <endEvent id="rejectEnd"/>
  40.         <!-- -流程的结束 -->
  41.     </process>
  42. </definitions>
复制代码
   使用Springboot的启动类启动即可
    常见问题: 

   

  •  出现表格不存在报错
       原因:a)大概没有配置主动更新数据库

                     b) 设置为只查当前连接的schema库即可
                         (由于当前连接大概已经创建过工作流表)
                         nullCatalogMeansCurrent=true
  1. 2024-07-30 20:19:52.432 ERROR 21708 --- [           main] o.f.c.e.impl.interceptor.CommandContext  : Error while closing command context
  2. org.apache.ibatis.exceptions.PersistenceException:
  3. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  4. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  5. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  6. ### The error occurred while setting parameters
  7. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  8. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  9.         at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.10.jar:3.5.10]
  10.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153) ~[mybatis-3.5.10.jar:3.5.10]
  11.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) ~[mybatis-3.5.10.jar:3.5.10]
  12.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.10.jar:3.5.10]
  13.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~[mybatis-3.5.10.jar:3.5.10]
  14.         at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:311) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  15.         at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:295) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  16.         at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:217) ~[flowable-engine-6.8.1.jar:6.8.1]
  17.         at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54) ~[flowable-engine-6.8.1.jar:6.8.1]
  18.         at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28) ~[flowable-engine-6.8.1.jar:6.8.1]
  19.         at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:67) ~[flowable-engine-6.8.1.jar:6.8.1]
  20.         at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:140) ~[flowable-engine-6.8.1.jar:6.8.1]
  21.         at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:114) ~[flowable-engine-6.8.1.jar:6.8.1]
  22.         at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:72) ~[flowable-engine-6.8.1.jar:6.8.1]
  23.         at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:26) ~[flowable-engine-6.8.1.jar:6.8.1]
  24.         at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  25.         at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  26.         at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.8.1.jar:6.8.1]
  27.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.23.jar:5.3.23]
  28.         at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.8.1.jar:6.8.1]
  29.         at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  30.         at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  31.         at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:83) ~[flowable-engine-6.8.1.jar:6.8.1]
  32.         at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:916) ~[flowable-engine-6.8.1.jar:6.8.1]
  33.         at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:76) ~[flowable-spring-6.8.1.jar:6.8.1]
  34.         at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.initProcessEngine(SpringProcessEngineConfigurator.java:58) ~[flowable-spring-configurator-6.8.1.jar:6.8.1]
  35.         at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.configure(SpringProcessEngineConfigurator.java:47) ~[flowable-spring-configurator-6.8.1.jar:6.8.1]
  36.         at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1120) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  37.         at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:237) ~[flowable-app-engine-6.8.1.jar:6.8.1]
  38.         at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:193) ~[flowable-app-engine-6.8.1.jar:6.8.1]
  39.         at org.flowable.app.spring.SpringAppEngineConfiguration.buildAppEngine(SpringAppEngineConfiguration.java:66) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  40.         at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:58) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  41.         at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:31) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  42.         at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:169) ~[spring-beans-5.3.23.jar:5.3.23]
  43.         at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) ~[spring-beans-5.3.23.jar:5.3.23]
  44.         at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1884) ~[spring-beans-5.3.23.jar:5.3.23]
  45.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1284) ~[spring-beans-5.3.23.jar:5.3.23]
  46.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:345) ~[spring-beans-5.3.23.jar:5.3.23]
  47.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  48.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  49.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  50.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  51.         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.23.jar:5.3.23]
  52.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.23.jar:5.3.23]
  53.         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.23.jar:5.3.23]
  54.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.23.jar:5.3.23]
  55.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.23.jar:5.3.23]
  56.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.23.jar:5.3.23]
  57.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  58.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  59.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  60.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  61.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  62.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  63.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  64.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  65.         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.23.jar:5.3.23]
  66.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.23.jar:5.3.23]
  67.         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.23.jar:5.3.23]
  68.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.23.jar:5.3.23]
  69.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.23.jar:5.3.23]
  70.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.23.jar:5.3.23]
  71.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  72.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  73.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  74.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  75.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  76.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  77.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  78.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  79.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:544) ~[spring-context-5.3.23.jar:5.3.23]
  80.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:520) ~[spring-context-5.3.23.jar:5.3.23]
  81.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:673) ~[spring-context-5.3.23.jar:5.3.23]
  82.         at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:228) ~[spring-beans-5.3.23.jar:5.3.23]
  83.         at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.23.jar:5.3.23]
  84.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:329) ~[spring-context-5.3.23.jar:5.3.23]
  85.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.23.jar:5.3.23]
  86.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.23.jar:5.3.23]
  87.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  88.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  89.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  90.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  91.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  92.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  93.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  94.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  95.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:544) ~[spring-context-5.3.23.jar:5.3.23]
  96.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:520) ~[spring-context-5.3.23.jar:5.3.23]
  97.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:673) ~[spring-context-5.3.23.jar:5.3.23]
  98.         at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:228) ~[spring-beans-5.3.23.jar:5.3.23]
  99.         at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.23.jar:5.3.23]
  100.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:329) ~[spring-context-5.3.23.jar:5.3.23]
  101.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.23.jar:5.3.23]
  102.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.23.jar:5.3.23]
  103.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  104.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  105.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  106.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  107.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  108.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) ~[spring-beans-5.3.23.jar:5.3.23]
  109.         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.23.jar:5.3.23]
  110.         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.23.jar:5.3.23]
  111.         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.13.jar:2.6.13]
  112.         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) ~[spring-boot-2.6.13.jar:2.6.13]
  113.         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) ~[spring-boot-2.6.13.jar:2.6.13]
  114.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) ~[spring-boot-2.6.13.jar:2.6.13]
  115.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) ~[spring-boot-2.6.13.jar:2.6.13]
  116.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.6.13.jar:2.6.13]
  117.         at com.aimsphm.flow.App.main(App.java:12) ~[classes/:na]
  118. Caused by: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  119.         at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  120.         at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  121.         at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  122.         at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  123.         at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-4.0.3.jar:na]
  124.         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
  125.         at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.10.jar:3.5.10]
  126.         at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.10.jar:3.5.10]
  127.         at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.10.jar:3.5.10]
  128.         at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.10.jar:3.5.10]
  129.         at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.10.jar:3.5.10]
  130.         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.10.jar:3.5.10]
  131.         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) ~[mybatis-3.5.10.jar:3.5.10]
  132.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) ~[mybatis-3.5.10.jar:3.5.10]
  133.         ... 107 common frames omitted
  134. 2024-07-30 20:19:52.445  WARN 21708 --- [           main] ConfigServletWebServerApplicationContext : Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableController': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  135. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  136. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  137. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  138. ### The error occurred while setting parameters
  139. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  140. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  141. 2024-07-30 20:19:52.450  INFO 21708 --- [           main] com.zaxxer.hikari.HikariDataSource       : coreHikariPool - Shutdown initiated...
  142. 2024-07-30 20:19:52.485  INFO 21708 --- [           main] com.zaxxer.hikari.HikariDataSource       : coreHikariPool - Shutdown completed.
  143. 2024-07-30 20:19:52.489  INFO 21708 --- [           main] o.apache.catalina.core.StandardService   : Stopping service [Tomcat]
  144. 2024-07-30 20:19:52.505  INFO 21708 --- [           main] ConditionEvaluationReportLoggingListener :
  145. Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
  146. 2024-07-30 20:19:52.559 ERROR 21708 --- [           main] o.s.boot.SpringApplication               : Application run failed
  147. org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableController': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  148. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  149. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  150. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  151. ### The error occurred while setting parameters
  152. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  153. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  154.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:332) ~[spring-context-5.3.23.jar:5.3.23]
  155.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.23.jar:5.3.23]
  156.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.23.jar:5.3.23]
  157.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  158.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  159.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  160.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  161.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  162.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:955) ~[spring-beans-5.3.23.jar:5.3.23]
  163.         at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918) ~[spring-context-5.3.23.jar:5.3.23]
  164.         at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583) ~[spring-context-5.3.23.jar:5.3.23]
  165.         at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:145) ~[spring-boot-2.6.13.jar:2.6.13]
  166.         at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:745) ~[spring-boot-2.6.13.jar:2.6.13]
  167.         at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:420) ~[spring-boot-2.6.13.jar:2.6.13]
  168.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:307) ~[spring-boot-2.6.13.jar:2.6.13]
  169.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:1317) ~[spring-boot-2.6.13.jar:2.6.13]
  170.         at org.springframework.boot.SpringApplication.run(SpringApplication.java:1306) ~[spring-boot-2.6.13.jar:2.6.13]
  171.         at com.aimsphm.flow.App.main(App.java:12) ~[classes/:na]
  172. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowServiceImpl': Injection of resource dependencies failed; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  173. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  174. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  175. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  176. ### The error occurred while setting parameters
  177. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  178. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  179.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:332) ~[spring-context-5.3.23.jar:5.3.23]
  180.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1431) ~[spring-beans-5.3.23.jar:5.3.23]
  181.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:619) ~[spring-beans-5.3.23.jar:5.3.23]
  182.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  183.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  184.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  185.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  186.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  187.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  188.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  189.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  190.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:544) ~[spring-context-5.3.23.jar:5.3.23]
  191.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:520) ~[spring-context-5.3.23.jar:5.3.23]
  192.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:673) ~[spring-context-5.3.23.jar:5.3.23]
  193.         at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:228) ~[spring-beans-5.3.23.jar:5.3.23]
  194.         at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.23.jar:5.3.23]
  195.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:329) ~[spring-context-5.3.23.jar:5.3.23]
  196.         ... 17 common frames omitted
  197. Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'repositoryServiceBean' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration.class]: Unsatisfied dependency expressed through method 'repositoryServiceBean' parameter 0; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  198. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  199. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  200. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  201. ### The error occurred while setting parameters
  202. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  203. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  204.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.23.jar:5.3.23]
  205.         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.23.jar:5.3.23]
  206.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.23.jar:5.3.23]
  207.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.23.jar:5.3.23]
  208.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.23.jar:5.3.23]
  209.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  210.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  211.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  212.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  213.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  214.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  215.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  216.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  217.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:544) ~[spring-context-5.3.23.jar:5.3.23]
  218.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:520) ~[spring-context-5.3.23.jar:5.3.23]
  219.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:673) ~[spring-context-5.3.23.jar:5.3.23]
  220.         at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:228) ~[spring-beans-5.3.23.jar:5.3.23]
  221.         at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:119) ~[spring-beans-5.3.23.jar:5.3.23]
  222.         at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:329) ~[spring-context-5.3.23.jar:5.3.23]
  223.         ... 33 common frames omitted
  224. Caused by: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'processEngine' defined in class path resource [org/flowable/spring/boot/ProcessEngineServicesAutoConfiguration$AlreadyInitializedAppEngineConfiguration.class]: Unsatisfied dependency expressed through method 'processEngine' parameter 0; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  225. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  226. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  227. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  228. ### The error occurred while setting parameters
  229. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  230. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  231.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:800) ~[spring-beans-5.3.23.jar:5.3.23]
  232.         at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:541) ~[spring-beans-5.3.23.jar:5.3.23]
  233.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) ~[spring-beans-5.3.23.jar:5.3.23]
  234.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) ~[spring-beans-5.3.23.jar:5.3.23]
  235.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) ~[spring-beans-5.3.23.jar:5.3.23]
  236.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) ~[spring-beans-5.3.23.jar:5.3.23]
  237.         at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.23.jar:5.3.23]
  238.         at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) ~[spring-beans-5.3.23.jar:5.3.23]
  239.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) ~[spring-beans-5.3.23.jar:5.3.23]
  240.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  241.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  242.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  243.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  244.         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.23.jar:5.3.23]
  245.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.23.jar:5.3.23]
  246.         ... 51 common frames omitted
  247. Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flowableAppEngine': FactoryBean threw exception on object creation; nested exception is org.apache.ibatis.exceptions.PersistenceException:
  248. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  249. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  250. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  251. ### The error occurred while setting parameters
  252. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  253. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  254.         at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:176) ~[spring-beans-5.3.23.jar:5.3.23]
  255.         at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:101) ~[spring-beans-5.3.23.jar:5.3.23]
  256.         at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1884) ~[spring-beans-5.3.23.jar:5.3.23]
  257.         at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.getObjectForBeanInstance(AbstractAutowireCapableBeanFactory.java:1284) ~[spring-beans-5.3.23.jar:5.3.23]
  258.         at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:345) ~[spring-beans-5.3.23.jar:5.3.23]
  259.         at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) ~[spring-beans-5.3.23.jar:5.3.23]
  260.         at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.3.23.jar:5.3.23]
  261.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1391) ~[spring-beans-5.3.23.jar:5.3.23]
  262.         at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1311) ~[spring-beans-5.3.23.jar:5.3.23]
  263.         at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:887) ~[spring-beans-5.3.23.jar:5.3.23]
  264.         at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:791) ~[spring-beans-5.3.23.jar:5.3.23]
  265.         ... 65 common frames omitted
  266. Caused by: org.apache.ibatis.exceptions.PersistenceException:
  267. ### Error querying database.  Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  268. ### The error may exist in org/flowable/common/db/mapping/entity/Property.xml
  269. ### The error may involve org.flowable.common.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline
  270. ### The error occurred while setting parameters
  271. ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
  272. ### Cause: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  273.         at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.5.10.jar:3.5.10]
  274.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:153) ~[mybatis-3.5.10.jar:3.5.10]
  275.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:145) ~[mybatis-3.5.10.jar:3.5.10]
  276.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140) ~[mybatis-3.5.10.jar:3.5.10]
  277.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:76) ~[mybatis-3.5.10.jar:3.5.10]
  278.         at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:311) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  279.         at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:295) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  280.         at org.flowable.engine.impl.db.ProcessDbSchemaManager.schemaUpdate(ProcessDbSchemaManager.java:217) ~[flowable-engine-6.8.1.jar:6.8.1]
  281.         at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:54) ~[flowable-engine-6.8.1.jar:6.8.1]
  282.         at org.flowable.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:28) ~[flowable-engine-6.8.1.jar:6.8.1]
  283.         at org.flowable.engine.impl.interceptor.CommandInvoker$1.run(CommandInvoker.java:67) ~[flowable-engine-6.8.1.jar:6.8.1]
  284.         at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperation(CommandInvoker.java:140) ~[flowable-engine-6.8.1.jar:6.8.1]
  285.         at org.flowable.engine.impl.interceptor.CommandInvoker.executeOperations(CommandInvoker.java:114) ~[flowable-engine-6.8.1.jar:6.8.1]
  286.         at org.flowable.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:72) ~[flowable-engine-6.8.1.jar:6.8.1]
  287.         at org.flowable.engine.impl.interceptor.BpmnOverrideContextInterceptor.execute(BpmnOverrideContextInterceptor.java:26) ~[flowable-engine-6.8.1.jar:6.8.1]
  288.         at org.flowable.common.engine.impl.interceptor.TransactionContextInterceptor.execute(TransactionContextInterceptor.java:53) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  289.         at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:105) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  290.         at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.8.1.jar:6.8.1]
  291.         at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) ~[spring-tx-5.3.23.jar:5.3.23]
  292.         at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) ~[flowable-spring-common-6.8.1.jar:6.8.1]
  293.         at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  294.         at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  295.         at org.flowable.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:83) ~[flowable-engine-6.8.1.jar:6.8.1]
  296.         at org.flowable.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:916) ~[flowable-engine-6.8.1.jar:6.8.1]
  297.         at org.flowable.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:76) ~[flowable-spring-6.8.1.jar:6.8.1]
  298.         at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.initProcessEngine(SpringProcessEngineConfigurator.java:58) ~[flowable-spring-configurator-6.8.1.jar:6.8.1]
  299.         at org.flowable.engine.spring.configurator.SpringProcessEngineConfigurator.configure(SpringProcessEngineConfigurator.java:47) ~[flowable-spring-configurator-6.8.1.jar:6.8.1]
  300.         at org.flowable.common.engine.impl.AbstractEngineConfiguration.configuratorsAfterInit(AbstractEngineConfiguration.java:1120) ~[flowable-engine-common-6.8.1.jar:6.8.1]
  301.         at org.flowable.app.engine.AppEngineConfiguration.init(AppEngineConfiguration.java:237) ~[flowable-app-engine-6.8.1.jar:6.8.1]
  302.         at org.flowable.app.engine.AppEngineConfiguration.buildAppEngine(AppEngineConfiguration.java:193) ~[flowable-app-engine-6.8.1.jar:6.8.1]
  303.         at org.flowable.app.spring.SpringAppEngineConfiguration.buildAppEngine(SpringAppEngineConfiguration.java:66) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  304.         at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:58) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  305.         at org.flowable.app.spring.AppEngineFactoryBean.getObject(AppEngineFactoryBean.java:31) ~[flowable-app-engine-spring-6.8.1.jar:6.8.1]
  306.         at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:169) ~[spring-beans-5.3.23.jar:5.3.23]
  307.         ... 75 common frames omitted
  308. Caused by: java.sql.SQLSyntaxErrorException: Table 'z_flow.ACT_GE_PROPERTY' doesn't exist
  309.         at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  310.         at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  311.         at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  312.         at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) ~[mysql-connector-j-8.0.31.jar:8.0.31]
  313.         at com.zaxxer.hikari.pool.ProxyPreparedStatement.execute(ProxyPreparedStatement.java:44) ~[HikariCP-4.0.3.jar:na]
  314.         at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.execute(HikariProxyPreparedStatement.java) ~[HikariCP-4.0.3.jar:na]
  315.         at org.apache.ibatis.executor.statement.PreparedStatementHandler.query(PreparedStatementHandler.java:64) ~[mybatis-3.5.10.jar:3.5.10]
  316.         at org.apache.ibatis.executor.statement.RoutingStatementHandler.query(RoutingStatementHandler.java:79) ~[mybatis-3.5.10.jar:3.5.10]
  317.         at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:63) ~[mybatis-3.5.10.jar:3.5.10]
  318.         at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:325) ~[mybatis-3.5.10.jar:3.5.10]
  319.         at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156) ~[mybatis-3.5.10.jar:3.5.10]
  320.         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:109) ~[mybatis-3.5.10.jar:3.5.10]
  321.         at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:89) ~[mybatis-3.5.10.jar:3.5.10]
  322.         at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:151) ~[mybatis-3.5.10.jar:3.5.10]
  323.         ... 107 common frames omitted
  324. Disconnected from the target VM, address: '127.0.0.1:55581', transport: 'socket'
  325. Process finished with exit code 1
复制代码
  正常启动会创建下列表格
  
 
   表格形貌如下 

  
表分类表名表阐明
一样平常数据(2)ACT_GE_BYTEARRAY通用的流程定义和流程资源
ACT_GE_PROPERTY体系相关属性
流程汗青记录(8)ACT_HI_ACTINST汗青的流程实例
ACT_HI_ATTACHMENT汗青的流程附件
ACT_HI_COMMENT汗青的阐明性信息
ACT_HI_DETAIL汗青的流程运行中的细节信息
ACT_HI_IDENTITYLINK汗青的流程运行过程中用户关系
ACT_HI_PROCINST汗青的流程实例
ACT_HI_TASKINST汗青的任务实例
ACT_HI_VARINST汗青的流程运行中的变量信息
用户用户组表(9)ACT_ID_BYTEARRAY二进制数据表
ACT_ID_GROUP用户组信息表
ACT_ID_INFO用户信息详情表
ACT_ID_MEMBERSHIP人与组关系表
ACT_ID_PRIV权限表
ACT_ID_PRIV_MAPPING用户或组权限关系表
ACT_ID_PROPERTY属性表
ACT_ID_TOKEN体系登录日志表
ACT_ID_USER用户表
流程定义表(3)ACT_RE_MODEL模型信息
ACT_RE_DEPLOYMENT摆设单元信息
ACT_RE_PROCDEF已摆设的流程定义
运行实例表(10)ACT_RU_DEADLETTER_JOB正在运行的任务表
ACT_RU_EVENT_SUBSCR运行时事件
ACT_RU_EXECUTION运行时流程执行实例
ACT_RU_HISTORY_JOB汗青作业表
ACT_RU_IDENTITYLINK运行时用户关系信息
ACT_RU_JOB运行时作业表
ACT_RU_SUSPENDED_JOB暂停作业表
ACT_RU_TASK运行时任务表
ACT_RU_TIMER_JOB定时作业表
ACT_RU_VARIABLE运行时变量表
其他表(2)ACT_EVT_LOG事件日志表
ACT_PROCDEF_INFO流程定义信息
    相关API简要阐明

    1.FormService

  表单数据的管理; 是可选服务,也就是说Flowable没有它也能很好地运行,而不必捐躯任何功能。这个服务引入了开始表单(start form)与任务表单(task form)的概念。 开始表单是在流程实例启动前体现的表单,
  而任务表单是用户完成任务时体现的表单。Flowable可以在BPMN 2.0流程定义中定义这些表单。表单服务通过简朴的方式袒露这些数据。再次重申,表单不肯定要嵌入流程定义,因此这个服务是可选的
  1. formService.getStartFormKey() // 获取表单key
  2. formService.getRenderedStartForm()  // 查询表单json(无数据)
复制代码
  2.RepositiryService

  提供了在编辑和发布审批流程的api。紧张是模型管理和流程定义的业务api
  这个服务提供了管理与控制摆设(deployments)与流程定义(process definitions)的操作
  查询引擎现有的摆设与流程定义。 暂停或激活摆设中的某些流程,或整个摆设。暂停意味着不能再对它进行操作,激活刚好相反,重新使它可以操作。 获取各种资源,比如摆设中保存的文件,
  大概引擎主动天生的流程图。 获取POJO版本的流程定义。它可以用Java而不是XML的方式查看流程。
  1. ## 1.提供了带条件的查询模型流程定义的api
  2. repositoryService.createXXXQuery()
  3. ## 例如:
  4. repositoryService.createModelQuery().list() 模型查询
  5. repositoryService.createProcessDefinitionQuery().list() 流程定义查询
  6. repositoryService.createXXXXQuery().XXXKey(XXX) (查询该key是否存在)
  7. ## 2.提供一大波模型与流程定义的通用方法
  8. 模型相关
  9. repositoryService.getModel()  (获取模型)
  10. repositoryService.saveModel()  (保存模型)
  11. repositoryService.deleteModel() (删除模型)
  12. repositoryService.createDeployment().deploy(); (部署模型)
  13. repositoryService.getModelEditorSource()  (获得模型JSON数据的UTF8字符串)
  14. repositoryService.getModelEditorSourceExtra()  (获取PNG格式图像)
  15. ## 3.流程定义相关
  16. repositoryService.getProcessDefinition(ProcessDefinitionId);  获取流程定义具体信息
  17. repositoryService.activateProcessDefinitionById() 激活流程定义
  18. repositoryService.suspendProcessDefinitionById()  挂起流程定义
  19. repositoryService.deleteDeployment()  删除流程定义
  20. repositoryService.getProcessDiagram()获取流程定义图片流
  21. repositoryService.getResourceAsStream()获取流程定义xml流
  22. repositoryService.getBpmnModel(pde.getId()) 获取bpmn对象(当前进行到的那个节点的流程图使用)
  23. ## 4.流程定义授权相关
  24. repositoryService.getIdentityLinksForProcessDefinition() 流程定义授权列表
  25. repositoryService.addCandidateStarterGroup()新增组流程授权
  26. repositoryService.addCandidateStarterUser()新增用户流程授权
  27. repositoryService.deleteCandidateStarterGroup() 删除组流程授权
  28. repositoryService.deleteCandidateStarterUser()  删除用户流程授权
复制代码
  3.RuntimeService

  处理正在运行的流程
  1. runtimeService.createProcessInstanceBuilder().start() 发起流程
  2. runtimeService.deleteProcessInstance() 删除正在运行的流程
  3. runtimeService.suspendProcessInstanceById() 挂起流程定义
  4. runtimeService.activateProcessInstanceById() 激活流程实例
  5. runtimeService.getVariables(processInstanceId); 获取表单中填写的值
  6. runtimeService.getActiveActivityIds(processInstanceId)获取以进行的流程图节点 (当前进行到的那个节点的流程图使用)
  7. runtimeService.createChangeActivityStateBuilder().moveExecutionsToSingleActivityId(executionIds, endId).changeState(); 终止流程
复制代码
  4.HistoryService

  在用户发起审批后,会天生流程实例。historyService为处理流程实例的api,但是其中包罗了已完成的和未完成的流程实例; 假如是处理正在运行的流程实例,请使用runtimeService;
  袒露Flowable引擎收集的全部汗青数据。当执行流程时,引擎会保存很多数据(可配置),例如流程实例启动时间、谁在执行哪个任务、完成任务淹灭的事件、每个流程实例的执行路径,等等。这个服务紧张提供查询这些数据的能力
  1. historyService.createHistoricProcessInstanceQuery().list() 查询流程实例列表(历史流程,包括未完成的)
  2. historyService.createHistoricProcessInstanceQuery().list().foreach().getValue() 可以获取历史中表单的信息
  3. historyService.createHistoricProcessInstanceQuery().processInstanceId(processInstanceId).singleResult(); 根绝id查询流程实例
  4. historyService.deleteHistoricProcessInstance() 删除历史流程
  5. historyService.deleteHistoricTaskInstance(taskid); 删除任务实例
  6. historyService.createHistoricActivityInstanceQuery().processInstanceId(processInstanceId).list()  流程实例节点列表 (当前进行到的那个节点的流程图使用)
  7.    
  8. flowable 有api查看act_hi_varinst里面的数据吗
  9. historyService.createHistoricVariableInstanceQuery().processInstanceId(instance.getId())
复制代码
  5.TaskService

  对流程实例的各个节点的审批处理
  流转的节点审批
  1. taskService.createTaskQuery().list() 待办任务列表
  2. taskService.createTaskQuery().taskId(taskId).singleResult();  待办任务详情
  3. taskService.saveTask(task); 修改任务
  4. taskService.setAssignee() 设置审批人
  5. taskService.addComment() 设置审批备注
  6. taskService.complete() 完成当前审批
  7. taskService.getProcessInstanceComments(processInstanceId); 查看任务详情(也就是都经过哪些人的审批,意见是什么)
  8. taskService.delegateTask(taskId, delegater); 委派任务
  9. taskService.claim(taskId, userId);认领任务
  10. taskService.unclaim(taskId); 取消认领
  11. taskService.complete(taskId, completeVariables); 完成任务
  12. 任务授权
  13. taskService.addGroupIdentityLink()新增组任务授权
  14. taskService.addUserIdentityLink() 新增人员任务授权
  15. taskService.deleteGroupIdentityLink() 删除组任务授权
  16. taskService.deleteUserIdentityLink() 删除人员任务授权
复制代码
  6.ManagementService

  紧张是执行自定义命令
  1. managementService.executeCommand(new classA())  执行classA的内部方法
  2. 在自定义的方法中可以使用以下方法获取repositoryService
  3. ProcessEngineConfiguration processEngineConfiguration =
  4.             CommandContextUtil.getProcessEngineConfiguration(commandContext);
  5. RepositoryService repositoryService = processEngineConfiguration.getRepositoryService();
  6. 也可以获得流程定义方法集合
  7. ProcessEngineConfigurationImpl processEngineConfiguration =
  8.             CommandContextUtil.getProcessEngineConfiguration(commandContext);
  9.         ProcessDefinitionEntityManager processDefinitionEntityManager =
  10.             processEngineConfiguration.getProcessDefinitionEntityManager();
  11. 如 findById/findLatestProcessDefinitionByKey/findLatestProcessDefinitionByKeyAndTenantId 等。
复制代码
  7.IdentityService

  用于身份信息获取和保存,这里紧张是获取身份信息
  用于管理(创建,更新,删除,查询……)组与用户。请注意,Flowable现实上在运行时并不做任何用户检查。
  例如任务可以分派给任何用户,而引擎并不会验证体系中是否存在该用户。这是由于Flowable有时要与LDAP、Active Directory等服务结合使用
  1. identityService.createUserQuery().userId(userId).singleResult();  获取审批用户的具体信息
  2. identityService.createGroupQuery().groupId(groupId).singleResult(); 获取审批组的具体信息
复制代码
  8.DynamicBpmnService

  可用于修改流程定义中的部分内容,而不需要重新摆设它。例如可以修改流程定义中一个用户任务的办理人设置,大概修改一个服务任务中的类名。
   

免责声明:如果侵犯了您的权益,请联系站长,我们会及时删除侵权内容,谢谢合作!更多信息从访问主页:qidao123.com:ToB企服之家,中国第一个企服评测及商务社交产业平台。
回复

使用道具 举报

0 个回复

倒序浏览

快速回复

您需要登录后才可以回帖 登录 or 立即注册

本版积分规则

汕尾海湾

论坛元老
这个人很懒什么都没写!
快速回复 返回顶部 返回列表