Hello,

currently I've got the following mapping from table 'Model' to 'FaceLift' (1:n bi-directional association):

[code]
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC
"-//Hibernate/Hibernate Mapping DTD 2.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">
<hibernate-mapping>
<class
name="com.bosch.mds.types.vehicle.Model"
table="model"
>
<id name="id" type="long">
<generator class="native"></generator>
</id>
<set name="faceLifts" access="com.bosch.mds.hibernate.PropertyAccessor" cascade="all" inverse="true">
<key column="owner_id"/>
<one-to-many class="com.bosch.mds.types.vehicle.FaceLift"/>
</set>

<property name="name" type="string" access="com.bosch.mds.hibernate.PropertyAccessor"/>

</class>
</hibernate-mapping>
[/code]

and

[code]
<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 2.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd" >
<hibernate-mapping>
<class
name="com.bosch.mds.types.vehicle.FaceLift"
table="face_lift"
>
<id name="id" type="long">
<generator class="native"></generator>
</id>
<property name="description" type="string" access="com.bosch.mds.hibernate.PropertyAccessor" />
<many-to-one column="owner_id" name="model" access="com.bosch.mds.hibernate.PropertyAccessor"
class="com.bosch.mds.types.vehicle.Model">
</many-to-one>
</class>
</hibernate-mapping>
[/code]

Now I'd like to change this so that 'FaceLift' becomes a collection of dependent objects within 'Model'.
I'Ve tried some approaches (i.e. only one mapping file for 'Model' containing:
<set name="faceLifts" table="face_lift" access="com.bosch.mds.hibernate.PropertyAccessor" >
<key column="id">
<composite-element class="com.bosch.mds.types.vehicle.FaceLift" >
<property name="description" type="string" access="com.bosch.mds.hibernate.PropertyAccessor" />

<property <many-to-one column="owner_id" name="model" access="com.bosch.mds.hibernate.PropertyAccessor"
class="com.bosch.mds.types.vehicle.Model">
</many-to-one>
</composite-element>
</set>

) retaining all properties of both tables. But I either receive that NULL can't be inserted in column 'owner_id' or 'id' of 'FaceLift'.
Can anybody tell me how a correct mapping could be? Thanks in advance.

Oliver

Hello,

after further testing I don't use the 'id' from 'FaceLift' anymore and take the other properties as PrimaryKey. Now everything works fine.


Regards
Oliver