Hibernate Community • View topic - Restriction expression to test collection-valued property?

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Restriction expression to test collection-valued property?

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Post subject: Restriction expression to test collection-valued property?

Posted: Tue Jul 10, 2007 11:17 pm

Regular

Joined: Thu Apr 15, 2004 1:12 pm
Posts: 55

Hi,

I have...

1) persistent objects of a class Event...

2) which has a Set property "types"...

3) whose values are persistent objects of a class EventType...

4) and EventType has a String property "name"

And all this works fine. But now I need to build a query using the Criteria interface, and I need a restriction that is satisfied if the Event's "types" property contains the given (as a parameter) EventType.

Or better yet... if the Event's "types" property contains the EventType whose "name" is the given String.

I can't find anything in Restriction that does the job (Hibernate3). Any ideas?

thx a lot,
—ml—

Top

thesilverline

Post subject: try this.

Posted: Wed Jul 11, 2007 1:34 am

Newbie

Joined: Wed Mar 14, 2007 2:21 am
Posts: 5

Doesn't this work?

Code:

List cats = sess.createCriteria(Event.class)  
    .createCriteria("types")
        .add( Restrictions.like("name", "any name") )
    .list();

Top

Post subject:

Posted: Wed Jul 11, 2007 1:43 pm

Regular

Joined: Thu Apr 15, 2004 1:12 pm
Posts: 55

Beautiful! That works perfectly, thanks a lot!
—ml—

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