i am getting a problem while establishing "0ne-to-many" relation between tables Accessor and ACCSR_RI_SEC_AUTH

because "ACCSR_RI_SEC_AUTH" has a composite key and when i write set as

in accessor,it has only on column as a key. while mapping it searches column="ACCSR_KEY" as FK in ACCSR_RI_SEC_AUTH
but here "ACCSR_KEY" is one of the columns in composite key.

so it throws me an error while saving something like "can not insert Null for ACCSR_KEY"
so can u suggest me some solution
here are my mappings files

for accessor----------
<hibernate-mapping>
<class name="com.singulartruth.service.security.app.entity.Accessor" table="ACCSR" dynamic-update="true"
optimistic-lock="version" mutable="true" polymorphism="implicit">

<id name="key" column ="ACCSR_KEY">
<generator class="sequence">
<param name="sequence">SEQ_ACCSR_KEY</param>
</generator>
</id>

<set name="securityAuthCodeSet" table="ACCSR_RI_SEC_AUTH">
<key column="ACCSR_KEY"/>
<one-to-many class="com.singulartruth.service.security.app.entity.AccessAuthorization"/>
</set>
and for ACCSR_RI_SEC_AUTH---------

<hibernate-mapping>
<class name="com.singulartruth.service.security.app.entity.AccessAuthorization" table="ACCSR_RI_SEC_AUTH">

<composite-id>
<key-property column="ACCSR_KEY" name="key"/>
<key-property column="RSRC_ITEM_KEY" name="resourceItemKey"/>
<key-property column="SEC_ACCES_CODE" name="securityAccessCode"/>
<key-property column="START_DATE" name="startDate"/>
</composite-id>
</hibernate-mapping>

Key in the set is one of columns of composite key so accessor is not getting exact FK to set key value automatically by set

That's correct behavior. <composite-id> element defines a natural key, i.e. it's user responsibility to fill in the necessary properties before storing the object. I.e. if you have a not-null constraint on ACCSR_KEY column and don't fill that property at the java level you get an integrity violation exception and that's correct.

Solution is to fill all necessary values at the java code if you're using natural keys or switch to surrogate keys and generate them automatically.