使用ibatis抛出java.lang.IllegalArgumentException实则抛出:NestedSQLException异常

最新推荐文章于 2023-06-29 19:01:30 发布
原创 最新推荐文章于 2023-06-29 19:01:30 发布 · 2.5k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#ibatis #测试

在测试库上运行程序无误，但在正式库上遇到java.lang.IllegalArgumentException错误。通过对比发现，正式库中有空字段而测试库没有。解决方法是为具有空值的字段赋默认值。最终问题定位为数据一致性问题。

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

程序在测试库上运行没有任何问题,一旦在正试库上运行就报错了。抛出了如下错误：

java.lang.IllegalArgumentException

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.ibatis.sqlmap.engine.accessplan.PropertyAccessPlan.setProperties(PropertyAccessPlan.java:46)
at com.ibatis.sqlmap.engine.exchange.JavaBeanDataExchange.setData(JavaBeanDataExchange.java:112)
at com.ibatis.sqlmap.engine.mapping.result.BasicResultMap.setResultObjectValues(BasicResultMap.java:373)
at com.ibatis.sqlmap.engine.mapping.statement.RowHandlerCallback.handleResultObject(RowHandlerCallback.java:64)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleResults(SqlExecutor.java:382)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.handleMultipleResults(SqlExecutor.java:301)
at com.ibatis.sqlmap.engine.execution.SqlExecutor.executeQuery(SqlExecutor.java:190)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.sqlExecuteQuery(GeneralStatement.java:205)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryWithCallback(GeneralStatement.java:173)
at com.ibatis.sqlmap.engine.mapping.statement.GeneralStatement.executeQueryForList(GeneralStatement.java:123)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:615)
at com.ibatis.sqlmap.engine.impl.SqlMapExecutorDelegate.queryForList(SqlMapExecutorDelegate.java:589)
at com.ibatis.sqlmap.engine.impl.SqlMapSessionImpl.queryForList(SqlMapSessionImpl.java:118)
at org.springframework.orm.ibatis.SqlMapClientTemplate$3.doInSqlMapClient(SqlMapClientTemplate.java:263)
at org.springframework.orm.ibatis.SqlMapClientTemplate.execute(SqlMapClientTemplate.java:188)
at org.springframework.orm.ibatis.SqlMapClientTemplate.executeWithListResult(SqlMapClientTemplate.java:214)
at org.springframework.orm.ibatis.SqlMapClientTemplate.queryForList(SqlMapClientTemplate.java:261)
at com.nyl.crm.dao.BaseDaoImpl.queryForList(BaseDaoImpl.java:69)
at com.nyl.crm.service.BaseServiceImpl.getResultList(BaseServiceImpl.java:79)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:318)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:203)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:162)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:209)
at $Proxy5.getResultList(Unknown Source)
at com.nyl.crm.action.SysModelInfoAction.execute(SysModelInfoAction.java:38)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:404)
at com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:267)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:229)
at com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:221)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:150)
at org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:48)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:167)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:105)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:83)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:207)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:74)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:127)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.ProfilingActivationInterceptor.intercept(ProfilingActivationInterceptor.java:107)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:206)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:115)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:143)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:121)
at com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:86)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:170)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:123)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:224)
at com.opensymphony.xwork2.DefaultActionInvocation$2.doProfiling(DefaultActionInvocation.java:223)
at com.opensymphony.xwork2.util.profiling.UtilTimerStack.profile(UtilTimerStack.java:455)
at com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:221)
at org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:50)
at org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:504)
at org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:419)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

at java.lang.Thread.run(Thread.java:595)

查了半天，原来是数据问题，

在测试库上查出的记录每个字段都不为空

如图:

在正式库上查出的记录，有空字段，

如图：

解决方法：只要把具有空值的字段赋上默认值就能解决.

如图：


Cause: java.lang.IllegalArgumentException: No enum constant org.apache.ibatis.type.JdbcType.Integer
weixin_39417324的博客
09-01 1635
原因：有多种，主要就是在mybatis中设置的字段类型和数据库表的字段类型对不起来。可以看到，jdbcType的类型是Integer，
解决java.lang.IllegalArgumentException:Property ‘sqlSessionFactory‘ or ‘sqlSessionTemplate‘ are requir
念兮为美
11-28 1万+
解决java.lang.IllegalArgumentException: Property 'sqlSessionFactory' or 'sqlSessionTemplate' are required的问题
SQLException
12-08
数据库的各种信息的异常，一目了然，很方便
使用ibatis抛出NestedSQLException异常
neweastsun的专栏
08-14 1万+
使用ibatis抛出NestedSQLException异常     昨天还很正常的程序什么都没改动，今天运行就抛出如下异常： com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred in com/contract/ibatis/mapping/PayInfo.xml. --- Th
nested exception is java.sql.SQLException: connection disabled
weixin_45626288的博客
06-29 1万+
当使用Spring Boot连接数据库时，出现"nested exception is java.sql.SQLException: connection disabled"异常可能是由于数据库配置错误、数据库服务器故障、连接池配置问题或数据库访问权限不足引起的。数据库权限问题：数据库用户可能没有足够的权限来连接数据库或执行所需的操作。验证数据库权限：确保数据库用户具有足够的权限来连接数据库和执行所需的操作。检查数据库连接配置：确保数据库连接的URL、用户名和密码正确配置，并与实际数据库的凭据匹配。
【异常】IllegalArgumentException
dyn的博客
12-25 472
异常详情 org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'objectMapperConfigurer' defined in class path resource [springfox/documentation/spring/web/SpringfoxWebMvcC...
com.ibatis.common.jdbc.exception.NestedSQLException 今天用ibatis做数据查询时发生了这个异常
HouYing
03-16 1万+
Error executing query for object.  Cause: com.ibatis.common.jdbc.exception.NestedSQLException:   --- The error occurred in com/yc/ycportal/blockimp/sqlmapdao/sqlmap/ycrepliesmap.xml.  --- The error oc
Mybatis报错Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang
Alomed的博客
03-29 1849
Mybatis报错Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection do
leaftong的博客
07-14 5481
Error querying database. Cause: java.lang.IllegalArgumentException: Mapped Statements collection do 错误
Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for
无知人生，记录点滴
03-12 1万+
Cause: java.lang.IllegalArgumentException: Mapped Statements collection does not contain value for User.pageSelect org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.e...
使用ibatis时Error setting a property: IllegalArgumentException 异常
kobe_hz的博客
04-20 372
在使用ibatis做数据访问层时，有时会出现Error setting a property: IllegalArgumentException 异常， 该异常出现的一个原因是因为数据库中有null字段，尤其是非字符串字段，比如int类型，ibatis会使用Domain对象的set方法将数据库拿出来的值赋给Domain对象的属性，Domain对象属性为int时，将数据库中拿出的null赋值给i...
com.ibatis.common.jdbc.exception.NestedSQLException:
初来北京辛苦可怜的黑的博客
12-03 687
问题描述： com.ibatis.common.jdbc.exception.NestedSQLException: — The error occurred in com/hyjx/framework/ibatis_default.xml. — The error occurred while applying a parameter map. — Check the bgsnotice.update-InlineParameterMap. — Check the statement (update fa
异常：nested exception is java.sql.SQLException: Column count doesn‘t match value count at row 1
qq_41962328的博客
07-06 5095
错误信息：org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into emp values(null,'张三',24,'男')]; nested exception is java.sql.SQLException: Column count doesn't match value count at row 1 原因：数据库表的字段名数量和你插入数据的成员信息字段数量不匹配
java.lang.IllegalStateException
Aflowerseed的博客
01-30 347
java.lang.IllegalStateException: ‘sqlSessionFactory’: no matching editors or conversion strategy found org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name ‘berthPlanController’: Unsatisfied dependency expressed t
nested exception is java.sql.SQLException: oracle.jdbc.driver.OracleDriver
y15201653575的博客
06-28 9026
出现问题的原因有很多种，我这里说下我出现的情况： 1、我是用maven 管理项目，当点击deploy的按钮后，出现报错 2、项目是从别的地方的导入的从报错的信息，Cannot resolve reference to bean 'sqlSessionFactory' while setting bean property 'sqlSessionFactory'; nested exce...
com.ibatis.common.jdbc.exception.NestedSQLException:原因分析
热门推荐
Think
12-07 2万+
com.ibatis.common.jdbc.exception.NestedSQLException: --- The error occurred in com/ibatis/student.xml. --- The error occurred while applying a parameter map. --- Check the insertStudent-InlineP
iBATIS，一个空格引发的NestedSQLException异常
无居之所
07-03 1773
近日，做项目用到了iBATIS，coding期间，遇到一个问题，iBATIS抛出NestedSQLException异常，捣腾好长时间，终于找到问题所在，令人吐血的是：这是“一个空格引发的异常”。 具体如下： [code="sql"] select * from orders …… …… [/code] [color=red]*号与from之间的空格，原本是半角的...
com.ibatis.common.jdbc.exception.NestedSQLException:最新原因分析
王大师企业官方博客
11-30 1175
com.ibatis.common.jdbc.exception.NestedSQLException:原因分析 学习目标（传送门） 1、掌握 JAVA入门到进阶知识(持续写作中……） 2、学会Oracle数据库用法(创作中……） 3、手把手教你vbs脚本制作(完善中……） 4、牛逼哄哄的 IDEA编程利器(编写中……） 5、吐血整理的 面试技巧(更新中……） 本人详解 作者：王文峰，参加过 优快云 2020年度博客之星，《Java王大师王天师》作者 公众号：山峯草堂，非技术多篇文章，专注于天道酬勤
nested exception is 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
最新发布
07-14
### MyBatis 中 `java.util.Date` 与 `java.lang.String` 类型比较错误的解决方法 在使用 MyBatis 进行数据库操作时，如果在 XML 映射文件中对 `java.util.Date` 类型的参数与字符串进行比较，会抛出 `java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String` 异常。此类问题通常出现在 `<if>` 标签的条件判断中，例如： ```xml <if test="createTime != null and createTime != ''"> date(create_time) = date(#{createTime, jdbcType=TIMESTAMP}) </if> ``` 上述代码中，`createTime` 是 `Date` 类型，但试图与空字符串 `''` 比较，导致类型不匹配并抛出异常 [^3]。 #### 解决方案 1. **避免对 Date 类型字段与字符串进行直接比较** 在 `<if>` 条件中，仅保留对 `null` 的判断即可，无需与空字符串比较。修改后的表达式如下： ```xml <if test="createTime != null"> date(create_time) = date(#{createTime, jdbcType=TIMESTAMP}) </if> ``` 此方式可以有效规避类型比较异常，并且仍然确保只在 `createTime` 不为 `null` 时执行相应的 SQL 条件 [^2]。 2. **升级 MyBatis 版本** 如果项目允许，建议将 MyBatis 升级到 3.4.x 或更高版本。这些后续版本修复了 3.3.0 中引入的表达式解析 bug，从而支持更复杂的条件判断逻辑而不会引发类型比较异常 [^1]。 3. **在 Java 层进行预处理** 如果业务需求确实需要对 `Date` 和字符串进行某种形式的比较，可以在 Java 层面对参数进行预处理，例如将 `Date` 转换为字符串格式后再传递给 MyBatis，或者通过自定义类型处理器（`TypeHandler`）来统一处理不同类型的比较逻辑。 例如，在 Java 中将日期转换为字符串： ```java SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd"); String createTimeStr = (createTime != null) ? sdf.format(createTime) : ""; ``` 然后在 MyBatis 的 XML 文件中使用该字符串变量进行比较： ```xml <if test="createTimeStr != null and createTimeStr != ''"> date(create_time) = date(#{createTimeStr, jdbcType=VARCHAR}) </if> ``` 这种方式可以规避类型不一致的问题，同时保持查询逻辑的完整性 [^4]。 ---
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值