File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes Hibernate - can't get the collection (List) when create criteria Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "Hibernate - can Watch "Hibernate - can New topic
Author

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

Peter Primrose
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
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)




BUT when I do this


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

Employee:


and Department


Thank you!
Cameron Wallace McKenzie
author and cow tipper
Saloon Keeper

Joined: Aug 26, 2006
Posts: 4968
    
    1

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:







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
Ranch Hand

Joined: Sep 10, 2004
Posts: 755
Thank you Cameron for the insight!

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


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:

consult output:


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)

 
 
subject: Hibernate - can't get the collection (List) when create criteria
 
Similar Threads
Joining tables
Simple requirement .. but I don't know how!
Querying Based On Member of Contained Collection
Parent - Child relationships
Hibernate:What 'criteria.add(Restrictions' should be added to remove getting the list of'empl_notes'