# Unable to create more than one database in same server (MySQL) **URL:** \ **Category:** Flowable Engine\ **Created:** [November 16, 2018, 9:55am UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911 "2018-11-16T09:55:02Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\ **Post date:** [November 16, 2018, 9:55am UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/1 "2018-11-16T09:55:02Z")
Hi Team, Unable to create more than one database in same server in MySQL. We are getting below error. Could anyone help me resolve this issue? ``` Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'omqadb1.act_ge_property' doesn't exist ### The error may exist in org/flowable/db/mapping/entity/Property.xml ### The error may involve org.flowable.engine.impl.persistence.entity.PropertyEntityImpl.selectProperty-Inline ### The error occurred while setting parameters ### SQL: select * from ACT_GE_PROPERTY where NAME_ = ? ### Cause: java.sql.SQLSyntaxErrorException: Table 'omqadb1.act_ge_property' doesn't exist at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) ~[mybatis-3.4.5.jar:3.4.5] at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) ~[mybatis-3.4.5.jar:3.4.5] at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:234) ~[flowable-engine-common-6.3.1.jar:6.3.1] at org.flowable.common.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:218) ~[flowable-engine-common-6.3.1.jar:6.3.1] at org.flowable.engine.impl.db.ProcessDbSchemaManager.dbSchemaUpdate(ProcessDbSchemaManager.java:183) ~[flowable-engine-6.3.1.jar:6.3.1] ``` ---
**Author:** ![jorge.mora](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/jorge.mora/32/694_2.png) [@jorge.mora](https://forum.flowable.org/u/jorge.mora)\ **Post date:** [November 16, 2018, 10:06am UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/2 "2018-11-16T10:06:03Z")
What version of the Mysql JDBC driver are you using. If you are using the 8.x version, you can try with the 5.x version. You can check if the driver was detected or not before that stacktrace. ---
**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\ **Post date:** [November 16, 2018, 12:07pm UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/3 "2018-11-16T12:07:21Z")
Hi @jorge.mora, Thanks for quick help. After changing mysql-connector version from 8.x to 5.1.27 It fixed. Below is my new dependency: > ``` > > mysql > mysql-connector-java > 5.1.27 > > > ``` Just wanted to understand why with the latest version of mysql-connector-java its not working? ---
**Author:** ![jorge.mora](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/jorge.mora/32/694_2.png) [@jorge.mora](https://forum.flowable.org/u/jorge.mora)\ **Post date:** [November 16, 2018, 12:37pm UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/4 "2018-11-16T12:37:49Z")
Hi, This is something that we are investigating. Can you tell us which version of MySQL server you are using? Not only the version number, also if you are using anything different from the official MySQL server from Oracle. Sorry for the inconveniences and thank you for your collaboration. Jorge ---
**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 16, 2018, 7:07pm UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/5 "2018-11-16T19:07:14Z")
@mtmanju for some reason there has been a change in some defaults of the MySQL JDBC Driver. More precisely in the `nullCatalogMeansCurrent` property. In 5.1 the property default value is `true`. Which means that the catalog would match the current database in the URL. In 8.0 they changed this to `false`. Which means that it won’t match it. In order to make this work on 8.0 you would need to add `nullCatalogMeansCurrent=true` to your JDBC URL. See [https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html](https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html) and [https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html](https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html) In the meantime we are also going to look into if we can do something about this on our side. ---
**Author:** ![mtmanju](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/mtmanju/32/388_2.png) [@mtmanju](https://forum.flowable.org/u/mtmanju)\ **Post date:** [November 17, 2018, 4:44am UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/6 "2018-11-17T04:44:45Z")
Thanks @filiphr, After changing the JDBC url as suggested it worked fine for me. Thanks a lot for the quick help. Thanks, Manjunath ---
**Author:** ![akki](https://avatars.discourse-cdn.com/v4/letter/a/b9e5f3/32.png) [@akki](https://forum.flowable.org/u/akki)\ **Post date:** [June 10, 2020, 6:27am UTC](https://forum.flowable.org/t/unable-to-create-more-than-one-database-in-same-server-mysql/2911/7 "2020-06-10T06:27:30Z")
I tried to add this property in JDBC url, it still gave the same error, however, I’m using postgresql instead of mysql. Also, I noted that if a database has 2 schema, Schema-1 and Schema-2 and if Schema-1 has those 75 workflow tables and Schema-2 is empty, so if I switch to Schema-2 in my properties file, hoping that new tables will get created in this new Schema, it gives the same error described in post