Flowable-spring-boot-starter:6.4.1 does not populate the flowable database

Flowable Engine
1

Following: https://www.flowable.org/docs/userguide/index.html#springSpringBoot with the embedded H2 database everything works fine. But when I replace H2 with mysql, at start up I get: java.sql.SQLSyntaxErrorException: Table ‘flowable.act_ge_property’ doesn’t exist.

When I look at the flowable database in MySql, I see that no tables have been created.

build.gradle:
plugins {
id ‘org.springframework.boot’ version ‘2.1.3.RELEASE’
id ‘java’
}

apply plugin: ‘io.spring.dependency-management’

group = ‘com.pgi’
version = ‘0.0.1-SNAPSHOT’
sourceCompatibility = ‘1.8’

repositories {
mavenCentral()
}

configurations.all {
exclude module: ‘log4j-slf4j-impl’
}

dependencies {
implementation ‘org.springframework.boot:spring-boot-starter-actuator’
implementation ‘org.springframework.boot:spring-boot-starter-data-jpa’
implementation ‘org.springframework.boot:spring-boot-starter-security’
implementation ‘org.springframework.boot:spring-boot-starter-web’
runtimeOnly ‘org.springframework.boot:spring-boot-devtools’
implementation ‘org.flowable:flowable-spring-boot-starter:6.4.1’

implementation ‘mysql:mysql-connector-java’

testImplementation ‘org.springframework.boot:spring-boot-starter-test’
}

application.properties:
server.port=8080

spring.datasource.url=jdbc:mysql://127.0.0.1:3306/flowable?characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=flowable
spring.datasource.password=flowable

2

I set the mysql java connector to version 5.1.44
implementation ‘mysql:mysql-connector-java:5.1.44’
Now at start up it creates the tables, but it doesn’t populate the ACT_ID* tables, so there are no default users.

3

@btaylor7 it seems you’ve hit the same problem as in Unable to create more than one database in same server (MySQL) - #5 by filiphr. There has been change in the MySQL 8.x JDBC driver in one of their defaults. So you would need to add nullCatalogMeansCurrent=true to the URL. This would create the tables properly.

The user tables are never populated with the flowable starter as well. Only the UI Apps are populating some default users.

Cheers,
Filip

1 Like