Hibernate Community • View topic - Criteria and Collections with parent-child relationship

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Criteria and Collections with parent-child relationship

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

gifor

Post subject: Criteria and Collections with parent-child relationship

Posted: Tue Apr 20, 2004 8:38 am

Beginner

Joined: Fri Oct 17, 2003 4:11 am
Posts: 40

Hallo!
I have a Parent class with some Children in a Set. I ask the user to give me some children's id and I use them to get the Parent that contains at least this children.
If the user give me only one child (with id=1 for example) it's simple:

Code:

Criteria criteria = session.createCriteria(Parent.class); 
Criteria childrenCriteria = criteria.createCriteria("subChildren"); 
childrenCriteria.add( Expression.eq("id", new Integer(1)) ); 
List results = criteria.list();

If the user tell me "give me the Parent that have at least the children with id=1 and id=2" i tried with the conjunction of two Expression.eq but it doesn't work!! I get no result!

There is a way to make this with Criteria (no Query)?

Thanx for any help and sorry for my english!!

Top

gifor

Post subject:

Posted: Tue Apr 20, 2004 8:41 am

Beginner

Joined: Fri Oct 17, 2003 4:11 am
Posts: 40

My whole code is:

Code:

Criteria criteria=session.createCriteria(HUtente.class);
HUtente hu=new HUtente();
hu.username="i%";
Example example=Example.create(hu);
example.ignoreCase();
example.enableLike();
example.excludeZeroes();
criteria.add(example);

Criteria childCriteria=criteria.createCriteria("gruppi");
childCriteria.add(Expression.disjunction().add(Expression.eq("id",new Long(1))).add(Expression.eq("id",new Long(2))));
List list=criteria.list();

Top

gifor

Post subject:

Posted: Tue Apr 20, 2004 9:03 am

Beginner

Joined: Fri Oct 17, 2003 4:11 am
Posts: 40

with disjunction it works! But is the OR case... i need AND case...

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