Hi ,

I'm trying to achieve: Get all employees with the given manager.

I am using hibernate Query By Example . But it is not returning any results.

Employee employee = new Employee();
employee.setEmployeeName("ABC");
employee.setManager(manager);

Criteria criteria = session.createCriteria(Employee.class).
add(Example.create(employee ).excludeZeroes());

if(employee .getManager() != null)
{
criteria.createCriteria("manager").add(
Example.create(employee .getManager()).excludeZeroes());

}


Here are my POJOs.


public Employee() extends Subordinate{
private String employeeName;
public void setEmployeeName(String employeeName){
this.employeeName = employeeName;
}
public void getEmployeeName(){
return this.employeeName;
}
}


public Manager(){
private String managerName;
public void setManagerName(String managerName){
this.managerName = managerName;
}
public String getManagerName(){
return this.managerName;
}

private List<Subordinate> subordinates;
public void setSubordinates (List subordinates){
this.subordinates = subordinates;
}
public void getSubordinates (){
return this.subordinates;
}
}

public Subordinate(){
private String subordinateName;
public void setSubordinateName(String subordinateName){
this.subordinateName= subordinateName;
}

public String getSubordinateName(){
return this.subordinateName;
}

private Manager manager;
public void setManager(Manager manager){
this.manager = manager;
}
public void getManager(){
return this.manager;
}
}

Can anybody help.

Thanks

I believe Hibernate query by example should be simpler (like in other modern persistence engines). For example in db4o the corresponding native query would be:



Sorry for not directly answering your question!

Best regards.

german1