项目运行异常：Parameter index out of range (1 > number of parameters, which is 0).

最新推荐文章于 2020-04-24 18:23:03 发布
最新推荐文章于 2020-04-24 18:23:03 发布
阅读量482 收藏
点赞数
分类专栏： java 文章标签： sql Navicat java
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/weixin_43886300/article/details/101697402
版权

以下为错误信息：

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property='projectId', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 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 (1 > number of parameters, which is 0).
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:78)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:440)
	at com.sun.proxy.$Proxy74.selectList(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectList(SqlSessionTemplate.java:223)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.executeForMany(MybatisMapperMethod.java:168)
	at com.baomidou.mybatisplus.core.override.MybatisMapperMethod.execute(MybatisMapperMethod.java:82)
	at com.baomidou.mybatisplus.core.override.MybatisMapperProxy.invoke(MybatisMapperProxy.java:61)
	at com.sun.proxy.$Proxy77.listAppApprove(Unknown Source)
	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.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.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139)
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
	at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
	at com.sun.proxy.$Proxy79.listAppApprove(Unknown Source)
	at cn.nx.recruitment.modules.app.service.impl.AppApproveServiceImpl.listAppApprove(AppApproveServiceImpl.java:43)
	at cn.nx.recruitment.modules.app.service.impl.AppApproveServiceImpl$$FastClassBySpringCGLIB$$fae99c7b.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:684)
	at cn.nx.recruitment.modules.app.service.impl.AppApproveServiceImpl$$EnhancerBySpringCGLIB$$74e37634.listAppApprove(<generated>)
	at cn.nx.recruitment.modules.app.controller.AppApproveController.listAppApprove(AppApproveController.java:33)
	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:104)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:892)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:797)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1039)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:942)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1005)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:908)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:660)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:882)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	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 cn.nx.recruitment.config.RequestHandle.doFilter(RequestHandle.java:95)
	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.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
	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.FormContentFilter.doFilterInternal(FormContentFilter.java:92)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
	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.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:93)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
	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:200)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:109)
	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:490)
	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:408)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:853)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1587)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
	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='projectId', mode=IN, javaType=class java.lang.Long, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 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 (1 > number of parameters, which is 0).
	at com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:227)
	at org.apache.ibatis.executor.statement.PreparedStatementHandler.parameterize(PreparedStatementHandler.java:94)
	at org.apache.ibatis.executor.statement.RoutingStatementHandler.parameterize(RoutingStatementHandler.java:64)
	at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:87)
	at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:62)
	at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:324)
	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:147)
	at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:140)
	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:426)
	... 83 more
Caused by: org.apache.ibatis.type.TypeException: Error setting non null for parameter #1 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 (1 > number of parameters, which is 0).
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:71)
	at com.baomidou.mybatisplus.core.MybatisDefaultParameterHandler.setParameters(MybatisDefaultParameterHandler.java:225)
	... 97 more
Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.ClientPreparedStatement.checkBounds(ClientPreparedStatement.java:1370)
	at com.mysql.cj.jdbc.ClientPreparedStatement.getCoreParameterIndex(ClientPreparedStatement.java:1383)
	at com.mysql.cj.jdbc.ClientPreparedStatement.setLong(ClientPreparedStatement.java:1578)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setLong(FilterChainImpl.java:3261)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setLong(FilterAdapter.java:1265)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setLong(FilterChainImpl.java:3258)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setLong(FilterAdapter.java:1265)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setLong(FilterChainImpl.java:3258)
	at com.alibaba.druid.filter.FilterAdapter.preparedStatement_setLong(FilterAdapter.java:1265)
	at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_setLong(FilterChainImpl.java:3258)
	at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.setLong(PreparedStatementProxyImpl.java:395)
	at com.alibaba.druid.pool.DruidPooledPreparedStatement.setLong(DruidPooledPreparedStatement.java:326)
	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.logging.jdbc.PreparedStatementLogger.invoke(PreparedStatementLogger.java:67)
	at com.sun.proxy.$Proxy176.setLong(Unknown Source)
	at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:31)
	at org.apache.ibatis.type.LongTypeHandler.setNonNullParameter(LongTypeHandler.java:26)
	at org.apache.ibatis.type.BaseTypeHandler.setParameter(BaseTypeHandler.java:69)
	... 98 more

实际问题：由于使用idea编程，还是黑暗背景的，再加上SQL语句全写在@Select语句块中，导致SQL语句中多出个 · 标点符号，死活没找到。最后将SQL语句copy到Navicat中，才检测出来，真的心累。。。。
总结： 对已有SQL修改时，一定要注意标点符号，别自己坑自己。。

做个高贵的单身狗
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Parameter index out of range (1 > number of parameters, which is 0)......
马句
08-07 952
今天在操作Mybatis查询数据的时候出现了这个问题 Parameter index out of range (1 > number of parameters, which is 0) 结合网上各位大佬给出的解答，终于将其解决。 问题出在手写sql放入mybatis 的xml中执行出错。 这个报错的含义指的是第一个参数的问题，也就是说问题出在？左右。 然后仔细观察，就是接收参...
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执行sql的时候为什么会出现Parameter index out of range (1 > number of parameters, which is 0)？...
T123012009065的专栏
07-25 837
写like语句的时候 一般都会写成 like '% %' 在mybatis里面写就是应该是 like '%${name} %' 而不是'%#{name}%' ${name}是不带单引号的，而#{name}是带单引号的 ...
mybatis中Parameter index out of range (1 > number of parameters, which is 0).
weixin_33936401的博客
06-26 112
在mybatis里面写就是应该是 like '%${name}%' 而不是'%#{name}%' ${name}是不带单引号的，而#{name}是带单引号的 所以，当你用到 like '%#{name}%' 会报这种错误 转载于:https://www.cnblogs.com/aeolian/p/9227593.html...
mybatis Parameter index out of range (1 > number of parameters, which is 0)
勿忘初心
08-11 9351
今天遇到了一个有意思的问题，看错误信息提示，好像是有个参数没有匹配上，具体错误信息如下： ### SQL: SELECT count(*) FROM (SELECT * FROM testTable) table_count ; SQL []; Parameter index out of range (1 > number of parameters, which is 0).; nest
mybatis报Parameter index out of range (1 > number of parameters, which is 0).
huangbaokang的博客
08-15 912
<select id="getLoginArr" parameterType="HbkQuery" resultMap="HbkQueryResult"> SELECT alldays.*,IFNULL(temp.login_num,0) login_num FROM (SELECT CONCAT('#{year}','-','#{month}','-',aa.stats_day)...
Handbook of Research on Soft Computing and Nature-Inspired Algorithms
06-19
Theissueofparametersettingofanalgorithmisoneofthemostpromisingareasofresearch.Particle SwarmOptimization(PSO)ispopulationbasedmethod.Theperformance...
MySQL 数据库 like 语句通配符模糊查询小结
12-14
MySQL 报错：Parameter index out of range (1 ＞ number of parameters, which is 0)——MySQL 数据库 like 语句通配符模糊查询小结 前言 今天在使用MySQL语句执行增删改查操作时，控制台报出了以下错误：Parameter...
WPTools.v6.29.1.Pro
08-26
+ There is an overloaded LoadFromString which expects a WideString as parameter (Delphi 6+) - The Setup named the Delphi 2009 files "Delphi 2005" due to a typo. (Delphi 2005 units are not included any...
JLink_Windows_V648.zip
07-29
Firmware: Flasher Portable PLUS: Number of bytes to program was not calculate correctly, progress bar showed wrong percentage. Fixed. Firmware: Flasher Portable PLUS: Open flash loaders for RISC-V did...
MyBatis报错Parameter index out of range (1 > number of parameters, which is 0)
theStrongestPit的博客
07-26 471
报错信息： [WARN][batch]2019-07-2614:09:15:135435[WARN][http-apr-8080-exec-1](AbstractHandlerExceptionResolver.java,189)-Handlerexecutionresultedinexception: ###Errorqueryingdatabase....
mybatis错误Parameter index out of range (1 > number of parameters, which is 0)
Vicco的博客
11-09 6621
使用mybatis查询时出现Parameter index out of range (1 > number of parameters, which is 0)的错误，网上总结主要为以下两个方面，而我的sql语句都没有涉及到。 1、模糊查询--like 的使用 Parameter index out of range (1 > number of parameters, whic
Parameter index out of range (1 > number of parameters, which is 0).
Agnesyuan的博客
04-12 2257
    在运行结果的时候遇到问题Parameter index out of range (1 &gt; number of parameters, which is 0).在网上搜了一下，很多人说是因为在写sql语句设置参数的时候，没有相应的问号与之匹配或者根本就没有？号，比如这条语句insert into t_courler(UserId,CourlerTitle,CourlerContent...
sql异常之Parameter index out of range (1 > number of parameters, which is 0)
qq1049153718的专栏
11-22 2213
今天在写代码的时候调用数据库代参数存储过程中遇到了这么个错误            java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).           第一感觉是语句写错，便检查了一下代码如下:           String sql= "DELETE F
操作MySQL数据库报出：Parameter index out of range (1 > number of parameters, which is
热门推荐
ZDX_Y的博客
07-30 2万+
对MySQL进行insert操作，控制台抛出以下错误：Parameter index out of range (1 > number of parameters, which is 0) 调试了半天后查找资料后，问题就出在当设置参数时，没有相应的问号与之匹配或者根本就没有？号、 String sql = "insert into t_courler
Parameter index out of range (1 > number of parameters, which is 0)
CodingUp的博客
08-30 322
这类问题一般是mybatis中语句sql写错了 insert into user (username,birthday,address,sex) values {#{username},#{birthday},#{address},#{sex}} 很明显，values后不用大括号，用小括号！！  ...
eclipse出现Parameter index out of range (1 > number of parameters, which is 0)报错
qq_44893880的博客
04-24 6484
今天小蝈在做学生信息管理系统的时候，眼看大功告成，可谁能想运行后。。。啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊啊。。一个bug。。。。你们都懂。。。呃呃呃额额。。。。 话不多说，说多了都是痛，直接上图。。 遇到了Parameter index out of range (1 > number of parameters, which is 0) ，检查了很多遍错误。最后终于发现，原来sql...
Cause: Parameter index out of range (1 > number of parameters, which is 0).
liveAndCoding的博客
02-06 388
nested exception is org.apache.ibatis.type.TypeException: Could not set parameters for mapping: ParameterMapping{property=’copyclientid’, mode=IN, javaType=class java.lang.String, jdbcType=null, num
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is
最新发布
03-27
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 这个异常通常在使用JDBC进行数据库操作时出现。它表示参数索引超出了参数的数量范围。这个错误通常是由于以下几种情况...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值