MyBatis 查询错误java.lang.IllegalArgumentException: invalid comparison: Date and String 缺乏、安全感 2022-02-26 14:50 184阅读 0赞 # MyBatis 查询错误:java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String # 项目中用 MyBatis Plus 替换了 MyBatis,原来的 MyBatis版本是 `3.2.8`, MyBatis Plus 的版本是 `3.1.0`,是基于 MyBatis `3.5.0`开发的,测试没啥问题,上线之后有一些功能不能使用,排查日志发现错误`Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String` 很快就定位到问题,是因为传入的 Date 在 XML 中使用了 `date != null and date != ''`这样的判断引起的,删除`date != ''`这个判断就好了 * 异常信息 Caused by: org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) 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:433) ... 98 more ### 问题复现 ### * ServiceImpl testDao.getDate(new Date()); * Dao Date test(@Param("date") Date date); * XML <select id="test" resultType="java.util.Date"> <if test="date != null and date !=''" > SELECT #{date} AS now FROM dual </if> <if test=" date== null"> SELECT date_add(now(), INTERVAL 1 DAY_HOUR) AS now FROM dual </if> </select> 经过debug,发现 MyBatis 3.3之前和3.3之后的判断逻辑不一样 在3.3之前,判断逻辑是:非基本类型的包装类型,在 `compareWithConversion`方法里传入的 equals 这个参数为 true,发现比较对象的class不一样时,不抛出异常,返回值为1,即: if (!equals) { throw new IllegalArgumentException("invalid comparison: " + v1.getClass().getName() + " and " + v2.getClass().getName()); } result = 1; 通过`compareWithConversion(object1, object2, true) == 0 || object1.equals(object2);` 得出的结果是false,即判断条件不成立; 在3.3之后,在 `compareWithConversion`方法中移除了 equals 这个参数,判断的逻辑改成了 `result = object1 != null && object2 != null && (object1.equals(object2) || compareWithConversion(object1, object2) == 0);`,`compareWithConversion`方法里当比较的对象 class 不同的时候,会抛出 `IllegalArgumentException` 以下是两个版本的比较部分的逻辑代码: ##### MyBatis 3.2.8 相关代码 ##### * org.apache.ibatis.ognl.OgnlOps\#isEqual:76 public static boolean isEqual(Object object1, Object object2) { boolean result = false; if (object1 == object2) { result = true; } else if (object1 != null && object2 != null) { if (object1.getClass().isArray() && object2.getClass().isArray() && object2.getClass() == object1.getClass()) { result = Array.getLength(object1) == Array.getLength(object2); if (result) { int i = 0; for(int icount = Array.getLength(object1); result && i < icount; ++i) { result = isEqual(Array.get(object1, i), Array.get(object2, i)); } } } else if (object1 != null && object2 != null) { result = compareWithConversion(object1, object2, true) == 0 || object1.equals(object2); } } return result; } * org.apache.ibatis.ognl.OgnlOps\#compareWithConversion:21 case 10: if (t1 == 10 && t2 == 10) { if (v1 != null && v2 != null) { if (v1.getClass().isAssignableFrom(v2.getClass()) || v2.getClass().isAssignableFrom(v1.getClass())) { if (v1 instanceof Comparable) { result = ((Comparable)v1).compareTo(v2); break; } if (equals) { result = v1.equals(v2) ? 0 : 1; break; } } if (!equals) { throw new IllegalArgumentException("invalid comparison: " + v1.getClass().getName() + " and " + v2.getClass().getName()); } result = 1; break; } else { boolean var10000 = v1 != v2; } } ##### MyBatis 3.5.0 相关代码 ##### * org.apache.ibatis.ognl.OgnlOps\#isEqual:58 public static boolean isEqual(Object object1, Object object2) { boolean result = false; if (object1 == object2) { result = true; } else if (object1 != null && object1.getClass().isArray()) { if (object2 != null && object2.getClass().isArray() && object2.getClass() == object1.getClass()) { result = Array.getLength(object1) == Array.getLength(object2); if (result) { int i = 0; for(int icount = Array.getLength(object1); result && i < icount; ++i) { result = isEqual(Array.get(object1, i), Array.get(object2, i)); } } } } else { result = object1 != null && object2 != null && (object1.equals(object2) || compareWithConversion(object1, object2) == 0); } return result; } * org.apache.ibatis.ognl.OgnlOps\#compareWithConversion:19 case 10: if (t1 == 10 && t2 == 10) { if (v1 instanceof Comparable && v1.getClass().isAssignableFrom(v2.getClass())) { result = ((Comparable)v1).compareTo(v2); break; } throw new IllegalArgumentException("invalid comparison: " + v1.getClass().getName() + " and " + v2.getClass().getName()); } ### 总结 ### 这个问题来自两方面: 1. 开发不规范,使用 Date 和 String 做比较,这个本身就是有问题的, 类似的还有用 String 比较集合或者对象; 2. MyBatis 3.3 之前的 bug 导致在比较不同类型的时候,本来应该抛出的异常没有被抛出,导致这个问题被隐藏 总结下来就是还是因为开发不规范导致的问题,因为本身判断 `!= null` 就不应该再判断 `!=''`,因为`""`本身是有值的,应该存到数据库中,除非是特殊要求;在这个项目中是因为前台提交的表单中没有值的字段被参数接收后变成了 `""`而不是 `null`,但是这个问题应该是通过在 Controller 相关类中修改 `WebDataBinder`解决的: @InitBinder public void initBinder(WebDataBinder binder) { binder.registerCustomEditor(String.class, new StringTrimmerEditor(true)); } #### 相关 ISSUE #### * [java.util.RandomAccessSubList and java.lang.String][] * [3.3.1 java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String][3.3.1 java.lang.IllegalArgumentException_ invalid comparison_ java.util.Date and java.lang.String] -------------------- #### 调用栈 #### compareWithConversion:130, OgnlOps (org.apache.ibatis.ognl) isEqual:186, OgnlOps (org.apache.ibatis.ognl) equal:578, OgnlOps (org.apache.ibatis.ognl) getValueBody:51, ASTNotEq (org.apache.ibatis.ognl) evaluateGetValueBody:170, SimpleNode (org.apache.ibatis.ognl) getValue:210, SimpleNode (org.apache.ibatis.ognl) getValueBody:56, ASTAnd (org.apache.ibatis.ognl) evaluateGetValueBody:170, SimpleNode (org.apache.ibatis.ognl) getValue:210, SimpleNode (org.apache.ibatis.ognl) getValue:333, Ognl (org.apache.ibatis.ognl) getValue:310, Ognl (org.apache.ibatis.ognl) getValue:45, OgnlCache (org.apache.ibatis.scripting.xmltags) evaluateBoolean:32, ExpressionEvaluator (org.apache.ibatis.scripting.xmltags) apply:33, IfSqlNode (org.apache.ibatis.scripting.xmltags) apply:32, MixedSqlNode (org.apache.ibatis.scripting.xmltags) getBoundSql:40, DynamicSqlSource (org.apache.ibatis.scripting.xmltags) getBoundSql:278, MappedStatement (org.apache.ibatis.mapping) query:75, CachingExecutor (org.apache.ibatis.executor) invoke:-1, GeneratedMethodAccessor338 (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) proceed:49, Invocation (org.apache.ibatis.plugin) invoke:60, Plugin (org.apache.ibatis.plugin) query:-1, $Proxy470 (com.sun.proxy) invoke:-1, GeneratedMethodAccessor338 (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) proceed:49, Invocation (org.apache.ibatis.plugin) invoke:60, Plugin (org.apache.ibatis.plugin) query:-1, $Proxy470 (com.sun.proxy) selectList:108, DefaultSqlSession (org.apache.ibatis.session.defaults) selectList:102, DefaultSqlSession (org.apache.ibatis.session.defaults) selectOne:66, DefaultSqlSession (org.apache.ibatis.session.defaults) invoke:-1, GeneratedMethodAccessor340 (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) invoke:358, SqlSessionTemplate$SqlSessionInterceptor (org.mybatis.spring) selectOne:-1, $Proxy280 (com.sun.proxy) selectOne:163, SqlSessionTemplate (org.mybatis.spring) execute:68, MapperMethod (org.apache.ibatis.binding) invoke:52, MapperProxy (org.apache.ibatis.binding) test:-1, $Proxy288 (com.sun.proxy) invoke0:-1, NativeMethodAccessorImpl (sun.reflect) invoke:62, NativeMethodAccessorImpl (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) invokeJoinpointUsingReflection:333, AopUtils (org.springframework.aop.support) invokeJoinpoint:190, ReflectiveMethodInvocation (org.springframework.aop.framework) proceed:157, ReflectiveMethodInvocation (org.springframework.aop.framework) proceed:85, MethodInvocationProceedingJoinPoint (org.springframework.aop.aspectj) invoke:-1, GeneratedMethodAccessor339 (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) invokeAdviceMethodWithGivenArgs:629, AbstractAspectJAdvice (org.springframework.aop.aspectj) invokeAdviceMethod:618, AbstractAspectJAdvice (org.springframework.aop.aspectj) invoke:70, AspectJAroundAdvice (org.springframework.aop.aspectj) proceed:179, ReflectiveMethodInvocation (org.springframework.aop.framework) invoke:92, ExposeInvocationInterceptor (org.springframework.aop.interceptor) proceed:179, ReflectiveMethodInvocation (org.springframework.aop.framework) invoke:213, JdkDynamicAopProxy (org.springframework.aop.framework) test:-1, $Proxy289 (com.sun.proxy) test:453, SystemServiceImpl (io.helloworlde.github.service) invoke:-1, SystemServiceImpl$$FastClassBySpringCGLIB$$ccedf5b2 (io.helloworlde.github.service) invoke:204, MethodProxy (org.springframework.cglib.proxy) intercept:652, CglibAopProxy$DynamicAdvisedInterceptor (org.springframework.aop.framework) test:-1, SystemServiceImpl$$EnhancerBySpringCGLIB$$c36d45a6 (io.helloworlde.github.service) test:155, PersonalCenterController (io.helloworlde.github.controller) invoke0:-1, NativeMethodAccessorImpl (sun.reflect) invoke:62, NativeMethodAccessorImpl (sun.reflect) invoke:43, DelegatingMethodAccessorImpl (sun.reflect) invoke:498, Method (java.lang.reflect) doInvoke:205, InvocableHandlerMethod (org.springframework.web.method.support) invokeForRequest:133, InvocableHandlerMethod (org.springframework.web.method.support) invokeAndHandle:116, ServletInvocableHandlerMethod (org.springframework.web.servlet.mvc.method.annotation) invokeHandlerMethod:827, RequestMappingHandlerAdapter (org.springframework.web.servlet.mvc.method.annotation) handleInternal:738, RequestMappingHandlerAdapter (org.springframework.web.servlet.mvc.method.annotation) handle:85, AbstractHandlerMethodAdapter (org.springframework.web.servlet.mvc.method) doDispatch:963, DispatcherServlet (org.springframework.web.servlet) doService:897, DispatcherServlet (org.springframework.web.servlet) processRequest:970, FrameworkServlet (org.springframework.web.servlet) doGet:861, FrameworkServlet (org.springframework.web.servlet) service:634, HttpServlet (javax.servlet.http) service:846, FrameworkServlet (org.springframework.web.servlet) service:741, HttpServlet (javax.servlet.http) internalDoFilter:231, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) doFilter:53, WsFilter (org.apache.tomcat.websocket.server) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) doFilter:123, WebStatFilter (com.alibaba.druid.support.http) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) doFilterInternal:105, HttpPutFormContentFilter (org.springframework.web.filter) doFilter:107, OncePerRequestFilter (org.springframework.web.filter) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) executeChain:449, AbstractShiroFilter (org.apache.shiro.web.servlet) call:365, AbstractShiroFilter$1 (org.apache.shiro.web.servlet) doCall:90, SubjectCallable (org.apache.shiro.subject.support) call:83, SubjectCallable (org.apache.shiro.subject.support) execute:383, DelegatingSubject (org.apache.shiro.subject.support) doFilterInternal:362, AbstractShiroFilter (org.apache.shiro.web.servlet) doFilter:125, OncePerRequestFilter (org.apache.shiro.web.servlet) invokeDelegate:346, DelegatingFilterProxy (org.springframework.web.filter) doFilter:262, DelegatingFilterProxy (org.springframework.web.filter) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) doFilterInternal:164, SessionRepositoryFilter (org.springframework.session.web.http) doFilter:80, OncePerRequestFilter (org.springframework.session.web.http) invokeDelegate:346, DelegatingFilterProxy (org.springframework.web.filter) doFilter:262, DelegatingFilterProxy (org.springframework.web.filter) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) doFilterInternal:197, CharacterEncodingFilter (org.springframework.web.filter) doFilter:107, OncePerRequestFilter (org.springframework.web.filter) internalDoFilter:193, ApplicationFilterChain (org.apache.catalina.core) doFilter:166, ApplicationFilterChain (org.apache.catalina.core) invoke:199, StandardWrapperValve (org.apache.catalina.core) invoke:96, StandardContextValve (org.apache.catalina.core) invoke:475, AuthenticatorBase (org.apache.catalina.authenticator) invoke:140, StandardHostValve (org.apache.catalina.core) invoke:80, ErrorReportValve (org.apache.catalina.valves) invoke:625, AbstractAccessLogValve (org.apache.catalina.valves) invoke:87, StandardEngineValve (org.apache.catalina.core) service:342, CoyoteAdapter (org.apache.catalina.connector) service:498, Http11Processor (org.apache.coyote.http11) process:66, AbstractProcessorLight (org.apache.coyote) process:796, AbstractProtocol$ConnectionHandler (org.apache.coyote) doRun:1372, NioEndpoint$SocketProcessor (org.apache.tomcat.util.net) run:49, SocketProcessorBase (org.apache.tomcat.util.net) runWorker:1149, ThreadPoolExecutor (java.util.concurrent) run:624, ThreadPoolExecutor$Worker (java.util.concurrent) run:61, TaskThread$WrappingRunnable (org.apache.tomcat.util.threads) run:748, Thread (java.lang) #### 异常堆栈 #### ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77) at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) at com.sun.proxy.$Proxy51.selectOne(Unknown Source) at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:99) at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61) at com.sun.proxy.$Proxy61.test(Unknown Source) 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.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:85) at sun.reflect.GeneratedMethodAccessor193.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:629) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:618) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:70) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213) at com.sun.proxy.$Proxy62.test(Unknown Source) at io.helloworlde.github.service.SystemServiceImpl.test(SystemServiceImpl.java:453) at io.helloworlde.github.service.SystemServiceImpl$$FastClassBySpringCGLIB$$ccedf5b2.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:652) at io.helloworlde.github.service.SystemServiceImpl$$EnhancerBySpringCGLIB$$f63e5835.getSystemConfiguration(<generated>) 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:205) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:116) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:897) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) at javax.servlet.http.HttpServlet.service(HttpServlet.java:634) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) 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 com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:123) 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.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.apache.shiro.web.servlet.AbstractShiroFilter.executeChain(AbstractShiroFilter.java:449) at org.apache.shiro.web.servlet.AbstractShiroFilter$1.call(AbstractShiroFilter.java:365) at org.apache.shiro.subject.support.SubjectCallable.doCall(SubjectCallable.java:90) at org.apache.shiro.subject.support.SubjectCallable.call(SubjectCallable.java:83) at org.apache.shiro.subject.support.DelegatingSubject.execute(DelegatingSubject.java:383) at org.apache.shiro.web.servlet.AbstractShiroFilter.doFilterInternal(AbstractShiroFilter.java:362) at org.apache.shiro.web.servlet.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:125) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) at org.springframework.session.web.http.SessionRepositoryFilter.doFilterInternal(SessionRepositoryFilter.java:164) at org.springframework.session.web.http.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:80) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262) 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:197) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) 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:199) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:475) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:625) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:498) at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:796) at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1372) 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.exceptions.PersistenceException: ### Error querying database. Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String ### Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:150) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:141) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:77) 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:433) ... 98 more Caused by: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String at org.apache.ibatis.ognl.OgnlOps.compareWithConversion(OgnlOps.java:93) at org.apache.ibatis.ognl.OgnlOps.isEqual(OgnlOps.java:143) at org.apache.ibatis.ognl.OgnlOps.equal(OgnlOps.java:802) at org.apache.ibatis.ognl.ASTNotEq.getValueBody(ASTNotEq.java:53) at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) at org.apache.ibatis.ognl.ASTAnd.getValueBody(ASTAnd.java:61) at org.apache.ibatis.ognl.SimpleNode.evaluateGetValueBody(SimpleNode.java:212) at org.apache.ibatis.ognl.SimpleNode.getValue(SimpleNode.java:258) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:493) at org.apache.ibatis.ognl.Ognl.getValue(Ognl.java:457) at org.apache.ibatis.scripting.xmltags.OgnlCache.getValue(OgnlCache.java:46) 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.apply(MixedSqlNode.java:33) at org.apache.ibatis.scripting.xmltags.DynamicSqlSource.getBoundSql(DynamicSqlSource.java:41) at org.apache.ibatis.mapping.MappedStatement.getBoundSql(MappedStatement.java:293) at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61) at com.sun.proxy.$Proxy248.query(Unknown Source) at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148) ... 105 more [java.util.RandomAccessSubList and java.lang.String]: https://github.com/mybatis/mybatis-3/issues/445 [3.3.1 java.lang.IllegalArgumentException_ invalid comparison_ java.util.Date and java.lang.String]: https://github.com/mybatis/mybatis-3/issues/1340
还没有评论,来说两句吧...