org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException:错误

在java查询的时候报错：

org.hibernate.loader.custom.NonUniqueDiscoveredSqlAliasException: Encountered a duplicated sql alias [userId] during auto-discovery of a native-sql query

    at org.hibernate.loader.custom.CustomLoader.validateAliases(CustomLoader.java:508)

    at org.hibernate.loader.custom.CustomLoader.autoDiscoverTypes(CustomLoader.java:485)

    at org.hibernate.loader.Loader.processResultSet(Loader.java:2214)

    at org.hibernate.loader.Loader.getResultSet(Loader.java:2170)

    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1931)

    at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1893)

    at org.hibernate.loader.Loader.doQuery(Loader.java:938)

    at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:341)

检查后原因是，select查询的时候写了重复的userId字段，

如：

select user_id as userId,task_date as taskDate,user_id as userId,task_number as taskNumber from table_A      

删掉重复的即可！