Can not auto creation db tables

Flowable Engine
1

Hi,
Flowable can not auto create db tables in Spring project.
Caused by: java.sql.SQLSyntaxErrorException: Table 'ztys_playground.act_ge_property' doesn't exist
This is my config code:

<bean id=“processEngineConfiguration” class=“org.flowable.spring.SpringProcessEngineConfiguration”>
<property name=“dataSource” ref=“dataSource”/>
<property name=“transactionManager” ref=“transactionManager”/>
<property name=“databaseSchemaUpdate” value=“true”/>
</bean>

<bean id=“processEngine” class=“org.flowable.spring.ProcessEngineFactoryBean”>
<property name=“processEngineConfiguration” ref=“processEngineConfiguration”/>
</bean>

2

Mysql URL string append nullCatalogMeansCurrent=true can solve it.

2 Likes
3

Just for context. Addiing nullCatalogMeansCurrent=true will solve the problem when using the MySQL 8.x JDBC driver.

To get more context have a look at Unable to create more than one database in same server (MySQL).

4

Thank you @filiphr @clinan That solved my problem.