Position beyond number of declared ordinal parameters.

原创 于 2020-05-05 15:53:07 发布 · 1k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#hibernate

本文详细解析了在使用Hibernate框架时遇到的Positionbeyondnumberofdeclaredordinalparameters错误，通常由于中英文符号混用导致，如中文问号代替英文问号。通过一个具体示例，展示了如何排查和修正此类问题。

Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 2

org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 2
org.hibernate.engine.query.spi.ParameterMetadata.getOrdinalParameterDescriptor(ParameterMetadata.java:80)
org.hibernate.engine.query.spi.ParameterMetadata.getOrdinalParameterExpectedType(ParameterMetadata.java:86)
org.hibernate.internal.AbstractQueryImpl.determineType(AbstractQueryImpl.java:444)
org.hibernate.internal.AbstractQueryImpl.setParameter(AbstractQueryImpl.java:416)

百度查看大佬的文章，这个错误出错的原因多半是中英字符运用错误，比如逗号或者问号。

String hql = “from com.sharingbike.www.pojo.Images where bid = ? and bic = ？”;

我出错的地方就是第二个问号用的中文拼音的问号。

LCGGood
关注
记一个eslint问题Failed to load plugin ‘@typescript-eslint‘ declared in ‘.eslintrc.js‘
蛐蛐的博客
01-10 9592
1.简介 eslint运行报错 Error: Failed to load plugin '@typescript-eslint' declared in '.eslintrc.js': Cannot find module 'eslint/use-at-your-own-risk' Require stack: - D:\workspace\team\takewalke\ticket-scraper\node_modules\@typescript-eslint\eslint-plugin\..
duplicated with element declared at AndroidManifest.xml解决办法
u013558123的博客
08-03 5086
如下图，找到AndroidManifest.xml文件，删除重复的activity设置即可。
Hibernate异常之org.hibernate.QueryParameterException: Position beyond number of declared ordinal .....
静若清池，动如涟漪_
08-01 4948
1、异常描述 org.hibernate.QueryParameterException:Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1 备注： 此处hibernate版本号：3.6.10.Final...
org.springframework.orm.hibernate3.HibernateQueryException中的一个小异常
抛弃幻想，准备斗争
12-29 3075
在使用Hibernate的时候，出现了这样的一个错误： org.springframework.orm.hibernate3.HibernateQueryException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position...
（已解决）Position beyond number of declared ordinal parameters
ting0712的博客
01-01 7794
错误记录7： Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1（已解决） 翻译：位置超出声明的序数参数的数目。记住那个序数 这个错误已经不是一次遇见了 第一次同学遇见的，找我我网上找了很多方法也没解决出来，后来是老师帮...
hibernate运行报错 ：Position beyond number of declared ordinal parameters
热门推荐
yjxlgqq的博客
07-13 1万+
org.springframework.orm.hibernate5.HibernateQueryException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1; nested exception is org.hi...
TypeError Event name already declared解决办法.md
05-30
在编写JavaScript代码时，遇到错误“TypeError Event name already declared”意味着在相同的事件作用域中对同一个事件名称进行了多次声明。这通常发生在使用事件监听器时，例如，通过`document.addEventListener`...
Parameter "decodeTime" is not declared. Injection of parameters into signal handlers is deprecated. Use JavaScript functions with formal parameters instead.
06-03
Injection of parameters into signal handlers is deprecated. Use JavaScript functions with formal parameters instead.”，大致意思是注入参数到信号处理程序中已经过时，应该使用带有形式参数的 JavaScript ...
Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based!
Chanal_sogaad的博客
03-09 2173
这种问题是你设置参数时下表超过了你的sql的问号(占位符)的下表, public void excuteNamedQuery(String queryName, Object... args) { //得到session Session session = this.getSessionFactory().getCurrentSession(); Query quer
严重: Exception occurred during processing request: Position beyond number of declared ordinal paramet
u012402190的博客
05-26 4261
严重: Exception occurred during processing request: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1 org.hibernate.QueryParameterExceptio
hibernater查询传递参数时候报错： Remember that ordinal parame
weixin_33750452的博客
07-27 768
2019独角兽企业重金招聘Python工程师标准>>> ...
在使用hibernate进行数据操作时出现错误
shuangdangshen0998的博客
01-01 829
HTTP Status 500 - Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1; nested exception is org.hibernate.QueryParameterException: Position 
Hibernate中ordinal parameter mismatch的BUG
JAVA 像一把利剑刺向我的心脏！
08-27 6284
问题 最近在调整hql语句时，发生一个莫名其妙的问题hql语句如下："from User where dataDate?=? and callerNumber like ?”;如此简单的一条语句，在执行时却报了一个“ordinal parameter mismatch;”异常。奇怪的是，把callerNumber条件放到最前面却是好的：“from Bill where callerNumber like ? and dataDate=?”。 原因 经多方查证，原来是call这个字符串惹
QueryParameterException----异常一只
继承接口的博客
08-18 523
**org.hibernate.QueryParameterException**: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 2 at org.hibernate.engine.query.spi.Paramet
执行HQL语句出现Remember that ordinal parameters are 1-based
weixin_30501857的博客
12-04 254
今天使用hibernate出个奇怪的错误，第一次碰到 Remember that ordinal parameters are 1-based! 原因是 问题发生的原因是：hql语句里不需要参数，却添加了一个参数！ 我的ＨＱＬ语句： 1 @Override 2 public Dept getDeptById(Dept dept) 3 { 4 return...
y.y:87.20-21: $3 of `assign_stmt' has no declared type y.y:97.45-46: $2 of `if_stmt' has no declared type y.y:100.50-51: $2 of `if_stmt' has no declared type y.y:105.55-56: $4 of `repeat_stmt' has no declared type y.y:110.25-26: $2 of `write_stmt' has no declared type y.y:130.21-22: $$ of `exp' has no declared type y.y:130.27-28: $1 of `exp' has no declared type y.y:130.33-34: $3 of `exp' has no declared type y.y:131.18-19: $$ of `exp' has no declared type y.y:131.24-25: $1 of `exp' has no declared type y.y:131.30-31: $3 of `exp' has no declared type y.y:132.18-19: $$ of `exp' has no declared type y.y:132.24-25: $1 of `exp' has no declared type y.y:132.29-30: $3 of `exp' has no declared type y.y:133.18-19: $$ of `exp' has no declared type y.y:133.24-25: $1 of `exp' has no declared type y.y:133.29-30: $3 of `exp' has no declared type y.y:134.18-19: $$ of `exp' has no declared type y.y:134.24-25: $1 of `exp' has no declared type y.y:134.30-31: $3 of `exp' has no declared type y.y:135.18-19: $$ of `exp' has no declared type y.y:135.24-25: $1 of `exp' has no declared type y.y:135.30-31: $3 of `exp' has no declared type y.y:136.18-19: $$ of `exp' has no declared type y.y:136.23-24: $1 of `exp' has no declared type y.y:136.28-29: $3 of `exp' has no declared type y.y:137.19-20: $$ of `exp' has no declared type y.y:137.24-25: $1 of `exp' has no declared type y.y:137.29-30: $3 of `exp' has no declared type y.y:138.18-19: $$ of `exp' has no declared type y.y:138.23-24: $1 of `exp' has no declared type y.y:141.25-26: $$ of `term' has no declared type y.y:141.30-31: $1 of `term' has no declared type y.y:141.35-36: $3 of `term' has no declared type y.y:143.8-9: $3 of `term' has no declared type y.y:145.9-10: $$ of `term' has no declared type y.y:147.9-10: $$ of `term' has no declared type y.y:147.14-15: $1 of `term' has no declared type y.y:147.19-20: $3 of `term' has no declared type y.y:150.12-13: $$ of `term' has no declared type y.y:150.17-18: $1 of `term' has no declared type y.y:153.15-16: $$ of `factor' has no declared type y.y:157.9-10: $$ of `factor' has no declared type y.y:160.9-10: $$ of `factor' has no declared type y.y:164.17-18: $$ of `factor' has no declared type y.y:164.22-23: $2 of `factor' has no declared type y.y:165.18-19: $$ of `factor' has no declared type y.y:165.24-25: $2 of `factor' has no declared type
最新发布
06-04
我们遇到了一大堆关于Bison语法规则中语义值类型未声明的错误。这是因为在Bison中，当我们使用`$$`,`$1`,`$2`等引用语义值时，需要为每个非终结符和终结符指定其类型（即%union中的哪个字段）。...
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
表情包 代码片
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值