用mybatis-plus分页时报错 Error: Method queryTotal execution error.
2020-07-30 14:38:07:007 ERROR [192.168.123.1:20001/app-service-qms,,,,,http-nio-20001-exec-1] c.s.s.c.e.h.CustomizedResponseEntityExceptionHandler:65 - nested exception is 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 file [D:\Xinshidai\xinhua\app-services\app-service-qms\target\classes\mappers\oracle\PerformRankGroupPremMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: Error: Method queryTotal execution error.
是sql写错了,发现错误,查的那张表中没有AgentCode字段,但是我在sql里写,本应该写组名的地方,写了AGENTCODE
<if test="agentCode != '' or agentCode != null">
and ((AGENTCODE like '%'||#{agentCode}||'%' or AGENTCODE like '%'||#{agentCode}||'%'))
</if>