Encountered a duplicated sql alias [FEE_CHARGING] during auto-discovery of a native-sql query

最新推荐文章于 2022-05-21 18:06:44 发布
原创 最新推荐文章于 2022-05-21 18:06:44 发布 · 576 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文探讨了Hibernate框架中执行原生SQL查询时遇到NonUniqueDiscoveredSqlAliasException异常的原因及解决方案。通过示例说明了如何正确为SQL查询中的每个字段指定别名，避免重复导致的错误。

org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [FEE_CHARGING] during auto-discovery of a native-sql query

这是hibernate报错，说我的字段[FEE_CHARGING]没有加别名
而这段sql在数据库中是没有问题的
可以看出hibernate是这样规定的
select A.c1,A.c2,B.c1 c1_alias from A left join B
select后跟的B表（外连接的表）的字段都要加上别名

flinksql bug: Non-query expression encountered in illegal context
Direction_Wind的博客
08-28 307
例如 insert后面没跟select ，或者 create view table1 as 后面没跟select。这个bug其实很好理解，就是 他说sql解析错误，没有查询操作，也就是你应该有select 的地方没有select。
redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复---惜分飞
01-27 1291
redo异常强制拉库报ORA-600 kcbzib_kcrsds_1修复
Encountered a duplicated sql alias [NAME] during auto-discovery of a native-sql query
qq_31138647的博客
07-16 2417
1.控制台报错日志 org.springframework.orm.jpa.JpaSystemException: Encountered a duplicated sql alias [NAME] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUn...
Encountered a duplicated sql alias [xxxx] during auto-discovery of a native-sql query
梁同学与Android
04-06 2711
Hibernate: SELECT avg(quality) as quality , max(server_time) as server_time , min(source_time) as source_time, count(tag) as tag , sum(value) as value, ...
Encountered a duplicated sql alias [kind] during auto-discovery of a native-sql query
W
05-11 403
org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [kind] during auto-discovery of a native-sql query 这是因为没有添加别名，在原生的JPA中不能使用 " select * …… "
Encountered a duplicated sql alias [id] during auto-discovery of a native-sq
qq_31138647的博客
12-25 379
https://blog.csdn.net/u014414110/article/details/88192468
Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query； nested exceptio
ヾ凉秋的博客
06-28 1373
报错信息： Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql q
SYS_AUTO_SQL_TUNING_TASK 导致 ORA-07445错误
cuimiwan3140的博客
09-30 2039
1.先贴报错 ----敏感信息已经经过处理 Fri Sep 30 11:01:37 2016 Begin automatic SQL Tuning Advisor r...
codeblocks_12.11-2_i386-debian-stable
03-06
然后再 sudo dpkg - i *.deb ， 这次会提示 Errors were encountered while processing: codeblocks-contrib 然后再sudo apt-get -f install 这次会remove 掉这个包， 然后如下步骤。。 安装 codeblocks-contrib...
记录错误--Encountered a duplicated sql alias [register_datetime] during auto-discovery of a native-sql q
weixin_43732454的博客
04-02 316
这个错误的意思是这个字段需要使用别名, 因为在查出来的结果中有相同名字的字段 源代码如下, 乍看起来没有毛病, 表也加了别名, 查出来应该没问题. SELECT o.order_id, o.register_datetime, t.register_datetime 但是实际上在Navcat查出来的数据如下 重名的数据在navcat中被处理了, 但是程序中不会处理, 则报错.应对报错的重...
Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sql
weixin_30702413的博客
10-11 525
出现这个问题的原因是你查询的字段有重名，hibernate无法映射字段，在mysql中能成功执行，但是hibernate中不行，所以，只需要其中一个字段取个别名就可以避免这种情况 转载于:https://www.cnblogs.com/lionels/p/7651249.html...
解决：Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sq
热门推荐
Liucheng417的博客
05-26 2万+
一、报错： Encountered a duplicated sql alias [created_by_login] during auto-discovery of a native-sql query 二、原因： Select后面没有别名！！！ （注：存储过程不能select * ） 三、解决： 加别名之后，成功~
Encountered a duplicated sql alias [] during auto-discovery of a native-sql query; nested exception
Mr.Meng
10-17 1921
Encountered a duplicated sql alias [] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated  网上查询
hibernate原生sql查询 结果报Encountered a duplicated sql alias [job_id] during auto-discovery of a native-s
XingZhaoQiang的专栏
03-16 4134
20150316今天遇到这样一个错误，记到同日期的笔记上现在在博客上也记一次； 做的sql语句查询 SELECT X.ID, X.NAME,  x.PRICE,x.SALES_PRICE,...........,h.NAME as hotStreetName ,x.DISCOUNT,x.APPRAISE_SCORE from  (PA_PACKAGE  x, CO_HOT_STREET
org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias
习惯有你&的博客
10-14 7052
使用hibernate查询时，通过hibernate调用时却报如下错误：  2016-10-14 11:13:20.898 DEBUG 9624 --- [nio-8080-exec-1] org.hibernate.SQL : SELECT p.ch_id,p.ch_name,c.ch_id FROM foc_channels p LEFT JOI
Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sq
weixin_30328063的博客
11-18 130
select 后的字段没有加别名...... 转载于:https://www.cnblogs.com/haitao-fan/p/3429502.html
[异常] Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query；
Dj_nole的博客
12-28 1206
Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query； nested except
Encountered a duplicated sql alias [xxx] during auto-discovery of a native-sql query报错问题
weixin_44773906的博客
05-21 5792
一、问题描述 Encountered a duplicated sql alias [xxx] during auto-discovery of a native-sql query报错问题 二、解决办法 1.检查重命名是否有重复 2.没有限定是哪个表，举例： （1）select * …改成 select 表别名.* （2）select id …改成 select 表别名.id ...
九月 23, 2025 9:45:32 上午 org.apache.catalina.core.ApplicationDispatcher invoke 严重: Servlet[jsp]的Servlet.service()抛出异常 org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [FDEPMC] during auto-discovery of a native-sql query
最新发布
09-24
`NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [FDEPMC] during auto-discovery of a native-sql query` 是 Hibernate 在执行原生 SQL 查询（Native SQL Query）时常见的异常。...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值