Hi,

How to write hql query to get 10 records order by date?

String query = "from Registration as registration ";
Registration registration = null;
List list = this.getHibernateTemplate().find(query);


how to change this code to get 10 records alone?

thanks,
Aarthy

String query = "from Registration as registration ";
Session session=this.getHibernateTemplate().getSession();
Query query=session.createQuery(query);
query.setFirstResult(0);
query.setMaxResults(10);
List list = query.list();

Hi gonzao_diaz,

I tried your code.
I am getting this error.

The method getSession() is not visible from hibernate template.

pls help.

Thanks,
Aarthy

True...
The problem is, there are no such first-maxrows methods in the HibernateTemplate.

If you can, don't use HibernateTemplate anymore (it is obsolete), and try instead to use contextual sessions directly.

A good simple example of the new Hibernate-Spring configuration is given here

http://hibernar.org/articulos_en/spring ... xample.php

s i too i felt some issues with Hibernate Templates

-----------------
vinora