Hi,

How can I execute the following query using hibernate HQL/Criteria/Query?

select num from (select rownum num ,id from( select id,entity, severity,ttime from event order by severity asc, id asc))where id=1011799

I would like to execute this query by setting paramaters, projection ...etc and do not want to generate manully and give it toHibernate.

Any help is appreciated

Thanks
Venkat

read the hibernate reference in chapter 16

there ara a lot of examples for create queries

heh, for very complicated queries I find it just saves me a ton of time to just go ahead and send it over as sql instead of converting it to hql or transformations if it's possible.