|
Sort Order:
If I use hql="from Salary", the hql will be:
select salary0_.id as id2_, salary0_.salary as salary2_, salary0_.userId as userId2_ from Salary salary0_ select user0_.id as id0_1_, user0_.account_expired as account2_0_1_, user0_.account_locked as account3_0_1_, user0_.address as address0_1_, user0_.city as city0_1_, user0_.country as country0_1_, user0_.postal_code as postal7_0_1_, user0_.province as province0_1_, user0_.credentials_expired as credenti9_0_1_, user0_.email as email0_1_, user0_.account_enabled as account11_0_1_, user0_.first_name as first12_0_1_, user0_.last_name as last13_0_1_, user0_.password as password0_1_, user0_.password_hint as password15_0_1_, user0_.phone_number as phone16_0_1_, user0_.username as username0_1_, user0_.version as version0_1_, user0_.website as website0_1_, roles1_.user_id as user1_3_, role2_.id as role2_3_, role2_.id as id1_0_, role2_.description as descript2_1_0_, role2_.name as name1_0_ from app_user user0_ left outer join user_role roles1_ on user0_.id=roles1_.user_id left outer join role role2_ on roles1_.role_id=role2_.id where user0_.id=? and so on. and when I use hql=""from Salary" will resolve the problem.
Here is a possible solution posted by me
http://jira.springframework.org/browse/SPR-5007 Fixed in 2.0.2 by adding getAllDistinct via
|
|||||||||||||||||||||||||||||||||||||||
Bug
Resolved
Major
Hibernate returns repeat records when getAll
select this_.id as id2_2_, this_.salary as salary2_2_, this_.userId as userId2_2_, user2_.id as id0_0_, user2_.account_expired as account2_0_0_, user2_.account_locked as account3_0_0_, user2_.address as address0_0_, user2_.city as city0_0_, user2_.country as country0_0_, user2_.postal_code as postal7_0_0_, user2_.province as province0_0_, user2_.credentials_expired as credenti9_0_0_, user2_.email as email0_0_, user2_.account_enabled as account11_0_0_, user2_.first_name as first12_0_0_, user2_.last_name as last13_0_0_, user2_.password as password0_0_, user2_.password_hint as password15_0_0_, user2_.phone_number as phone16_0_0_, user2_.username as username0_0_, user2_.version as version0_0_, user2_.website as website0_0_, roles3_.user_id as user1_4_,role4_.id as role2_4_, role4_.id as id1_1_, role4_.description as descript2_1_1_, role4_.name as name1_1_ from Salary this_ left outer join app_user user2_ on this_.userId=user2_.id left outer join user_role roles3_ on user2_.id=roles3_.user_id left outer join role role4_ on roles3_.role_id=role4_.id