Hibernate Community • View topic - SubQuery an Criteria problem whith association

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

SubQuery an Criteria problem whith association

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

tomateauk

Post subject: SubQuery an Criteria problem whith association

Posted: Sun Oct 08, 2006 7:42 pm

Newbie

Joined: Sun Oct 08, 2006 7:17 pm
Posts: 2

Hello,

Imagine you have two tables
A table Parent and a table Child

How can I have All the parents they have a child who's name is Jhon ant an other child who's name is Jack ?

Parent and child are mapped whith one-to-many association.

I tried
.createCriteria(Parent.class).
.createCriteria("ChildList")
.add(Restriction.conjonction()
.add(Restrictions.eq("name","Jhon")
.add(Restrictions.eq("name","Jack")
)

But it don't work.

Thank you for your help

Tom

Top

EdC

Post subject:

Posted: Sun Oct 08, 2006 9:36 pm

Beginner

Joined: Tue Sep 26, 2006 11:46 pm
Posts: 33

In HQL I believe you can do something like:

Code:

SELECT p
FROM Parent as p
INNER JOIN p.children as child1
INNER JOIN p.children as child2
WHERE child1.name = 'John'
AND child2.name = 'Jack'

Don't know about criteria I'm afraid.

Top

tomateauk

Post subject:

Posted: Mon Oct 09, 2006 6:00 pm

Newbie

Joined: Sun Oct 08, 2006 7:17 pm
Posts: 2

Thank you, but I really need criteria,

No Idea?

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