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人围观）

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

相关阅读