Hibernate Community • View topic - How can we Achieve FETCH ONLY 'N' Clause functionality in HB

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How can we Achieve FETCH ONLY 'N' Clause functionality in HB

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

srinivasulaa

Post subject: How can we Achieve FETCH ONLY 'N' Clause functionality in HB

Posted: Thu Aug 03, 2006 9:06 am

Newbie

Joined: Tue Aug 01, 2006 8:31 am
Posts: 6

Hi All,

How can i get the n number of records from a table by using Hibernate.

Like we have in DB2 FETCH ONLY clause.

Please help me out it is an urgent requirement for me.

Regards
Sreenivasula Reddy A

Top

adr

Post subject:

Posted: Thu Aug 03, 2006 9:15 am

Newbie

Joined: Tue Mar 21, 2006 4:19 am
Posts: 15

Query q = session.createQuery("....");
q.setFirstResult(1);
q.setMaxResults(20);
with this code you`ll get the results from 1 to 20.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum