Hibernate - can't get the collection (List) when create criteria

[Peter Primrose]

I have a Department Employee relationship (department has employeeS)


when I query for employee - I can get the department *Name* //name name of department is not unique (department_id is unique)

Criteria criteria = session.createCriteria(Employee.class);
List<Employee> empls = criteria.list();   

BUT when I do this

Criteria criteria = session.createCriteria(Department.class);						
List<Department> departments = criteria.list(); 

I don't get the list of all employees, why?

Employee:

   
    @ManyToOne
    @JoinColumn(name="department_id", nullable=false)   
    private Department department; 
 

and Department

    
    @OneToMany(mappedBy="id") 
    private List<Employee> employees = new ArrayList<Employee>(); 

Thank you!

[Cameron Wallace McKenzie]

And I'm safely assuming you've left out the getter methods just not to pollute the page, right? Yeah, I thought so.

In my Hibernate Made Easy book, I have a little example that uses the "Team has Players" scenario. The two classes are mapped as so:

 
public class Team {   
@OneToMany(mappedBy="team", 
             targetEntity=Player.class, 
              fetch=FetchType.EAGER,
               cascade=CascadeType.ALL)
public List<Player> getPlayers() {return players;}  
}   

@Entity
public class Player {     
  @ManyToOne
  @JoinColumn(name="team_id")
  public Team getTeam() {return team;}     
}    

In this scenario, I have no problem pulling out both sides of the relationship using a Criteria query. Do you see any major differences between your code and mine?

Mapping Bi-Directional One-To-Many Relationships with Hibernate

You are indeed getting departments back from your query, right? How many departments get returned when you size the list? (Just making sure stage one works before digging too deep).

-Cameron McKenzie

[Peter Primrose]

Thank you Cameron for the insight!

1. I corrected the code (annotation) on Employee and added

    
    @OneToMany(mappedBy="id", targetEntity=Employee.class, fetch=FetchType.EAGER, cascade=CascadeType.ALL) 
    private List<Employee> employees = new ArrayList<Employee>(); 

2. per your question:
*You are indeed getting departments back from your query, right? How many departments get returned when you size the list? (Just making sure stage one works before digging too deep).

YES! I get 3 departments
the code:

    
		Criteria criteria = session.createCriteria(Department.class);						
		List<Department> departments = criteria.list();
		
		for(Department department : departments)				
			System.out.println(department.getName()+"...total:"+department.getEmployees().size()+"..... empls: "+department.getEmployees().toString());	

consult output:

    
sales...total:0..... empls: []
marketing...total:0..... empls: []
sales...total:0..... empls: []

you can see that there are no empls in the department, it says total 0...(but there are, when I run ListEmployees I can see what department he belongs to)