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