Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query; nested except

梦里梦外; 2022-12-28 08:16 211阅读 0赞
  • 报错:Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query; nested exception is org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [name] during auto-discovery of a native-sql query
  • 原因:例:select a.*,b.name from bip_api_script a inner join business b on a.business_id=b.id,当a表里面有name属性时报错。
  • 解决:给b.name起个别名即可:select a.*,b.name business_name from bip_api_script a inner join business b on a.business_id=b.id

发表评论

表情:
评论列表 (有 0 条评论,211人围观)

还没有评论,来说两句吧...

相关阅读