Hibernate version: 2.1.6

Hibernate mapping: Blog

<hibernate-mapping default-cascade="save-update">
<class name="net.gatep5.weblog.Blog" table="BLOG">
<id name="id" column="ID">
<generator class="sequence">
<param name="sequence">blog_id_seq</param>
</generator>
</id>
<timestamp name="date" column="date" />
<property name="subject" column="subject" type="string" not-null="true" unique="true"/>
<set name="entries" inverse="true" order-by="id desc" lazy="true" cascade="all" table="entry" >
<key column="blog_id"/>
<one-to-many class="net.gatep5.weblog.Entry" />
</set>
</class>
</hibernate-mapping>


Database: Postgresql


I have a blog hibernate mapping that contains a <set> element that links to the blog entries that correspond to the blog id. What I would like to do is when the blog object is created in the session it only contains a set of 5 entry objects but I would like to specify the offset value in a request parameter. So basically I am trying to pass a request paramenter to the hibernate mapping for my blog entity so that the whole set of entries is not requested but only the 5 that I am looking for. Is this even possible?

Thanks for your help in advance!

I have the same requirement, and so far I have not been able to google a solution...i think my problem is that Hiberante has the where attribute on colllection elements, but a database like mysql uses the limit keyword, and that does not belong in the where clause...anyone have any suggestions?