Spring hibernate query help

Question

currently I am using the following to pull rows from a table called Table:

return getHibernateTemplate().find("from Table");

How do I use hibernate to pull only the first n rows from the table (i.e. like a mySql limit would do)?

Thanks.

Update: so is this the proper way to do it?

getHibernateTemplate().setMaxResults(35);
return getHibernateTemplate().find("from Table");

It would be better to use a hibernate Query object to do the load and then set the max results on that. Problem with doing what you suggest is that it will be set on the hibernate template and that object is re-used. So the limit will be set for other queries as well. — Michael Wiles
– Michael Wiles, Commented Feb 5, 2010 at 6:35
I looked into this, what about using Criteria to acheive this? What would be the benefits / downsides to using Criteria over Query object? Thanks — oym
– oym, Commented Feb 5, 2010 at 19:34

Teja Kantamneni · Accepted Answer · 2010-02-04 19:34:04Z

2

Use HIbernateTemplate setMaxResults to limit the results.

answered Feb 4, 2010 at 19:34

Teja Kantamneni

17.5k12 gold badges58 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Is the code that I updated in my question the proper way to do it?

oym · Accepted Answer · 2010-02-17 23:27:34Z

0

I ended up using a Hibernate Criteria query to do this and it works properly. I made use of the setFirstResult() and setLastResults() methods.

answered Feb 17, 2010 at 23:27

oym

7,11317 gold badges65 silver badges89 bronze badges