MybatisPlusException: This is impossible to happen

最新推荐文章于 2023-11-09 13:42:43 发布
最新推荐文章于 2023-11-09 13:42:43 发布
阅读量1.2k 收藏
点赞数
分类专栏： mybatis 文章标签： java spring spring boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/zlsdmx/article/details/120765195
版权

mybatis-plugins，使用lambada表达式in条件查询，本地运行正常、部署到服务器报错

参考连接：mybatis.plus使用lambda表达式报错，本地正常，部署服务后出错。

 <dependency>
  	 <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus</artifactId>
     <version>3.3.0</version>
 </dependency>
 <dependency>
     <groupId>com.baomidou</groupId>
     <artifactId>mybatis-plus-boot-starter</artifactId>
     <version>3.2.0</version>
 </dependency>

//不报错代码
	@Override
    public Page<CsReply> getList(QueryReplyDTO queryReplyDTO) {

        Page<CsReply> page = new Page<>();
        page.setSize(queryReplyDTO.getPageSize());
        page.setCurrent(queryReplyDTO.getPageNumber());
        Integer id = queryReplyDTO.getId();
        Page<CsReply> list = csReplyMapper.selectPage(page, new QueryWrapper<CsReply>()
                .eq(id != null, "id", id)
                .in(!CollectionUtils.isEmpty(queryReplyDTO.getServicerGroupIds()), "servicer_group_id", queryReplyDTO.getServicerGroupIds())
                .in(!StringUtils.isEmpty(queryReplyDTO.getTypes()),"type", queryReplyDTO.getTypes()).orderByDesc("created_at"));
        return list;
    }

//报错代码
	
	  @Override
    public Page<CsReply> getList(QueryReplyDTO queryReplyDTO) {

        Page<CsReply> page = new Page<>();
        page.setSize(queryReplyDTO.getPageSize());
        page.setCurrent(queryReplyDTO.getPageNumber());
        Integer id = queryReplyDTO.getId();
        Page<CsReply> list = csReplyMapper.selectPage(page, new LambdaQueryWrapper<CsReply>()
                .eq(id != null, CsReply::getId, id)
                .in(!CollectionUtils.isEmpty(queryReplyDTO.getServicerGroupIds()), CsReply::getServicerGroupId, queryReplyDTO.getServicerGroupIds())
                .in(!StringUtils.isEmpty(queryReplyDTO.getTypes()),CsReply::getType, queryReplyDTO.getTypes()).orderByDesc(CsReply::getCreatedAt));
        return list;
    }

报错信息如下

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere'. Cause: org.apache.ibatis.ognl.OgnlException: sqlSegment [com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: This is impossible to happen]
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy104.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForIPage(MybatisMapperMethod.java:134)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:96)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:96)
	at com.sun.proxy.$Proxy120.selectPage(Unknown Source)
	at com.xhwl.customerservice.service.serviceImpl.CsReplyServiceImpl.getList(CsReplyServiceImpl.java:51)
	at com.xhwl.customerservice.service.serviceImpl.CsReplyServiceImpl$$FastClassBySpringCGLIB$$201d7860.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687)
	at com.xhwl.customerservice.service.serviceImpl.CsReplyServiceImpl$$EnhancerBySpringCGLIB$$5f2edb5.getList(<generated>)
	at com.xhwl.customerservice.controller.CsReplyController.getList(CsReplyController.java:44)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1590)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:748)
Caused by: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere'. Cause: org.apache.ibatis.ognl.OgnlException: sqlSegment [com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: This is impossible to happen]
	at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:48)
	at org.apache.ibatis.scripting.xmltags.ExpressionEvaluator.evaluateBoolean(ExpressionEvaluator.java:32)
	at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:34)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
	at java.util.ArrayList.forEach(ArrayList.java:1259)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
	at org.apache.ibatis.scripting.xmltags.TrimSqlNode.apply(TrimSqlNode.java:55)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
	at java.util.ArrayList.forEach(ArrayList.java:1259)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
	at org.apache.ibatis.scripting.xmltags.IfSqlNode.apply(IfSqlNode.java:35)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.lambda$apply$0(MixedSqlNode.java:32)
	at java.util.ArrayList.forEach(ArrayList.java:1259)
	at org.apache.ibatis.scripting.xmltags.MixedSqlNode.apply(MixedSqlNode.java:32)
	at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:39)
	at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:297)
	at com.baomidou.mybatisplus.core.executor.MybatisCachingExecutor.query(MybatisCachingExecutor.java:88)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:426)
	... 54 more

大家留言讨论一下

zlsdmx
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 2
    评论
专栏目录
IDEA的mybatis插件
07-02
目前IDEA的mybatis插件有两款，其中一款是收费的，这款是免费的，导入IDEA插件即可使用。
springboot 集成mybatis-plus，报Error evaluating expression ‘ew != null and !ew.emptyOfWhere‘. 原因之一
chenqunjian的博客
12-22 8171
报错信息： ERROR - 2020-12-14 21:01:39,317 - cn.com.bjfanuc.controller.SysMessageController - >>>>>>>>>>> URL: /sysmsg/getUnReadMsgCount, throw Exception => {} org.mybatis.spring.MyBatisSystemException: nested exception is o
mybatis坑
qq_43172064的博客
12-14 415
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'ew.sqlSegment != null and ew.sqlSegment != '' and ew.nonEmptyOfWhere'. Cause: org.apache.ibatis.ognl.OgnlException: sqlS
mybatis-plus和pageHelper依赖的jar包冲突,导致线上所有的ew.customSqlSegment变量转义不过来,导致查询失败.
a480675751的博客
01-24 1889
后端使用mybatis-plus实现数据的查询,本地能正常的执行,但是部署到项目会报异常Caused by: org.apache.ibatis.builder.BuilderException: Error evaluating expression ‘ew.customSqlSegment’. Cause: org.apache.ibatis.ognl.OgnlException: customSqlSegment [com.baomidou.mybatisplus.core.exceptions.My
MybatisPlusException: Error: Method queryTotal execution error of sql 的报错解决
六根绳的博客
05-25 2万+
运行项目的时候遇到了这样的错误：
make-fetch-happen:使获取发生在npm
04-28
$ npm install --save make-fetch-happen 目录 fetch.defaults minipass-fetch选项 make-fetch-happen选项 opts.cacheManager opts.cache opts.proxy opts.noProxy opts.ca, opts.cert, opts.key opts....
make-fetch-happen：加入失败者，我们正在提出要求！
02-20
安装$ npm install --save make-fetch-happen 目录例子const fetch = require ( 'make-fetch-happen' ) . defaults ( { cacheManager : './my-cache' // path where cache will be written (and read)} )fetch ( '...
ERP Make it Happen
05-24
ERP Make it Happen ERP Make it Happen ERP Make it Happen ERP Make it Happen
Why do bad things happen to mediocre people?-crx插件
04-06
语言:English 为什么平庸的人会发生坏事？ 为什么平庸的人会发生坏事？ 我每天都会问自己一个问题。 我的朋友艾琳每天都会问自己一个问题。 现在，您也可以问问自己。 除了漂亮的Unsplash图片。...
Springboot整合SSMP报错分析
CJPSR的博客
05-11 2561
本文主要介绍了在Springboot中整合SSMP的一些报错分析~
evaluating expression ‘ew.sqlSegment != null and ew.sqlSegment != ‘‘ and ew. mybaties plus问题
清水的专栏
06-21 737
使用方法2更换jdk版本，因为3.4.2版本中count返回的是integer类型，而不是long，降低mbplus版本要修改这部分代码。使用的jdk版本是1.8，替换mybatisplus版本：3.3.2改为3.4.1。方法2：mbplus 版本3.4.3.2 ，把jdk 改为1.8。情景：我电脑上能运行的项目，在同事电脑上运行会这个错误。方法1：jdk16，把mbplus 的版本降到3.4.2。原因：jdk版本与mybaties版本问题。删除class文件，重新编译。
Error evaluating expression ‘ew.sqlSegment != null and ew.sqlSegment != ‘‘ and ew.nonEmptyOfWhere‘.
最新发布
普通人一枚
11-09 155
原因mybatisplus版本问题之前3.4.3改成3.4.3后没问题。
springboot 集成mybatis-plus异常 MybatisPlusException: can not find lambda cache for this property [*]
sinat_34338162的博客
09-19 9913
当前mybatis-plus 版本为3.3.2 <!-- https://mvnrepository.com/artifact/com.baomidou/mybatis-plus-boot-starter 移除了mysql性能分析插件--> <dependency> <groupId>com.baomidou</groupId> <artifactId>myba
MybatisPlusException: Failed to process, please exclude the tableName or statementId
记录工作开发中遇到的技术难点，方便自己查看，也希望可以帮助到他人...
09-27 3203
1、报错原因： SQL语句中包含特殊的处理函数，例如： SUBSTRING_INDEX(t.task_no, '-', 1) original_task_no, CAST(SUBSTRING_INDEX(t.task_no, '-', -1) as SIGNED) sequence 2、解决办法： 在Mapper接口上添加@SqlParser(filter = true)即可。 @SqlParser(filter = true) IPage<TaskVO> page(Page page, @P
Error evaluating解决xpression ‘ew.sqlSegment != null and ew.sqlSegment != ‘‘ and ew.nonEmptyOfWhere‘.
热门推荐
w3x3g的博客
09-28 2万+
（看文章之前要排除，自身的代码bug，本文是在本身代码没问题的基础上，依赖包版本过低导致的） 先上错误和描述，使用的mybatisplus插件，开始用的是3.1.1版本，然后本地运行项目没有问题，之前将项目打包成war包，也没问题，可以在服务器上正常运行。 但是要求，将项目打包成jar包，本地没有问题，使用项目分离的形式进行打包，并且在服务器上运行的时候，在使用到lambda表达式的代码报错，如下： org.mybatis.spring.MyBatisSystemException: nested exc
【异常】MyBatis-Plus提示报错MybatisPlusException: Failed to process, Error SQL
本本本添哥
01-05 4539
运营提出，对首页进行店铺装修时，需看到库存字段， 这样不会上到了0库存的品，导致了用户下单体验的问题。 因此，在Mybatis Plus中新增了库存字段以展示
记录使用mybatis-plus时遇到的错误
julac的博客
04-30 7837
在mybatis-plus中，由于extends BaseMapper，因此我们是不需要手动写sql语句的，因此我们不会遇到语法错误，但是我们可能会遇到下面列举的错误： （1）org.springframework.jdbc.BadSqlGrammarException：Cause: java.sql.SQLSyntaxErrorException 出现该异常的原因：数据库中我们设置的字段名称和数据库中的关键字名称重名，需要更改与数据库中关键字重名的字段名称。 MySQL 关键字和保留字汇总（MySQL
java.net.UnknownHostException；com.baomidou.mybatisplus.core.exceptions.MybatisPlusException
斌仔的小博客
12-08 716
com.baomidou.mybatisplus.core.exceptions.MybatisPlusException:
com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: cannot find column‘s cache for
qq_43639081的博客
05-30 2378
（2）执行模块不使用该Wrappers写法，在有该mapper.java文件的模块提供接口给执行模块使用。（1）在执行模块补充该文件。
Failed to start docker.service: Unit is masked.
08-15
The error message "Failed to start docker.service: Unit is masked" typically indicates that the Docker service has been marked as masked, which means it is disabled and cannot be started. This can happen if there are issues with the Docker installation or if it has been intentionally masked by the system administrator. To resolve this issue, you can try the following steps: 1. Unmask the Docker service: Run the following command to unmask the Docker service. ``` sudo systemctl unmask docker.service ``` 2. Start the Docker service: Once the Docker service is unmasked, you can start it using the following command. ``` sudo systemctl start docker.service ``` 3. Verify the status: After starting the Docker service, you can check its status to ensure it is running without any errors. ``` sudo systemctl status docker.service ``` If the issue persists or if you do not have administrative privileges to perform these actions, you may need to contact your system administrator for further assistance.
评论 2
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值