报错信息：
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 query
报错原因：
select * from PER_KEY_INCIDENT perkeyincd0_ cross join PER_AGREE peragreeme1_
where perkeyincd0_.AGREE_ID=peragreeme1_.id and peragreeme1_.AUDIT_RESPONSE_USER= 'ff808081621e3ac901621e49dc090000'
order by perkeyincd0_.id asc
看sql语句可以知道这是两表的交叉查询，所以查询来的数据就会冲突，导致出现两个id字段，出现了这个错误
解决方法：
把查询所有的*号换掉，用取别名的方法一个一个点出来 “AS”就解决了！！
版权声明：本文为qq_45498460原创文章，遵循CC 4.0 BY-SA版权协议，转载请附上原文出处链接和本声明。