Hi all,
I am making a web application using hibernate and got an issue couldnt solve it yet,
I want make a query look like
SELECT message_id, COUNT(*) FROM message GROUP BY user_id ORDER BY message_id
how can I do that hibernate?
session.createQuery("...");
thanks...

Can you run this plain SQL?

I don't know how you can select message_id, count() but group by user_id instead of group by message_id.

What is the error if you put the plain SQL in session.createQuery("...")?

try count() instead of COUNT().