one to many implementation in java

[vineetbindal]

Hi all,

I have a question it may sound pretty naive to all of you guys but i am trying it from last 2 days.

I am trying to implement one-to many relationship using hibernate below is my mapping file

<class name="ManagerDTO" table="Manager">
<id name="managerId" type="int" column="manager_id"> <generator class="native"/></id>
<set name="managerToEmployee" cascade="all" inverse="true">
<key column="manager_ide"/>
<one-to-many class="EmployeeDTO"/>
</set>
<property name="managerName" type="string" column="manager_name" length="255" not-null="true"/>
</class>
<class name="EmployeeDTO" table="Employee">
<id name="emploeeId" type="int" column="employee_id"> <generator class="native"/></id>
<property name="employeeName" type="string" column="employee_name" length="255" not-null="true"/>
<many-to-one name="managerToEmployee" column="manager_ide" lazy="false" class="ManagerDTO"/>
<!--<many-to-one name="enrolledDTO" column="sectionId"  lazy="false" class="SectionDTO" fetch="join"/> -->  

</class>

i need a query which will select all the managers and employees work for them

which collection set i can use for it?

can i do it in one query or first i have to get all the managers and then get emplyees one by one for each manager and store them in a list.

i think i can do it with hash table where manager will be the key representing all the employee belongs to him.. but i doono how to implement it.

can someone please give me some direction and the query?