Hibernate Community • View topic - problem creating simple HQL query with a collection

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

problem creating simple HQL query with a collection

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

hibernatefan303

Post subject: problem creating simple HQL query with a collection

Posted: Tue Mar 02, 2010 6:58 am

Newbie

Joined: Tue Mar 02, 2010 6:40 am
Posts: 3

I have two objects with a many-to-many relationship, to stay with the examples in the reference manual say I have a Cat object which has one or more kitten objects in a Set 'kittens'. I run into trouble when I want to make a simple query to fetch all Cats who have a kitten of a specific color.

I tried something like:

Code:

from Cat as cat WHERE cat.kittens.color = 'green'

this gives "illegal attempt to dereference collection" exception however. How can I tell Hibernate to simply go through the colors of the kittens of a Cat and compare them to a given parameter?

Thanks for any help!

Top

SIau_Tie

Post subject: Re: problem creating simple HQL query with a collection

Posted: Tue Mar 02, 2010 7:52 am

Senior

Joined: Wed Sep 19, 2007 9:31 pm
Posts: 191
Location: Khuntien (Indonesia)

Code:

select cat from Cat as cat inner join cat.kittens as k WHERE k.color = 'green'

Hope can help you.

Top

hibernatefan303

Post subject: Re: problem creating simple HQL query with a collection

Posted: Fri Mar 05, 2010 5:36 am

Newbie

Joined: Tue Mar 02, 2010 6:40 am
Posts: 3

Thanks! I decided to go with Criteria instead of HQL though. So my "query" became something like this:

Code:

Criteria criteria = session.createCriteria(Cat.class);
criteria.createCriteria("kittens").add( Restrictions.eq("color", "green") );

Top

Page 1 of 1

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