Hibernate Community • View topic - Using collection elements in the where clause

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Using collection elements in the where clause

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

jlampking

Post subject: Using collection elements in the where clause

Posted: Thu Apr 08, 2004 9:39 pm

Newbie

Joined: Mon Jan 05, 2004 11:27 am
Posts: 4
Location: US

Hello,

If I have 2 classes

Code:

Owner  { Integer id ;
                Set  Pets
...
 }


and  Pet  { Integer  id ;
                  String Name;
                   .... 
}

Using the one-to-many collection model the Owner class has a Set of type Pet.

That all works fine.
For the life of me I can't figure out how to use Pet.Name in a hql where clause.
For example:
from Owner as o where elements(o.Pets.Name) = 'Fido'
does not work. What am I doing wrong?
Thanks in advance
.

Top

steve

Post subject:

Posted: Fri Apr 09, 2004 12:01 am

Hibernate Team

Joined: Tue Aug 26, 2003 3:00 pm
Posts: 1816
Location: Austin, TX

You want owners with a pet named fido, right?

from Owner as o join o.pets as p where p.name = ?

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