Suppose there are two tables:

DEPT table
DEPTNO (pk)
DNAME
LOC

EMP table
EMPNO (pk)
ENAME
JOB
MGR
HIREDATE
SAL
COMM
DEPTID (fk references dept.deptno)

then here are my bidirectional mappings

Emp.hbm.xml
<hibernate-mapping>

<class name="de.gloegl.road2hibernate.Emp" table="EMP">
<id name="empno" column="EMPNO" type="long" unsaved-value="null">
<generator class="native"/>
</id>
<property name="ename" column="ENAME" type="string"/>
<property name="job" column="JOB" type="string"/>
<property name="mgr" column="MGR" type="long"/>
<property name="hiredate" column="HIREDATE" type="date"/>
<property name="sal" column="SAL" type="long"/>
<property name="comm" column="COMM" type="long"/>
<property name="deptid" column="DEPTID" type="long"/>
<many-to-one name="dept"
class="de.gloegl.road2hibernate.Dept"
column="deptno"/>
</class>

</hibernate-mapping>

Dept.hbm.xml
<hibernate-mapping>

<class name="de.gloegl.road2hibernate.Dept" table="Dept">
<id name="deptno" column="DEPTNO" type="long">
<generator class="native"/>
</id>
<property name="dname" column="DNAME" type="string"/>
<property name="loc" column="LOC" type="string"/>
<set name="employees" cascade="all" inverse="true" lazy="true">
<key column foreign-key="deptid"/>
<one-to-many class="de.gloegl.road2hibernate.Emp"/>
</set>
</class>

</hibernate-mapping>

So, when I try to load the Emp or Dept object, the Hibernate just creates a new column called deptno for me in the EMP table.

Can anybody know what the mapping should be done differently. We can not change the schema. I mean the foreign key deptid in the EMP table can not be renamed to deptno.

Thanks for the help.

In the EMP mapping

delete


change

to


HTH
Ernst

It does help. Thanks to Ernst.