flowable错误Table 'sys.act_id_user' doesn't exist解决
在运行是会出现错误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
注意:重新运行前需要删除已生成的数据表