Hi Nathan,

Thank you so much for the reply.

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;
}

}

I'm trying to achieve: Get all employees with the given manager. Hope you
understand. I think in the previous post I have represented it incorreclty.
Sorry.



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());

}



I have read that in Hibernate Query By Example ignores "Associations" are
ignored in such case will this work. Could you please help me. Is there any
way to solve this issue.


Thanks.







melinate wrote:
> 
> I think you might need to provide some more information for someone to
> help with this.  Could you share your POJO's so we can see how you built
> the relationships betwen Manager and Employees.  Are you trying to
> retrieve one Manager and a List of Employees?  If the relationships are
> set up correctly it should just be a matter of fetching the Manager by id
> and the List of Employees will come with it [however you may have to read
> the list to avoid lazy loading issues].
> 
> HTH,
> Nathan
> 
> 
> ----- Original Message -----
> From: "Lucky123" <[EMAIL PROTECTED]>
> To: users@appfuse.dev.java.net
> Sent: Thursday, October 4, 2007 2:13:00 PM (GMT-0800) America/Los_Angeles
> Subject: Re: [appfuse-user] Hibernate Example.create
> 
> 
> I have two entities stored in seperate database tables
> 
> - Employee
> - Manager
> 
> Every Employee has a Manager(or vice versa: Every Manager has several
> Employees)
> 
> Get Manager with his employees.
> 
> I tried Hibernate Query by example, but it is not returning anything..
> 
> Criteria criteria = session.createCriteria(Manager.class).
>                       add(Example.create(manager).excludeZeroes());
> 
> if(manager.getEmployee() != null)
> {
>       criteria.createCriteria("employee").add(
>               Example.create(manager.getEmployee()).excludeZeroes());
> 
> }
> 
> Can anybody help.
> 
> Thanks
> -- 
> View this message in context:
> http://www.nabble.com/Hibernate-Example.create-tf1278198s2369.html#a13048884
> Sent from the AppFuse - User mailing list archive at Nabble.com.
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> 
> 
> 

-- 
View this message in context: 
http://www.nabble.com/Hibernate-Example.create-tf1278198s2369.html#a13098305
Sent from the AppFuse - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to