Why camunda cannot create tables in two schema of same db?

Camunda 7 Topics Discussion & Questions
4

Hi, @1119

I am Chinese but this website may like stack overflow is English language only.
For make sure others understand I will use English reply you.

First. Thank you so much. You saved my day. And this is working for me.
Second I will translate your answer for others.

This is because MySQL changed the nullCatalogMeansCurrent property default value to false.
if the nullCatalogMeansCurrent property value is false the MySQL will search the whole schema to find tables.
if the nullCatalogMeansCurrent property value is true the MySQL will search current schema to find tables.

How to fix it?
Just add the nullCatalogMeansCurrent property to your mysql url.
here is the example

jdbc:mysql://localhost:3306/piwik?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&nullCatalogMeansCurrent=true

Cheers

6 Likes