# Can not auto creation db tables

**URL:** <https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922>\
**Category:** Flowable Engine\
**Created:** [November 20, 2018, 3:42pm UTC](https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922 "2018-11-20T15:42:50Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![clinan](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@clinan](https://forum.flowable.org/u/clinan)\
**Post date:** [November 20, 2018, 3:42pm UTC](https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922/1 "2018-11-20T15:42:50Z")

</div>

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\>

---

<div class="post-metadata">

**Author:** ![clinan](https://avatars.discourse-cdn.com/v4/letter/c/cc9497/32.png) [@clinan](https://forum.flowable.org/u/clinan)\
**Post date:** [November 21, 2018, 1:21am UTC](https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922/2 "2018-11-21T01:21:20Z")

</div>

Mysql URL string append `nullCatalogMeansCurrent=true` can solve it.

---

<div class="post-metadata">

**Author:** ![filiphr](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/filiphr/32/315_2.png) [@filiphr](https://forum.flowable.org/u/filiphr)\
**Post date:** [November 26, 2018, 7:21am UTC](https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922/3 "2018-11-26T07:21:11Z")

</div>

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)](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/6).

---

<div class="post-metadata">

**Author:** ![BPMLearner](https://avatars.discourse-cdn.com/v4/letter/b/e47c2d/32.png) [@BPMLearner](https://forum.flowable.org/u/BPMLearner)\
**Post date:** [June 8, 2023, 4:26am UTC](https://forum.flowable.org/t/can-not-auto-creation-db-tables/2922/4 "2023-06-08T04:26:21Z")

</div>

Thank you @filiphr @clinan That solved my problem.
