Good day!

The base concepts of a system I'm working on were designed by other people, and criteia based filtration is not suitable. So I have no other choice to write in plain HQL.

Is there any way to do paging by the means of HQL (something like 'rownum' etc.)? I heard there was a contribution where such problem was solved.

Any help will be surely appreciated.

Best regards,
Dio.

Look at this : http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html#queryhql-tipstricks

Thanks alot, but I've already seen that. And as I told there is no way I could use such technique. I need to perform paging with HQL only. Is it possible?

Hibernate is documented very well, if you can't find a way on the Hibernate site then it likely can't be done.

You might be able to do it by assigning your HQL to IQUery using "CreateQuery" method of nhibernate current session object
and then can use as same way as we can do with creteria something like this:

Session session = HibernateTemplet.currentSession();
Query query = session.createQuery("your HQL");
query.setFirstResult(1);
query.setMaxResults(2);
List results = query.list();

I am not sure but you should be able to achieve it by this.
Let me know if you find a better way.