Hi,

I am new to hibernate. Can any one please give m e the HQL equivalent for this query. This is DB2 AS400 query.(um_forum and um_topic are the table names)

select a.muuid,a.forum_name,count(b.muuid) topics,sum(b.topic_noposts) posts,a.createddate from um_forum a left outer join um_topic b on b.forum_id = a.muuid group by a.muuid,a.forum_name,a.createddate order by a.forum_name,a.createddate desc


Thanks and Regards,
Umar

Hi,

Can any one help on this..?


UMAR

Umar

HQL uses objects, not relational tables, unless u use SQLQuery(which is not recommended). so provoide ur mapping and objects. Also read this

When asking questions, give at least:

the Hibernate version
your mapping documents
the Java code between sessionFactory.openSession() and session.close()
the full stack trace of any exception that occurs
the name and version of the database you are using
a debug level Hibernate log excerpt is also appreciated