Hibernate Community • View topic - Querying Many-to-one relationships

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Querying Many-to-one relationships

Page 1 of 1

[ 4 posts ]

Previous topic | Next topic

Author

Message

RAFEH

Post subject: Querying Many-to-one relationships

Posted: Mon Apr 19, 2004 11:10 pm

Newbie

Joined: Tue Mar 09, 2004 8:52 pm
Posts: 5

Assume a user has a collection of address objects and each address object has a state object.

I want to identify all users who has an address in a given state.

I've searched the forums and documentation, but haven't found an example of such a query.

How would I do this using HQL (preferably in one query)?

Thanks for the help.

Top

Randy Kahle

Post subject:

Posted: Mon Apr 19, 2004 11:13 pm

Newbie

Joined: Mon Apr 19, 2004 7:10 pm
Posts: 7

I think you are asking a question similar to mine in the following post:

http://forum.hibernate.org/viewtopic.php?t=930074

Top

RAFEH

Post subject:

Posted: Tue Apr 20, 2004 9:49 am

Newbie

Joined: Tue Mar 09, 2004 8:52 pm
Posts: 5

Perfect. Thanks for the quick reply.

Top

Moss

Post subject:

Posted: Tue Apr 20, 2004 12:39 pm

Beginner

Joined: Tue Apr 20, 2004 12:07 pm
Posts: 21

Something like

select user from User, Address as address, State as state where
address in elements(user.addresses) and address.state = ?

Top

Page 1 of 1

[ 4 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