【IDEA报错:Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: Para】

最新推荐文章于 2025-10-28 17:05:10 发布
原创 最新推荐文章于 2025-10-28 17:05:10 发布 · 1.6k 阅读 · 1 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#intellij-idea #apache #java #bug

文章讲述了在使用MyBatis进行数据库插入时遇到的错误，主要问题是关于NULL值无法设置到具有特定JdbcType的参数中，提示了ColumnType:1111，解决方法是添加对NULL值的判断或调整JdbcType配置。

报错如下：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='addTicketProject.prpCode', 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: 无效的列类型: 1111
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:96)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:441)
	at com.sun.proxy.$Proxy207.insert(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.insert(SqlSessionTemplate.java:272)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:60)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy$PlainMethodInvoker.invoke(MybatisMapperProxy.java:148)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:89)
	at com.sun.proxy.$Proxy326.insertHadAssignPrpDTO(Unknown Source)
	at com.iris.person.service.impl.MeetingServiceImpl.saveTicket(MeetingServiceImpl.java:156)
	at com.iris.person.service.impl.MeetingServiceImpl$$FastClassBySpringCGLIB$$bea69e64.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.validation.beanvalidation.MethodValidationInterceptor.invoke(MethodValidationInterceptor.java:119)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691)
	at com.iris.person.service.impl.MeetingServiceImpl$$EnhancerBySpringCGLIB$$4d6272cb.saveTicket(<generated>)
	at com.iris.person.controller.MeetingController.saveTicket(MeetingController.java:43)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	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:878)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:792)
	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:517)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:584)
	at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
	at io.undertow.websockets.jsr.JsrWebSocketFilter.doFilter(JsrWebSocketFilter.java:173)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at brave.servlet.TracingFilter.doFilter(TracingFilter.java:68)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at com.iris.core.boot.filter.IrisRequestFilter.doFilter(IrisRequestFilter.java:31)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at com.alibaba.druid.support.http.WebStatFilter.doFilter(WebStatFilter.java:124)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at brave.servlet.TracingFilter.doFilter(TracingFilter.java:87)
	at org.springframework.cloud.sleuth.instrument.web.LazyTracingFilter.doFilter(TraceWebServletAutoConfiguration.java:141)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:109)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
	at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
	at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
	at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
	at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
	at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
	at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
	at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
	at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
	at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
	at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
	at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
	at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
	at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
	at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
	at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
	at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
	at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
	at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
	at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
	at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
	at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
	at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
	at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
	at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='addTicketProject.prpCode', 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: 无效的列类型: 1111
	at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:215)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:63)
	at com.sun.proxy.$Proxy441.parameterize(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:88)
	at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:49)
	at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.apache.ibatis.plugin.Invocation.proceed(Invocation.java:49)
	at com.baomidou.mybatisplus.extension.plugins.MybatisPlusInterceptor.intercept(MybatisPlusInterceptor.java:106)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy440.update(Unknown Source)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:566)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:427)
	... 102 common frames omitted
Caused by: 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: 无效的列类型: 1111
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:67)
	at com.baomidou.mybatisplus.core.MybatisParameterHandler.setParameters(MybatisParameterHandler.java:213)
	... 128 common frames omitted
Caused by: java.sql.SQLException: 无效的列类型: 1111
	at oracle.jdbc.driver.OracleStatement.getInternalType(OracleStatement.java:3950)
	at oracle.jdbc.driver.OraclePreparedStatement.setNullCritical(OraclePreparedStatement.java:4559)
	at oracle.jdbc.driver.OraclePreparedStatement.setNull(OraclePreparedStatement.java:4541)
	at oracle.jdbc.driver.OraclePreparedStatementWrapper.setNull(OraclePreparedStatementWrapper.java:1283)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setNull(FilterChainImpl.java:3263)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setNull(FilterAdapter.java:1309)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setNull(FilterChainImpl.java:3260)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setNull(FilterAdapter.java:1309)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setNull(FilterChainImpl.java:3260)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.setNull(PreparedStatementProxyImpl.java:446)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setNull(DruidPooledPreparedStatement.java:270)
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:65)
	... 129 common frames omitted

出这种情况
看SQL

insert into MEETING_ADD_TICKET_PROJECT (PRP_CODE, TICKET_CODE, ORDER_NO, PRP_NUMBER, APPLY_CODE , PROJECT_NAME, SUBSIDIZE_TYPE, SUBGENERA_EXP, APPLICANT, RELY_UNIT , APPLIED_AMOUNT, PROJECT_APPROVE_NUMBER, PSN_CODE, CREATE_TIME, UPDATE_PSN_CODE , UPDATE_TIME) values (0, 10015, 10000001, null, ? , ?, ?, ?, ?, ? , ?, ?, ?, ?, ? , ?)

在这里插入图片描述
加判空就好，null无法插入到字段当中。
在这里插入图片描述

HH_JavaEE
关注
Cause: org.apache.ibatis.type.TypeException: Error setting non null for xxx with JdbcType错误的详细解决方法
念兮为美
03-27 5805
Cause: org.apache.ibatis.type.TypeException: Error setting non null for xxx with JdbcType错误的详细解决方法，比如 Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 with JdbcType null 。
解决MyBatis-Plus字段为空导致异常的方法及示例教程
理论都是虚的，代码才是王道。
01-03 1894
当使用MyBatis-Plus进行插入或更新操作时，如果某个字段的值为null，但是该字段在数据库中被设置为不可为空，就会抛出。在插入或更新数据时，如果某个字段的值为null，可以将其JdbcType设置为NULL，从而避免异常的发生。这样，在插入或更新数据时，如果字段的值为null，MyBatis-Plus会自动将其设置为null而不抛出异常。在上面的示例中，我们创建了一个User对象，并将age字段设置为null。在上面的示例中，我们创建了一个User对象，并将age字段设置为null。
Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'BaseResultMap'
热门推荐
leo_pcx
01-16 7万+
艾玛，增加个功能，改了下配置，结果异常狂抛，百思不得解啊，百度了下，从一个老兄那得到了正解，记录下，少走弯路。。 异常信息如下： Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'sqlSessionFactory' defined in Serv
我遇到的mybatis问题 org.apache.ibatis.type.TypeException: Could not set parameters for mapping
ssgo66的专栏
10-28 413
软件开发过程中，遇到和处理mybatis问题 org.apache.ibatis.type.TypeException: Could not set parameters for mapping
【实力踩坑】Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter
一宿君
12-27 2334
乍一看没啥问题，运行就是报错，无用代码也已经注释了，最后找了各种方法才发现，注释的格式不对，在 if 语句中切忌不能使用。这样就可以了，xml 的坑，又踩了一遍。
Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{
ShiXinXin_Harbour的博客
09-09 1万+
错误是这样说的: 原因:org.apache.ibatis.type。TypeException:无法设置映射参数:ParameterMapping{property=‘username’， mode=IN, javaType=class java.lang。 错点::ParameterMapping 就是下面代码里的parameterType这个参数写错了 注意注意 parameterType在...
报错：Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping:Parameter...
qq_39732897的博客
09-10 2108
Exception in thread "main" org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='user_id', mode=IN, javaType=class jav
Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping
a20714835的博客
06-21 3423
问题：Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping
解决报错：org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.atguigu
w20001118的博客
07-10 2095
spring项目中，使用mybatis编写xml以后，项目启动报错：org.apache.ibatis.binding.BindingException: Invalid bound statement (not found): com.atguigu.service.mapper.EduCourseMapper. 先说结论，此处报错的原因是maven默认情况下，只会将java文件进行编译打包，此处mybatis的mapper.xml文件没有加载进targer目录，无法读取，自然启动不了，如图mapper包
【MyBatis中主配置文件中出现的错误】Cause: org.apache.ibatis.type.TypeException: Could not resolve type alias
qq_40536254的博客
04-05 6671
org.apache.ibatis.exceptions.PersistenceException: ### Error building SqlSession. ### The error may exist in SQL Mapper Configuration ### Cause: org.apache.ibatis.builder.BuilderException: Error parsing SQL Mapper Configuration.
Caused by: org.apache.ibatis.binding.BindingException: Parameter ‘memberId‘ not found. Available par
知识改变命运，ヾ(◍°∇°◍)ﾉﾞ【求关注】
04-07 976
更新时报错
phoenix报错:Caused by: org.apache.hadoop.hbase.TableExistsException: SYSTEM.MUTEX 异常解决方法
weixin_44455388的博客
04-02 5607
1、异常如下: Setting property: [incremental, false] Setting property: [isolation, TRANSACTION_READ_COMMITTED] issuing: !connect jdbc:phoenix:node01:2181 none none org.apache.phoenix.jdbc.PhoenixDriver Conn...
Mybatis异常：org.apache.ibatis.type.TypeException: Could not set parameters for mapping
weixin_42949219的博客
06-04 2826
这是因为dao层到 mapper.xml参数注入的时候转换异常，造成此类异常原因可能有两种：1，入参类型不匹配2，like模糊查询方式不对。
ShardingSphere查询报错-org.apache.ibatis.type.TypeException: Could not set parameters for mapping
weixin_52116015的博客
05-18 1115
ShardingSphere查询报错-org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='originId', mode=IN, javaType=class java.lang.Integer, jdbcType=null ...
nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping
jdk_wangtaida的博客
05-14 4万+
前言： 在使用mybatis的时候，有的mapper接口需要传入多个类型参数的接口，这时候一不小心就会出现题目中所提到的问题，这篇文章就这种情况出现的bug讲解下bug出现的原因以及解决方案。 正文： 一、复现问题 首先看下我的各层代码： 1.post请求界面 2.controller层代码 3.service层代码 4.serviceimpl层代码 5.dao层代码 6.mapper.xml层代码 错误信息： nestedexceptionisorg...
Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping
SurepMan的博客
06-13 850
报错：Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping。parameterType等号后面只写了user，而不是com.entity.User。parameterType等号后面的属性应该和接口代码的传参相对应。是我在mybatis-config.xml加了配置代码。翻译过来大概就是映射出错。xml里的sql代码。
【Mybatis+Redis已解决】Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping:
weixin_60387745的博客
12-17 4489
Error querying database. Cause: org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='name', mode=IN, javaType=class java.lang.String, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='nul
org.apache.ibatis.type.TypeException: Could not set parameters for mapping报错
qq_64373632的博客
04-17 7566
在写javaweb项目的时候发现报的这个错误： org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='brandName', mode=IN, javaType=class java.lang.Integer, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null
若依报错：Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'SysDept'. Cause: java.lang.ClassNotFoundException: Cannot find class: SysDept
最新发布
12-06
在若依框架中出现 `Caused by: org.apache.ibatis.type.TypeException: Could not resolve type alias 'SysDept'. Cause: java.lang.ClassNotFoundException: Cannot find class: SysDept` 错误，通常是因为 MyBatis 无法找到指定的类型别名对应的类。以下是可能的解决办法： ### 1. 检查类路径和类名 确保 `SysDept` 类存在于正确的包路径下，并且类名拼写无误。例如，若类全名为 `com.ruoyi.system.domain.SysDept`，要保证该类文件确实存在于该路径中。 ### 2. 检查类型别名配置 在 MyBatis 配置文件中，确认是否正确配置了类型别名。可以在 `mybatis-config.xml` 或 Spring Boot 的配置类中添加类型别名包扫描配置。 - **在 `mybatis-config.xml` 中配置**： ```xml <typeAliases> <package name="com.ruoyi.system.domain"/> </typeAliases> ``` - **在 Spring Boot 配置类中配置**： ```java import org.mybatis.spring.annotation.MapperScan; import org.springframework.context.annotation.Configuration; @Configuration @MapperScan("com.ruoyi.system.mapper") public class MyBatisConfig { // 这里可以添加其他配置 } ``` ### 3. 检查 Mapper XML 文件 检查 Mapper XML 文件中是否正确使用了类型别名。确保 `resultType`、`parameterType` 等属性中使用的类型别名与配置一致。例如： ```xml <select id="selectSysDeptById" resultType="SysDept"> SELECT * FROM sys_dept WHERE dept_id = #{deptId} </select> ``` ### 4. 检查依赖和编译问题 确保项目的依赖配置正确，没有缺失必要的依赖。同时，尝试重新编译项目，清除缓存，避免因编译问题导致类文件未正确生成。 ### 5. 检查 IDE 缓存 有时候 IDE 的缓存会导致类加载问题，可以尝试清除 IDE 的缓存并重启 IDE。 ### 6. 检查配置文件加载顺序 确保 MyBatis 配置文件在项目启动时正确加载，避免因配置文件加载顺序问题导致类型别名配置未生效。 ### 7. 检查是否使用了自定义类型处理器 如果项目中使用了自定义类型处理器，确保其配置正确，不会影响类型别名的解析。 ### 8. 检查代码生成工具 如果使用了代码生成工具生成 Mapper XML 文件和实体类，确保生成的代码无误，没有遗漏或错误的配置。 通过以上步骤逐一排查，通常可以解决 `Could not resolve type alias` 错误。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值