Skip to content
Advertisement

NonUniqueDiscoveredSqlAliasException when two table has same column names

I have two tables Item and Nikasa – whose definitions looks like:

Item { id, name, spec} and Nikasa {id, date, item_id}. Here item_id represents Item.id.

I did a simple native SQL join to select only Item.id and Nikasa.id as:

But I am getting exception NonUniqueDiscoveredSqlAliasException : Encountered a duplicated sql alias [ID] during auto-discovery of a native-sql query at line List result=sq.list();:

Stack-trace :

Can you please suggest what’s wrong going on?

Advertisement

Answer

You need set the result alias.

User contributions licensed under: CC BY-SA
3 People found this is helpful
Advertisement