Hi All,
I have 2 tables
1. Dept Table where in i have deptid,divid,dname,address as columns
2. Divsion table where in i have deptid,divid,divname,address, as columns

How can i map these two tables in .xml using one-to-one relation ship?
(generated .hbm.xml file will be of more help)

I)the Dept table has primary keys deptid,divid
II)the Divsion table has primary keys deptid,divid (these are the foreign keys)

and also one more question do all the tables need to have primary key?if yes why?

regards
Reddy

Column keys are declared in there own group.
eg one-to-one (one side) :

<many-to-one
name="bid"
class="org.hibernate.workshop.toolset.Bid"
>
<column name="FIRST_ID" />
<column name="SECOND_ID" />
</many-to-one>


Then on the other side.
<one-to-one
name="item"
class="org.hibernate.workshop.toolset.Item"
outer-join="auto"
property-ref="bid"
/>

Where the property ref refers to the foreign key property.
NOTE: Hibernate 2.1 required for this mapping.

Primary key is best otherwise need to do equals/hashcode over the full set.