mybatis-plus报nested exception is org.apache.ibatis.type.TypeException:

最新推荐文章于 2025-04-06 11:10:13 发布

奔跑的小奶狗

最新推荐文章于 2025-04-06 11:10:13 发布

阅读量2.3k

点赞数 2

分类专栏：个人总结文章标签： java

本文链接：https://blog.youkuaiyun.com/weixin_39793118/article/details/124124914

版权

这篇博客主要介绍了在使用MyBatis-Plus时遇到的'nested exception is org.apache.ibatis.type.TypeException'错误，包括详细的错误日志，并提供了相应的解决办法和配置步骤。

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

配套错误日志和图片一样

2022-04-12 01:13:27.660 [XNIO-1 task-2] ERROR com.fardo.common.exception.FdExceptionHandler:72 - nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{
   property='ew.paramNameValuePairs.MPGENVAL1', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111
org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{
   property='ew.paramNameValuePairs.MPGENVAL1', mode=IN, javaType=class java.lang.Object, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting null for parameter #1 with JdbcType OTHER . Try setting a different JdbcType for this parameter or a different jdbcTypeForNull configuration property. Cause: java.sql.SQLException: Invalid column type: 1111
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
at com.sun.proxy.$Proxy173.selectOne(Unknown Source)
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:89)
at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:62)
at com.sun.proxy.$Proxy312.selectOne(Unknown Source)
at com.baomidou.mybatisplus.extension.service.impl.ServiceImpl.getOne(ServiceImpl.java:254)
at com.baomidou.mybatisplus.extension.service.IService.getOne(IService.java:192)
at com.baomidou.mybatisplus.extension.service.IService$$FastClassBySpringCGLIB$$f8525d18.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
at com.fardo.modules.znbl.ywxt.service.impl.BlDmBzZzmmServiceImpl$$EnhancerBySpringCGLIB$$f023210e.getOne(<generated>)
at com.fardo.modules.znbl.ywxt.util.KbwsCommonUtil.handle(KbwsCommonUtil.java:283)
at com.fardo.modules.znbl.ywxt.api.ApiKbwsController.recordDocuments(ApiKbwsController.java:277)
at com.fardo.modules.znbl.ywxt.api.ApiKbwsController$$FastClassBySpringCGLIB$$f5dd0131.invoke(<generated>)
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:<