flowable错误Table ‘sys.act

flowable错误Table ‘sys.act

flowable错误Table 'sys.act_id_user' doesn't exist解决

flowable中文文档.

在运行是会出现错误Table ‘XXX.act_id_user’ doesn’t exist
problem during schema upgrade, statement alter table ACT_ID_USER add TENANT_ID_ varchar(255) default ‘’

解决方案
mysql的连接字符串中添加上nullCatalogMeansCurrent=true，将schema默认设置为当前连接的schema。database-schema-update: true的作用是自动更新数据库中需要的表，在第一次运行时必要
如

server:
  port: 8088
spring:
  datasource:
    username: root
    password: ****
    url: jdbc:mysql://localhost:3306/flowable-spring-boot?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8&nullCatalogMeansCurrent=true
    driver-class-name: com.mysql.cj.jdbc.Driver

flowable:
  #关闭定时任务JOB
  async-executor-activate: false
  database-schema-update: true

注意：重新运行前需要删除已生成的数据表