Try setting a different JdbcType for this parameter or a different configuration property

最新推荐文章于 2023-08-11 17:22:48 发布

m0_67402013

最新推荐文章于 2023-08-11 17:22:48 发布

阅读量2k

点赞数

CC 4.0 BY-SA版权

分类专栏：面试阿里巴巴文章标签： mybatis java spring 算法

本文链接：https://blog.youkuaiyun.com/m0_67402013/article/details/126812243

这篇博客主要讨论了在使用MyBatis时遇到的JdbcType错误，报错提示涉及参数mapping和数据类型不匹配。博主分析了可能的原因，包括DAO中数据类型与SQL中不一致、parameterType配置错误等，并提供了相应的解决方案。此外，还分享了关于Java开发者提升技能的心得和一份Java学习资源。

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

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='auditStatus', mode=IN, javaType=class java.lang.Integer, jdbcType=VARCHAR, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType VARCHAR . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.lang.ClassCastException
?? ?at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:92)
?? ?at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
?? ?at com.sun.proxy.$Proxy26.selectOne(Unknown Source)
?? ?at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:159)
?? ?at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:87)
?? ?at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:93)
?? ?at com.sun.proxy.$Proxy85.getProcModel(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:343)
?? ?at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
?? ?at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
?? ?at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithi