Hi

I have this:

public class Parent {

int id;

Set childs;

public void addImMotherOrf(final Child child) {
getChilds().add(child);
child.setMother(this);
}
public void addImFatherOf(final Child child) {
getChilds().add(child);
child.setFather(this);
}

//plus all the setters and getters
}

public class Child {

int id;

Parent mother;

Parent father;

//plus all the setters and getters
}

Now, I like to query the childs of given parents. I do this like that:

...
Child child = new Child();
Parent mother = new Parent();
Parent father = new Parent();
mother.setId(1);
father.setId(2);
mother.addIamMotherOf(child);
father.addIamFatherOf(child);
Criteria crit = session.createCriteria(Child.class);
crit.add(Example.create(child));
List result = crit.list();
...

This results in the following SQL

select .... from child_table where (1=1)

I checked the mapping. I found it quite correct. Inverse=true. Many-to-One and One-to-Many is defined. Querying parents works, including childs.

What am I doing wrong?

Stefan

Hi

OK, if no one wants to help me, I'll do it myself:

Criteria crit = session.createCriteria(Child.class);
crit.add(Expression.eq("mother", mother));
crit.add(Expression.eq("father", father));
List result = crit.list();

Works very fine.

Thanks me alot.