Hi,

I have a user table which has composite primary key. I have a requestlog table which has a nullable foreign key which refers to the user tables' composite primary key.

What property do I need to set in the requestlog hibernate xml definition for inserts to allow null foreign key.

Right now I have the association as described below and my inserts are failing with "integrity constraint (XXXX) violated - parent key not found".

<many-to-one name="customerUser" class="CustomerUser" not-found="ignore" not-null="fasle">
<column name="REQL_CUST_ID" precision="18" scale="0"/>
<column name="REQL_USER_ID" precision="18" scale="0"/>
</many-to-one>

Please help.

Thanks,
Sushil