Is there any tutorial to persist the backend from H2 to MySQL?

1

Is there any tutorial to persist the backend from H2 to MySQL ?

I can’t find any links related to this issue , anyone ?

2

Hi,

You need to add the MySQL JDBC driver to the classpath. This is because we can’t ship the MySQL driver in our downloads due to the license restrictions of the MySQL JDBC Driver.
Then you need to change the app property file in the META-INF folder of the web app WEB-INF/classes folder:

datasource.driver=com.mysql.jdbc.Driver
datasource.url=jdbc:mysql://127.0.0.1:3306/flowable?characterEncoding=UTF-8
datasource.username=flowable
datasource.password=flowable

Best regards,

Tijs

3

Thanks, it works now.

4

hi tijs,
I am getting this error
“Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table ‘flowable.act_ge_property’ doesn’t exist”

how to create the defaults table automatically?