setFirstResult and setMaxResults for createSQLQuery

JehanNYNJ · **Joined:** Fri Jul 30, 2010 11:14 am **Posts:** 2

Hi all,

I want to replace some code which was using the Hibernate Criteria API with a SQL query. So instead of calling...

Code:

List results = getHibernateTemplate().findByCriteria(myCriteria);

I now have...

Code:

List results = getSession().createSQLQuery(query).list();

The problem is that the old code also calls Criteria's setFirstResult and setMaxResults methods. Are there any equivalents for these when using createSQLQuery?

Thanks in advance for any help,
Jehan

JehanNYNJ · **Joined:** Fri Jul 30, 2010 11:14 am **Posts:** 2

I found that the Hibernate Query objects does have these methods, but for some reason when I used them my ResultSet went from being composed of Integers to being composed or Object arrays. Anyone know why this happened? Weird.

sanne.grinovero · **Posted:** Fri Jul 30, 2010 12:23 pm

if you use a plain SQL query you have to implement your pagination; pagination is a complex topic handled in different ways depending on the situation and database specifics: if you write your own free-form SQL then hibernate can't append some statement to implement pagination: the whole point of using plain SQL is that you want to write the query yourself and avoid Hibernate's help.
Maybe using an HQL query is better suited to convert the criteria?