Okay, I'm hoping this will be straight forward enough that I don't have to post my model. On the following named query:


Is giving me an exception stating that GROUP BY is using the userId column from the Contact entity while SELECT is using the column from the entity User.

Additional information, I am only doing the GROUP BY to avoid this query:


Since the distinct would do a sort on ALL fields on the User entity. I suppose if this type of GROUP BY is not supported by Hibernate I could always do the following:


But that would seem less optimal than the GROUP BY.

Thanks!

This is not an hibernate problem. The sql query supplied to hibernate is not correct.

In Group By clause you can have only those columns which are supplied in select clause or ggregeate functions.

First run you query directly on database and then convert it to Hibernate query.

For example following query will always work..

SELECT c.user.id FROM Contact c WHERE c.owner = :ownerID GROUP BY c.user.id;

That's not quite correct, because "user" is being select necessarily means that "user.id" is available for a GROUP BY. This isn't the issue.

Your sql is incorrect.

Can you be more specific Akash? The translated SQL seems to work fine on every database server I've tried it on.