1.问题产生的原因:
由于自己采用的是mysql5.7版本且未做过多的配置,flowable自动生成的表全部是大写,个人不太习惯,就把flowable在mysql中对应的schema(数据库)的表全部删除,然后在my.cfg(windows可能是my.ini)这些配置文件中,加入限定表为小写的配置(在[mysqld]下加入lower_case_table_names=1,重启mysql服务)。 然后启动项目,结果出现
问题:
org.apache.ibatis.exceptions.PersistenceException:
Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table 'activiti.act_ge_property' doesn't exist
The error may exist in org/activiti/db/mapping/entity/Property.xml
The error may involve org.activiti.engine.impl.persistence.entity.PropertyEntity.selectProperty-Inline
The error occurred while setting parameters
SQL: select * from ACT_GE_PROPERTY where NAME_ = ?
Cause: java.sql.SQLSyntaxErrorException: Table 'activiti.act_ge_property' doesn't exist
at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
at org.activiti.engine.impl.db.DbSqlSession.selectById(DbSqlSession.java:466)
at org.activiti.engine.impl.db.DbSqlSession.dbSchemaUpdate(DbSqlSession.java:1080)
at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1473)
at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.jav