踩坑日记——mybatis使用注释导致报错Parameter index out of range (2 ＞ number of parameters, which is 1).

最新推荐文章于 2022-04-05 16:54:45 发布
最新推荐文章于 2022-04-05 16:54:45 发布
阅读量743 收藏
点赞数
分类专栏： Java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/Maricle_Again/article/details/115397179
版权 
  <if test="planUnitPageDTO.planStatus!=null">
                    <choose>
                        <when test="planUnitPageDTO.planStatus==3">
                            and (p.exceptionStatus!=',' or p.keywordsNum=0 or p.unitNum=0)
                        </when>
                        <otherwise>
                            and p.exceptionStatus=',' and p.keywordsNum>0 and p.unitNum>0
                            and p.status=#{planUnitPageDTO.planStatus}
                        </otherwise>
                    </choose>
                    -- and p.status = #{planUnitPageDTO.planStatus}
                </if>

*因为最近经常使用mybatis-plus ，今天有个复杂的join sql用mybatis-plus拼接太麻烦，所以在xml里手写sql，习惯性的把不要的代码注释后，发现这个筛选功能一用就失效了，预编译后把sql放在数据库执行，竟然是正常执行，后来仔细排查后发现，注释的原因，把注释去掉就好了

完成报错如下：

Error: Method queryTotal execution error !
org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='planUnitPageDTO.planStatus', 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 non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
	at com.baomidou.mybatisplus.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:276)
	at com.baomidou.mybatisplus.plugins.PaginationInterceptor.queryTotal(PaginationInterceptor.java:159)
	at com.baomidou.mybatisplus.plugins.PaginationInterceptor.intercept(PaginationInterceptor.java:126)
	at org.apache.ibatis.plugin.Plugin.invoke(Plugin.java:61)
	at com.sun.proxy.$Proxy261.prepare(Unknown Source)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:85)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:326)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:156)
	at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:136)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:148)
	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)
	at com.sun.proxy.$Proxy123.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:238)
	at org.apache.ibatis.binding.MapperMethod.executeForMany(MapperMethod.java:137)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:76)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy136.pageAdmin(Unknown Source)
	at com.zhaosw.base.bid.service.service.impl.PlanUnitServiceImpl.pageAdmin(PlanUnitServiceImpl.java:282)
	at com.zhaosw.base.bid.service.service.impl.PlanUnitServiceImpl$$FastClassBySpringCGLIB$$45a6ea99.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687)
	at com.zhaosw.base.bid.service.service.impl.PlanUnitServiceImpl$$EnhancerBySpringCGLIB$$ca5b18bd.pageAdmin(<generated>)
	at com.zhaosw.base.bid.service.Biz.impl.PlanUnitBizServiceImpl.pageAdmin(PlanUnitBizServiceImpl.java:1079)
	at com.zhaosw.base.bid.service.Biz.impl.PlanUnitBizServiceImpl$$FastClassBySpringCGLIB$$1fd9bafc.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.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95)
	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.zhaosw.base.bid.service.Biz.impl.PlanUnitBizServiceImpl$$EnhancerBySpringCGLIB$$50e8ba51.pageAdmin(<generated>)
	at com.zhaosw.base.bid.service.feign.PlanUnitClient.pageAdmin(PlanUnitClient.java:101)
	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: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:879)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793)
	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:665)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
	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 org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	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.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
	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:202)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:541)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:139)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:343)
	at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:373)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:868)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1594)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	at java.lang.Thread.run(Thread.java:745)
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:55)
	at com.baomidou.mybatisplus.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:274)
	... 87 more
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #2 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. Cause: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:55)
	at org.apache.ibatis.type.UnknownTypeHandler.setNonNullParameter(UnknownTypeHandler.java:45)
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:53)
	... 88 more
Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:896)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:885)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
	at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3319)
	at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3304)
	at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3341)
	at com.mysql.jdbc.PreparedStatement.setInt(PreparedStatement.java:3294)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setInt(FilterChainImpl.java:2893)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setInt(FilterAdapter.java:1259)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setInt(FilterChainImpl.java:2890)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.setInt(PreparedStatementProxyImpl.java:386)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setInt(DruidPooledPreparedStatement.java:315)
	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.apache.ibatis.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
	at com.sun.proxy.$Proxy263.setInt(Unknown Source)
	at org.apache.ibatis.type.IntegerTypeHandler.setNonNullParameter(IntegerTypeHandler.java:31)
	at org.apache.ibatis.type.IntegerTypeHandler.setNonNullParameter(IntegerTypeHandler.java:26)
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:53)
	... 90 more
Maricle_1901
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 1
    评论
专栏目录
使用mybatis解决sql报错： Parameter index out of range (1 ＞ number of parameters, which is 0）。
腐草灬为萤的博客
08-11 784
报的异常信息： java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0). ...... ...... ...... 修改前的代码： @Select("select * from t_goods where goodsname like '%#{goodsname}%'") @Results( { @Re
报错：Parameter index out of range (2 」 number of parameters, which is 1)，mybatis使用注释不当
键盘狂想曲的博客
07-08 1322
今天在工作修改代码遇到mybatis的xml中注释的坑： 在使用mybatis进行查询的时候报错：Parameter index out of range (2 > number of parameters, which is 1)， 一开始看xml中语句和参数是没问题的，但是还是依旧报这个错误，最后发现原来是用的注释是 – 并且注释中有#{paramer}，这样mybatis在解析xml时会默认为有一个参数，所以会报错。 当时注释的代码片段如下： <select id="pageQ.
Parameter index out of range (* ＞ number of parameters, which is *) mybatis-plus分页查询是出现的问题
weixin_50899360的博客
07-30 615
https://blog.csdn.net/weixin_42052678/article/details/109125745 还有一个问题是mybatis-plus自动生成的分页查询语句后面有LIMIT？之后报错 看文章 看完这个文章还解决不了 把分页查询@bean注释掉 启动 再调接口试试看看sql语句中LIMIT？还有没有 然后把注释去掉 重启 再试试 我是这样解决的 如果你有别的方法 请指出 谢谢 ...
MyBatis出现错误 Parameter index out of range (2 ＞ number of parameters, which is 1)
weixin_43906233的博客
04-05 645
Parameter index out of range (2 > number of parameters, which is 1) 错误解决方法
mybatis使用注释不当报错Parameter index out of range (2 > number of parameters, which is 1)
TankyZhang的博客
10-26 1399
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 欢迎使用Ma...
Mabatis错误提示Parameter index out of range的处理方法
08-27
在上面的示例中，错误信息显示为"Parameter index out of range (1 > number of parameters, which is 0)"，这表明参数索引超出了范围。解决方法是检查参数索引，确保参数索引从1开始。 Parameter index out of ...
【MyBatis学习笔记三】——MyBatis使用Log4j.zip
05-29
【MyBatis学习笔记三】——MyBatis使用Log4j.zip 博客地址：https://blog.csdn.net/weixin_43817709/article/details/117388794
mybatis-3-config/mapper.dtd 解决mybatis头文件报错
04-10
>Window->prefenrence->XML->XML Catalog->User Specifiled Entreis->Add->Location(此处是你放dtd文件的位置例如：‪D:\mybatis\mybatis-3-config.dtd)->Key(如果更改config，此处应该是：-//mybatis.org//DTD ...
【MyBatis学习笔记五】——MyBatis注解的简单使用.zip
05-30
【MyBatis学习笔记五】——MyBatis注解的简单使用.zip 博客地址：https://blog.csdn.net/weixin_43817709/article/details/117407621
【Mybatis-Plus学习笔记二】——Mybatis-Plus进阶使用.zip
06-09
【Mybatis-Plus学习笔记二】——Mybatis-Plus进阶使用.zip 博客地址：https://blog.csdn.net/weixin_43817709/article/details/117751784
Mybatis报错：Parameter index out of range (1 ＞ number of parameters, which is 0) 解决方法
热门推荐
qq_61049292的博客
02-19 1万+
Mybatis报错：Parameter index out of range (1 > number of parameters, which is 0) 解决方法
com.github.pagehelper.PageHelper cannot be cast to org.apache.ibatis.plugin.Interceptor
yellow__star的博客
10-20 519
sqlMapConfig.xml中配置插件 出错原因: <!--配置分页插件 PageHelper 4.X使用--> <plugins> <plugin interceptor="com.github.pagehelper.PageHelper"> <property name="dialect" value="mysql"/...
【spring boot】集成了druid后，同样的mybatis模糊查询语句出错Caused by: com.alibaba.druid.sql.parser.ParserException: sy...
weixin_34220963的博客
05-21 1266
druid版本是 &lt;!-- https://mvnrepository.com/artifact/com.alibaba/druid 数据库连接池--&gt; &lt;dependency&gt; &lt;groupId&gt;com.alibaba&lt;/groupId&gt; &lt;artifactId&gt;dru...
springboot+mybatis中Parameter index out of range (3 ＞ number of parameters, which is 2).的错误
qq_38341582的博客
09-26 1296
项目场景： <!-- 修改--> <!-- boolean updateCategory(BlogCategory blogCategory);--> <update id="updateCategory" parameterType="com.atguigu.blog.entity.BlogCategory"> update tb_blog_category -- <set> <if test
在MyBatis的映射配置文件中注释遇到的问题
胡榕昆的博客
03-30 554
在MyBatis的配置文件中，标签之间如果有注释，特别是长的注释容易出现错误。例如我的IUserDao.xml如图： 运行时总是报错，还找不到原因 当我把insert标签中间的注释删除后，一切恢复正常 总结：以后不管是在使用什么框架，尽量不要在配置文件中，特别是标签与标签之间添加太多注释，否则很可能出现问题 ...
sql注释导致mybatis查询报错
cry1049208942的专栏
10-29 366
查询条件修改，将旧sql注释掉，导致报错 org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='command.bldgLevel', mode=IN, javaType=class java.lang.Object, jdbcTy
mybatis报错Parameter index out of range (3 ＞ number of parameters, which is
u012972294的博客
06-09 621
m'y'ba't java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
Mybatis报错 parameter index out of range
谢知否的博客
08-10 962
parameter index out of range
Mybatis 错误信息：Parameter index out of range
c2223164136的专栏
07-10 2200
Mybatis  的xml的Mapper文件中用到Like拼接模糊查询时出现如下错误提示：     Parameter index out of range (2 > number of parameters, which is 1) 原因是  PreparedStatement的sql中？是不能带有引号的； select * from t_user where nake like '%?%
Parameter index out of range (250 > number of parameters, which is 249)
最新发布
09-10
"Parameter index out of range (250 > number of parameters, which is 249)"是一个错误信息，通常出现在使用数据库查询时。这个错误表示使用的参数索引超出了实际的参数数量。根据引用和引用的错误信息，这个错误...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值