[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - Get all the child in in master/child relationship

[pattchen]

Hi, 
I have a master/child relation, and I would like to know how I can get all children of a parent given by its code (key). 
For example, if I would like to know all the employees of a given department, this sql query will give me corresponding results:

select * from Employee e where e.codeDept = "84"

How can I execute this query in Hibernate so that it returns me corresponding Employee entities?

thanks.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4050680#4050680

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4050680