hibernate原生sql查询 结果报Encountered a duplicated sql alias [job_id] during auto-discovery of a native-s
来源:互联网 发布:哈利波特怪味豆 淘宝 编辑:程序博客网 时间:2024/06/14 04:22
20150316今天遇到这样一个错误,记到同日期的笔记上现在在博客上也记一次;
做的sql语句查询
SELECT X.ID, X.NAME, x.PRICE,x.SALES_PRICE,...........,h.NAMEas hotStreetName ,x.DISCOUNT,x.APPRAISE_SCORE from (PA_PACKAGE x, CO_HOT_STREET h) left join C c
在书写的过程中x和h都取NAME就报了上面的错误;
如果不加后面红色的括号就会报
Unknown column 'x.ID' in 'on clause'
因为这是MySql 5.0 的bug; 要把关联的表用括号括起来!~~
0 0
- hibernate原生sql查询 结果报Encountered a duplicated sql alias [job_id] during auto-discovery of a native-s
- Encountered a duplicated sql alias during auto-discovery of a native-sql query种种报错
- Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sq
- 解决:Hibernate: Encountered a duplicated sql alias [] during auto-discovery of a native-sq
- Encountered a duplicated sql alias [name] during auto-discovery of a native-sql
- Encountered a duplicated sql alias [] during auto-discovery of a native-sql query; nested exception
- Encountered a duplicated sql alias [id] during auto-discovery of a native-sq
- 关于hibernate中报错:Encountered a duplicated sql alias [created_by_login] during auto-discovery of a nati
- org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias
- org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias
- Hibernate原生sql查询返回结果问题
- Hibernate原生SQL查询
- hibernate 原生sql查询
- Hibernate原生SQL查询
- Hibernate原生SQL查询
- Hibernate原生SQL查询
- Hibernate原生SQL查询
- Hibernate原生SQL查询
- linux下绑定host
- PKI技术原理(收集 整理 归纳)
- mac 10.10.1 下要用android-ndk-r10c-macosx版本
- Qt编译MySql驱动
- js学习 字符串常用方法
- hibernate原生sql查询 结果报Encountered a duplicated sql alias [job_id] during auto-discovery of a native-s
- JAVA Collection
- C语言中sizeof与strlen区别2
- [背景分离] 识别移动物体基于高斯混合 MOG
- TestQuest手机自动测试系统
- 以“挖坑填数”思想理解快速排序
- grails GGTS无法switch compiler
- AnsycTask 2.3版本 及3.0后版本 使用比较
- ZOJ 2112 Dynamic Rankings(树状数组套主席树)