org.apache.ibatis.exceptions.PersistenceException: 解决办法，出现原因数据库ORM映射不正常

最新推荐文章于 2025-05-22 09:57:27 发布

苦思冥想行则将至

最新推荐文章于 2025-05-22 09:57:27 发布

阅读量858

点赞数

CC 4.0 BY-SA版权

分类专栏： 2020年工作笔记问题总结

越来越好！加油

本文链接：https://blog.csdn.net/u011488009/article/details/105295376

2020年工作同时被 3 个专栏收录

93 篇文章

订阅专栏

问题总结

61 篇文章

订阅专栏

笔记

17 篇文章

订阅专栏

本文详细解析了在使用MybatisPlus进行数据查询时遇到的PersistenceException异常，具体表现为queryTotal方法执行错误，并提供了修改代码以正确映射数据库字段的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

org.apache.ibatis.exceptions.PersistenceException:
### Error querying database. Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error.
### The error may exist in com/gildata/threebody/corpus/dao/mapper/EventTagProcessMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error.

断点错误信息：

  @Override
    public IPage<EventTagProcess> queryPageForEventTagProcessVo(EventTagProcess eventTagProcess, Integer current, Integer size) {

        Page<EventTagProcess> page = new Page<>(current, size);
        QueryWrapper<EventTagProcess> qw = new QueryWrapper<>();
        if (eventTagProcess.getEventCode() != null) {
            qw.eq("event_code", eventTagProcess.getEventCode());
        }
        if (eventTagProcess.getInfoId() != null) {
            qw.eq("infoId", eventTagProcess.getInfoId());
        }
        if (eventTagProcess.getNewsTitle() != null) {
            qw.eq("newsTitle", eventTagProcess.getNewsTitle());
        }
        if (eventTagProcess.getSource() != null) {
            qw.eq("source", eventTagProcess.getSource());
        }
        if (eventTagProcess.getCreater() != null) {
            qw.eq("creater", eventTagProcess.getCreater());
        }
        qw.eq("deleteFlag", 0);
        return eventTagProcessMapper.selectPage(page, qw);
    }

Mybatis_Plus需要ORM映射数据表字段：

修改为：

 @Override
    public EventTagProcess getEventTagProcess(EventTagProcess eventTagProcess) {
        QueryWrapper<EventTagProcess> queryWrapper = new QueryWrapper<>();

        if (eventTagProcess.getNewsTitle() != null) {
            queryWrapper.eq("news_title", eventTagProcess.getNewsTitle());
        }
        if (eventTagProcess.getSource() != null) {
            queryWrapper.eq("source", eventTagProcess.getSource());
        }
        if (eventTagProcess.getCreater() != null) {
            queryWrapper.eq("creater", eventTagProcess.getCreater());
        }
        if (eventTagProcess.getEventCode() != null) {
            queryWrapper.eq("event_code", eventTagProcess.getEventCode());
        }
        if (eventTagProcess.getInfoId() != null) {
            queryWrapper.eq("info_id", eventTagProcess.getInfoId());
        }
        queryWrapper.eq("delete_flag", 0);
        return eventTagProcessMapper.selectOne(queryWrapper);
    }