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: Mon Aug 07, 2006 12:35 pm

Newbie

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

HI ALL,

I have to fetch n records from a table. But that n is a dynamic parameter i am passing to the query.

How will do this in Hibernate.

My requirement is like FETCH ONLY N clause in DB2.

Please help me out its an urgent requirement for me.

Regards,
Sreenivasula Reddy A

Top

jherbst

Post subject:

Posted: Mon Aug 07, 2006 12:44 pm

Regular

Joined: Mon Jun 13, 2005 12:21 pm
Posts: 61
Location: Hannover

Set you're DIALECT to DB2 and use
setFirstResults() and/or setMaxResults()

http://www.hibernate.org/hib_docs/v3/re ... yhql-joins

Joerg

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