Hi,
I am trying to come with a sample Springboot application with Flowable and mysql as the db. My application works fine when I use h2 as the DB. But when I try using MySQL as the DB, the application do not boot up and it throws an exception that’s shown below. I am using Springboot - 3.3.4, Flowalble 7.0.1 and Mysql is 8.0.39-0ubuntu0.20.04.1. I am running all this on a Ubuntu. Can someone help me resolve this issue? Thanks.
Caused by: java.sql.SQLSyntaxErrorException: Table ‘ACT_GE_PROPERTY’ already exists
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:763) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:648) ~[mysql-connector-j-8.0.33.jar:8.0.33]
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) ~[HikariCP-5.1.0.jar:na]
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) ~[HikariCP-5.1.0.jar:na]
at org.flowable.common.engine.impl.db.AbstractSqlScriptBasedDbSchemaManager.executeSchemaResource(AbstractSqlScriptBasedDbSchemaManager.java:325) ~[flowable-engine-common-7.0.1.jar:7.0.1]
Regards,
G.Sreedhar