I have a field in a class called IOS that is not getting populated from
the foreign key definition in the scientist reference-descriptor shown
in IOS class-descriptor. Here is the class descriptor containing the
field scid that is not getting populated on insertion:
<class-descriptor
class="gov.nih.nidb.persistent.IOS"
table="NSD.IPID_ORID_SCID"
>
<field-descriptor
name="ipid"
column="ipid"
jdbc-type="BIGINT"
primarykey="true"
/>
<field-descriptor
name="scid"
column="scid"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor
name="orid"
column="orid"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor
name="order"
column="orders"
jdbc-type="Integer"
/>
<field-descriptor
name="role"
column="role"
jdbc-type="VARCHAR"
/>
<field-descriptor
name="modificationDate"
column="mdate"
jdbc-type="TIMESTAMP"
access="readonly"
/>
<field-descriptor
name="year"
column="ryear"
jdbc-type="INTEGER"
/>
<field-descriptor
name="fte"
column="fte"
jdbc-type="DOUBLE"
/>
<reference-descriptor name="report"
class-ref="gov.nih.nidb.persistent.Report">
<foreignkey field-ref="ipid" />
</reference-descriptor>
<reference-descriptor name="scientist"
class-ref="gov.nih.nidb.persistent.Scientist">
<foreignkey field-ref="scid" />
</reference-descriptor>
</class-descriptor>
The ipid field is getting populated from the report class correctly.
Does anyone know what the cause of the problem might be?
Jim Wright