Error querying database. Cause: java.sql.SQLSyntaxErrorException: Table ‘activiti.act_ge_property‘

最新推荐文章于 2023-08-26 10:13:06 发布

晓强-

最新推荐文章于 2023-08-26 10:13:06 发布

阅读量1.2w

点赞数 3

分类专栏： exception 文章标签： mysql activiti 数据库 jdbc java

本文链接：https://blog.csdn.net/weixin_40460171/article/details/107085915

版权

博客讲述了在使用Activiti时遇到的数据库查询错误，错误信息为`java.sql.SQLSyntaxErrorException: Table ‘activiti.act_ge_property‘`。作者尝试了多种解决方法，包括检查MySQL版本、设置数据库更新配置、手动创建表等，但问题仍未解决。最终发现是由于MySQL的回收站机制导致已删除表仍显示存在。通过执行`purge recyclebin`或`drop table xx purge`等SQL命令彻底清理回收站，解决了问题。

摘要由CSDN通过智能技术生成

完整报错信息

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