Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based!
来源:互联网 发布:傲剑八卦升级数据大全 编辑:程序博客网 时间:2024/06/06 00:41
这种问题是你设置参数时下表超过了你的sql的问号(占位符)的下表,
public void excuteNamedQuery(String queryName, Object... args) { //得到session Session session = this.getSessionFactory().getCurrentSession(); Query query = session.getNamedQuery(queryName); if(args != null && args.length > 0) { int i = 0; for (Object o:args) { query.setParameter(i++,o); /*if (i > args.length) break;*/ } } query.executeUpdate();}我开始写成 int i = 1; 因为Hibernate的设置参数的索引从0开始,如果设置从1开始,到第二个就越界了,因为我的HQL语句就两个占位符
update User set password=? where id=?
值得注意的是:jdbc的这只参数却是从1开始的,这个很容易混淆
0 0
- Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based!
- Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based!
- Remember that ordinal parameters are 1-based! Position: 1
- Remember that ordinal parameters are 1-based!
- Remember that ordinal parameters are 1-based!
- Remember that ordinal parameters are 1-based!
- Remember that ordinal parameters are 1-based!
- Remember that ordinal parameters are 1-based!
- java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based
- Remember that ordinal parameters are 1-based! (and I am)
- HTTP Status 500 - Remember that ordinal parameters are 1-based!
- java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!
- java.lang.IndexOutOfBoundsException:Remember that ordinal parameters are 1-based!
- 页面访问时发生错误: Remember that ordinal parameters are 1-based!
- java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based解决
- Caused by: java.lang.IndexOutOfBoundsException: Remember that ordinal parameters are 1-based!
- tomcat 启动 严重:Error listenerStart Remember that ordinal parameters are 1-based!
- SSH框架 使用hibernateTemplate.find()时,报错,Remember that ordinal parameters are 1-based!
- Vue 学习笔记
- 阿里Java开发手册之编程规约
- jQuery插件推荐
- 工具类网站
- 从0开始搭建hadoop2.X.X集群环境
- Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based!
- linux上安装mysql及简单的使用
- 十分钟学会Charles抓包(iOS的http/https请求)
- 多线程编程(1):共享内存与锁
- 多线程学习
- Linux常用命令介绍
- centos7的syslog知识点
- Python 资源大全中文版
- nodejs微信开发测试,模拟微信事件、消息等请求