Hey,

I would like to check, how many unread messages an user has.

I have two tables, Users and Messages, User has a one to many mapping to Messages.

Alright not to check how many unread messages an User has i do the following HQL:



but that doesnt work :(

Do you have an Idea how i could solve my problem (even if there is no such user it should return a number - 0 in that case)


Thanx for reading,
virtually yours

Next time please include the stacktrace. If you have mapped the association bi-directionely and you probably want that (http://www.hibernate.org/hib_docs/v3/re ... hild-bidir) then you could use:

select count(*) from Message m where m.user.name = :username and m.read=0

or even better if you have a reference to the user

select count(*) from Message m where m.user = :user and m.read=0