I have the following HQL query:

select entry.host, count(entry.id) from AccessLogEntry entry
group by entry.host order by count(entry.id) desc

On mysql, it fails with a generic error, and a message from server: "Invalid use of group function".
If I remove the order by clause, the query works fine. I suspect this is related to the fact that MySQL won't accept an aggregate function as an order criteria.

I'd like to do:

select entry.host, count(entry.id) as hits from ..

but, as far as I can tell, HQL won't allow me to (re)name the selected items.

Meanwhile, I'm running without the ordering, and order the resulted list in Java, but I'd rather have the query do it.

Any ideas?

Any ideas? Is there any workaround?

My SQL does not support aggregate functions in the order by clause, I think I recall.

Thank you very much for your reply!

Can you suggest a workaround?
Is it possible to name a select entry? (select max(entry.id) AS mx ?)
Is there anything I can do, Java-side?

i have the same problem.
in order by class i am using column number instead of it alias
cause hibernate doesn't work with colum aliases