解决ava.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)类似问题
来源:互联网 发布:放大镜软件 编辑:程序博客网 时间:2024/05/18 15:22
遇到了Parameter index out of range (1 > number of parameters, which is 0) ,检查了很多遍错误。最后终于发现,原来sql中带有'单引号的,一个很简单的失误,我折腾了1个钟头,忘大家引以为戒啊...
java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926)
at com.mysql.jdbc.PreparedStatement.checkBounds(PreparedStatement.java:3326)
at com.mysql.jdbc.PreparedStatement.setInternal(PreparedStatement.java:3310)
at com.mysql.jdbc.PreparedStatement.setString(PreparedStatement.java:4146)
at ado.User_ADO.selOperation(User_ADO.java:60)
at unit.ProssSeverl.rundom(ProssSeverl.java:95)
at unit.ProssSeverl.regidit(ProssSeverl.java:71)
at unit.ProssSeverl.Dealwith(ProssSeverl.java:43)
at unit.ProssSeverl.service(ProssSeverl.java:36)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol
出现类似问题直接检查sql 是否存在小数点 或者sql是否存在其他语法不规范之处
- 解决ava.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)类似问题
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
- java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)
- BIRT出现java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)的问题
- java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- Caused by: java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0
- java.sql.SQLException Parameter index out of range (9 > number of parameters, which is 8)
- java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2).
- sql异常之Parameter index out of range (1 > number of parameters, which is 0)
- 造成原因java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 0).
- Caused by: java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1
- Caused by: java.sql.SQLException: Parameter index out of range (3 > number of parameters, which is 2
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0)
- Parameter index out of range (1 > number of parameters, which is 0).] with r
- ibatis Parameter index out of range (1 > number of parameters, which is 0)
- mybatis Parameter index out of range (1 > number of parameters, which is 0)
- jsp自动跳转
- git 添加远程 repository的时候提示: fatal: remote origin already exists.
- sqlite3安装使用---笔记
- 人群密度估计--CNN-based Cascaded Multi-task Learning of High-level Prior and Density Estimation for Crowd
- [CDH--官方文档]--CDH最新官方文档(最全)
- 解决ava.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0)类似问题
- codeforces 628 B . New Skateboard字符串中 有多少个4的倍数的子串
- 【bzoj 2044】三维导弹拦截(拓扑排序+最小路径覆盖)
- 业余草网站热门关键字
- JS处理img标签加载图片失败,显示默认图片
- SpringMVC搭建最小系统
- windows Apache和php环境配置
- unity Ngui渲染层级的关系
- GitHub查找优秀的开源项目和一些资源福利