Hi

I'm having real problems with a many-to-one mapping. I'm clearly missing something but just can't spot it. Here're my mappings:

<hibernate-mapping>
<class name="Policy" table="policy" >
<id name="id" column="pol_id" type="int" unsaved-value="0" >
<generator class="native"/>
</id>
<property name="dateentered" column="pol_dateentered"/>
<property name="startdate" column="pol_startdate"/>
<property name="mmref" column="pol_mmref"/>
<property name="extref" column="pol_extref"/>
<property name="extref2" column="pol_extref2"/>
<property name="term" column="pol_term"/>
<many-to-one name="user" column="pol_use_id" cascade="save-update"
class="User"/>
</class>
</hibernate-mapping>


<hibernate-mapping>
<class name="User" table="user">
<id name="id" column="use_id" type="int" unsaved-value="0">
<generator class="native"/>
</id>
<property name="username" column="use_username"/>
<property name="password" column="use_password"/>
<property name="forename" column="use_forename"/>
<property name="surname" column="use_surname"/>
</class>
</hibernate-mapping>

If run seperate tests for saving my User and saving Policy (without the user reference) and they run fine.

When I introduce the many-to-one user element I get the following error:

Hibernate operation: could not insert: [Policy]; SQL []; Column 'POL_USE_ID' cannot be null; nested exception is com.mysql.jdbc.exceptions.MySQLIntegrityConstraintViolationException: Column 'POL_USE_ID' cannot be null


I'm doing something like this to populate and save my data:

policy = new Policy();
policy.setUser(new User());
policy.setMmref("XYZ123456");
dao.savePolicy(policy);

and it's the last line that's failing.

Any help is really appreciated.

Best

DF

<hibernate-mapping>
<class name="Policy" table="policy" >
<id name="id" column="pol_id" type="int" unsaved-value="0" >
<generator class="native"/>
</id>
<property name="dateentered" column="pol_dateentered"/>
<property name="startdate" column="pol_startdate"/>
<property name="mmref" column="pol_mmref"/>
<property name="extref" column="pol_extref"/>
<property name="extref2" column="pol_extref2"/>
<property name="term" column="pol_term"/>
<property name="polUseId" column="pol_use_id"/>
<many-to-one name="user" column="pol_use_id" cascade="save-update" class="User" insert="false" update="false"/>
</class>
</hibernate-mapping>