Hibernate Community • View topic - one-to-many relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

one-to-many relationship

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

divya_sree

Post subject: one-to-many relationship

Posted: Thu Aug 30, 2007 3:44 pm

Newbie

Joined: Thu Aug 30, 2007 3:17 pm
Posts: 1

Hi,

I have two tables ORDER and PRODUCT and they have a one-to-many relationship.

This is the code from the mapping file :

Code:

<class>
           <set inverse="true" name="ProductsSet"  lazy="false">
   <key column="ORDER_ID" />
   <one-to-many class="Products" />
          </set>
</class>

Is it possible using HQL to retrieve records by applying conditions on both parent and child for example i want to get all Orders with quantity field > 2 and only Products for that Order that have a status field = 'A'

Thanks in advance

Top

mooritze

Post subject: Re: one-to-many relationship

Posted: Thu Aug 30, 2007 4:54 pm

Beginner

Joined: Tue Oct 10, 2006 3:23 am
Posts: 33

I think you want to use a filter on your collection,
look at session.enableFilter('filterName')

* rate if this helps *

divya_sree wrote: