1. 初始化数据库

测试代码：

  1. package com.demo.activiti7;
  3. import org.activiti.engine.ProcessEngineConfiguration;
  4. import org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl;
  5. import org.activiti.engine.impl.db.DbSchemaCreate;
  6. import org.activiti.engine.impl.history.HistoryLevel;
  7. import org.junit.jupiter.api.Test;
  9. public class DatabaseInitTest {
  11.     /**
  12.      * 初始化数据库（activiti 引擎）
  13.      *
  14.      * 在Activiti7 的文档中我们只需要配置了database-schema-update: true，在程序启动时，就会自动的帮我们更新或者创建表结构。但是在实施过程中发现程序启动后没有帮我创建表结构（mysql5.7）
  15.      *
  16.      *     activiti:
  17.      *         history-level: full
  18.      *         db-history-used: true
  19.      *         database-schema-update: true
  20.      * 解决方案：
  21.      * 在数据库连接地址后面加上
  22.      *
  23.      * nullCatalogMeansCurrent=true
  24.      * 就可以了。
  25.      */
  26.     @Test
  27.     public void initMySql() {
  28. //        DbSchemaCreate
  29.         ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration()
  30.                 .setDatabaseSchema("activiti7")
  31.                 .setJdbcUrl(
  32.                         "jdbc:mysql:///activiti_demo?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true")
  33.                 .setDbHistoryUsed(true)
  34.                 .setJdbcPassword("123456")
  35.                 .setJdbcUsername("root")
  36.                 .setJdbcDriver("com.mysql.cj.jdbc.Driver")
  37.                 .setHistoryLevel(HistoryLevel.FULL)
  38.                 .setDatabaseType("mysql")
  39.                 .setDatabaseSchemaUpdate(ProcessEngineConfigurationImpl.DB_SCHEMA_UPDATE_CREATE)
  40.                 .buildProcessEngine();
  41.     }
  43. }

上述采取的是Java 代码方式，也可采取 act-cfg.xml 文件
其中代码可以看 mvnRep_home\org\activiti\activiti-engine\7.1.0.M6\activiti-engine-7.1.0.M6.jar
image.png

2. springboot + activiti7 + mybatis 整合

尴尬 mysql8 搞事情，activiti7 不能自动建立表：

activiti-7.1.0.M6 + mysql8.0.22 无法自动生成数据表，启动报错， activiti7 无法建立引擎 Bean 对象。
同时，报数据表不存在。
改到 mysql5.7 就可以了。

yaml

  1. server:
  2.   servlet:
  3.     context-path: /v1/demo
  4.   port: 9091
  6. spring:
  7.   jackson:
  8.     date-format: yyyy-MM-dd HH:mm:ss
  9.     time-zone: GMT+8
  10.   # activiti
  11.   activiti:
  12.     # 自动建表
  13.     database-schema: ACTIVITI7
  14.     #表示启动时检查数据库表，不存在则创建
  15.     database-schema-update: true
  16.     #表示哪种情况下使用历史表，这里配置为full表示全部记录历史，方便绘制流程图
  17.     history-level: full
  18.     #表示使用历史表，如果不配置，则工程启动后可以检查数据库，只建立了17张表，历史表没有建立，则流程图及运行节点无法展示
  19.     db-history-used: true
  20.     deployment-name: demo-mybatis-activiti7
  21.   datasource:
  22.     url: jdbc:mysql://localhost/activiti_demo?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT%2B8
  23.     username: root
  24.     password: 123456
  25. #    url: jdbc:mysql://192.168.0.213:30001/xh_activiti?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true&useSSL=false
  26. #    username: root
  27. #    password: Platform#123
  28.     type: com.alibaba.druid.pool.DruidDataSource
  29.     druid:
  30.       # 下面为连接池的补充设置，应用到上面所有数据源中
  31.       # 初始化大小，最小，最大
  32.       initial-size: 5
  33.       min-idle: 5
  34.       max-active: 20
  35.       # 配置获取连接等待超时的时间
  36.       max-wait: 60000
  37.       # 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒
  38.       time-between-eviction-runs-millis: 60000
  39.       # 配置一个连接在池中最小生存的时间，单位是毫秒
  40.       min-evictable-idle-time-millis: 300000
  41.       #      validation-query: SELECT 1 FROM DUAL
  42.       test-while-idle: true
  43.       test-on-borrow: false
  44.       test-on-return: false
  45. #      # 打开PSCache，并且指定每个连接上PSCache的大小
  46. #      pool-prepared-statements: true
  47. #      #   配置监控统计拦截的filters，去掉后监控界面sql无法统计，'wall'用于防火墙
  48. #      max-pool-prepared-statement-per-connection-size: 20
  49. #      filters: stat,wall
  50. #      use-global-data-source-stat: true
  51. #      # 通过connectProperties属性来打开mergeSql功能；慢SQL记录
  52. #      connect-properties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=2000
  53. #      # 配置监控服务器
  54. #      stat-view-servlet:
  55. #        login-username: admin
  56. #        login-password: admin
  57. #        reset-enable: false
  58. #        url-pattern: /druid/*
  59. #        # 添加IP白名单
  60. #        #allow:
  61. #        # 添加IP黑名单，当白名单和黑名单重复时，黑名单优先级更高
  62. #        #deny:
  63. #      web-stat-filter:
  64. #        # 添加过滤规则
  65. #        url-pattern: /*
  66. #        # 忽略过滤格式
  67. #        exclusions: "*.js,*.gif,*.jpg,*.png,*.css,*.ico,/druid/*"
  69. #liqubase是否开启
  70. #liquibase:
  71. #  enabled: true
  72. #  changeLog: "classpath:/db/changelog/db.changelog-master.xml"
  73. #  checkChangeLogLocation: true
  74. #  #用于跟踪更改历史记录的表的名称。
  75. #  databaseChangeLogTable: DATABASECHANGELOG
  76. #  #用于跟踪Liquibase并发使用情况的表的名称。
  77. #  databaseChangeLogLockTable: DATABASECHANGELOGLOCK
  78. #  #是否先清空数据库
  79. #  dropFirst: false
  80. #  #是否应该在执行更新之前测试回滚。
  81. #  testRollbackOnUpdate: true
  83. custom:
  84.   swagger:
  85.     enabled: true
  86. mybatis:
  87.   mapper-locations: classpath*:mapper/**
  88.   configuration:
  89.     map-underscore-to-camel-case: true
  90.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  92. logging:
  93.   level:
  94.     com.demo.activiti7.mapper: debug

pom

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <project xmlns="http://maven.apache.org/POM/4.0.0"
  3.   xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  4.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  5.   <!--<parent>
  6.     <artifactId>my-activiti-demo</artifactId>
  7.     <groupId>my.activiti.demo.com</groupId>
  8.     <version>1.0-SNAPSHOT</version>
  9.   </parent>-->
  10.   <modelVersion>4.0.0</modelVersion>
  11.   <artifactId>mybatis-activiti7-single</artifactId>
  12.   <groupId>my.activiti.demo.com</groupId>
  13.   <version>1.0-SNAPSHOT</version>
  15.   <developers>
  16.     <developer>
  17.       <name>xiaohui</name>
  18.       <email>xuxiaohuimail@163.com</email>
  19.       <roles>
  20.         <role>developer</role>
  21.       </roles>
  22.       <timezone>+8</timezone>
  23.     </developer>
  24.   </developers>
  26.   <properties>
  27.     <java.version>1.8</java.version>
  28.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  29.     <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
  30.     <mapstruct>1.3.0.Final</mapstruct>
  31.     <activiti.version>7.1.0.M6</activiti.version>
  32.     <spring-boot>2.1.0.RELEASE</spring-boot>
  33.     <fastjson>1.2.47</fastjson>
  34.     <commons-collections>3.2.2</commons-collections>
  35.     <commons-lang3>3.8.1</commons-lang3>
  36.     <swagger-annotations>1.5.16</swagger-annotations>
  37.     <springfox-swagger2>2.7.0</springfox-swagger2>
  38.     <druid.version>1.2.4</druid.version>
  39.     <mybatis-plus-boot-starter>3.1.0</mybatis-plus-boot-starter>
  40.     <feign-hystrix>9.5.0</feign-hystrix>
  41.     <lombok>1.16.20</lombok>
  42.     <!--<liquibase-core>3.5.3</liquibase-core>-->
  43.     <validation-api>2.0.1.Final</validation-api>
  44.     <hibernate-validator>6.0.15.Final</hibernate-validator>
  45.     <mybatis.version>3.5.6</mybatis.version>
  46.     <mysql.jdbc.version>8.0.15</mysql.jdbc.version>
  47.   </properties>
  48.   <dependencyManagement>
  49.     <dependencies>
  50.       <dependency>
  51.         <groupId>org.activiti.dependencies</groupId>
  52.         <artifactId>activiti-dependencies</artifactId>
  53.         <version>${activiti.version}</version>
  54.         <scope>import</scope>
  55.         <type>pom</type>
  56.       </dependency>
  57.     </dependencies>
  58.   </dependencyManagement>
  59.   <dependencies>
  60.     <dependency>
  61.       <groupId>org.springframework.boot</groupId>
  62.       <artifactId>spring-boot-starter-actuator</artifactId>
  63.     </dependency>
  64.     <dependency>
  65.       <groupId>org.springframework.boot</groupId>
  66.       <artifactId>spring-boot-starter-web</artifactId>
  67.     </dependency>
  68.     <dependency>
  69.       <groupId>org.springframework.boot</groupId>
  70.       <artifactId>spring-boot-starter-test</artifactId>
  71.       <version>RELEASE</version>
  72.       <scope>test</scope>
  73.     </dependency>
  74.     <dependency>
  75.       <groupId>org.activiti</groupId>
  76.       <artifactId>activiti-spring-boot-starter</artifactId>
  77.       <version>${activiti.version}</version>
  78.     </dependency>
  80.     <dependency>
  81.       <groupId>org.mybatis.spring.boot</groupId>
  82.       <artifactId>mybatis-spring-boot-starter</artifactId>
  83.     </dependency>
  84.     <dependency>
  85.       <groupId>org.mybatis</groupId>
  86.       <artifactId>mybatis</artifactId>
  87.       <version>${mybatis.version}</version>
  88.     </dependency>
  89.     <dependency>
  90.       <groupId>mysql</groupId>
  91.       <artifactId>mysql-connector-java</artifactId>
  92.       <version>${mysql.jdbc.version}</version>
  93.     </dependency>
  94.     <dependency>
  95.       <groupId>org.mybatis.spring.boot</groupId>
  96.       <artifactId>mybatis-spring-boot-starter</artifactId>
  97.       <version>2.1.4</version>
  98.       <exclusions>
  99.         <exclusion>
  100.           <artifactId>spring-boot-starter</artifactId>
  101.           <groupId>org.springframework.boot</groupId>
  102.         </exclusion>
  103.         <exclusion>
  104.           <groupId>org.mybatis</groupId>
  105.           <artifactId>mybatis</artifactId>
  106.         </exclusion>
  107.       </exclusions>
  108.     </dependency>
  109.     <!-- Activiti生成流程图 -->
  110.     <dependency>
  111.       <groupId>org.activiti</groupId>
  112.       <artifactId>activiti-image-generator</artifactId>
  113.     </dependency>
  114.     <dependency>
  115.       <groupId>com.alibaba</groupId>
  116.       <artifactId>druid-spring-boot-starter</artifactId>
  117.       <version>${druid.version}</version>
  118.     </dependency>
  119.     <!-- utils -->
  120.     <dependency>
  121.       <groupId>com.alibaba</groupId>
  122.       <artifactId>fastjson</artifactId>
  123.       <version>${fastjson}</version>
  124.       <scope>compile</scope>
  125.     </dependency>
  126.     <dependency>
  127.       <groupId>commons-collections</groupId>
  128.       <artifactId>commons-collections</artifactId>
  129.       <version>${commons-collections}</version>
  130.       <scope>compile</scope>
  131.     </dependency>
  132.     <dependency>
  133.       <groupId>org.projectlombok</groupId>
  134.       <artifactId>lombok</artifactId>
  135.       <version>${lombok}</version>
  136.     </dependency>
  137.     <!-- data validation -->
  138.     <dependency>
  139.       <groupId>javax.validation</groupId>
  140.       <artifactId>validation-api</artifactId>
  141.       <version>${validation-api}</version>
  142.     </dependency>
  143.     <!--<dependency>
  144.       <groupId>org.hibernate</groupId>
  145.       <artifactId>hibernate-validator</artifactId>
  146.       <version>${hibernate-validator}</version>
  147.     </dependency>-->
  148.     <!-- liquibase -->
  149.     <!--<dependency>
  150.       <groupId>org.liquibase</groupId>
  151.       <artifactId>liquibase-core</artifactId>
  152.       <version>${liquibase-core}</version>
  153.     </dependency>-->
  155.     <!-- swagger -->
  156.     <dependency>
  157.       <groupId>io.swagger</groupId>
  158.       <artifactId>swagger-annotations</artifactId>
  159.       <version>${swagger-annotations}</version>
  160.       <scope>compile</scope>
  161.     </dependency>
  162.     <dependency>
  163.       <groupId>io.springfox</groupId>
  164.       <artifactId>springfox-swagger2</artifactId>
  165.       <version>${springfox-swagger2}</version>
  166.       <scope>compile</scope>
  167.     </dependency>
  168.     <dependency>
  169.       <groupId>io.springfox</groupId>
  170.       <artifactId>springfox-swagger-ui</artifactId>
  171.       <version>${springfox-swagger2}</version>
  172.     </dependency>
  173.     <!-- 数据库驱动相关 -->
  174.     <dependency>
  175.       <groupId>com.alibaba</groupId>
  176.       <artifactId>druid-spring-boot-starter</artifactId>
  177.       <version>${druid.version}</version>
  178.       <scope>compile</scope>
  179.     </dependency>
  180.   </dependencies>
  182.   <build>
  183.     <plugins>
  184.       <plugin>
  185.         <groupId>org.springframework.boot</groupId>
  186.         <artifactId>spring-boot-maven-plugin</artifactId>
  187.       </plugin>
  188.       <plugin>
  189.         <groupId>org.apache.maven.plugins</groupId>
  190.         <artifactId>maven-compiler-plugin</artifactId>
  191.         <configuration>
  192.           <source>8</source>
  193.           <target>8</target>
  194.         </configuration>
  195.       </plugin>
  196.     </plugins>
  197.     <finalName>mybatis-activiti7-single</finalName>
  198.   </build>
  201. </project>

3. url 访问报错，出现 json 无法转化问题

  1. {
  2.   "timestamp": "2021-02-05 17:00:36",
  3.   "status": 500,
  4.   "error": "Internal Server Error",
  5.   "message": "Could not write JSON: (was java.lang.NullPointerException); nested exception is com.fasterxml.jackson.databind.JsonMappingException: (was java.lang.NullPointerException) (through reference chain: org.activiti.engine.impl.persistence.entity.ExecutionEntityImpl[\"currentFlowElement\"])",
  6.   "path": "/v1/demo/ins"
  7. }