Hi, Is it possible to use two columns as 'fk-pointing-to-this-class' since inserts will yield null in other column on current configuration. I cannot change the way it looks like in the database. Is my only option to use the indirection table and have it in the collection instead of having CEquipment in the CSystem?
I've tried to use "SYSTEMID VERKID" as fk-pointing-to-this-class column but it does not work. Many Regards, Mario Collection descriptor: " <collection-descriptor name="equipmentInfo" element-class-ref="solo.test.dataobjects.CEquipment" auto-retrieve="true" auto-update="false" indirection-table="DTA.SYSTEMTABLE"> <fk-pointing-to-this-class column="SYSTEMID" /> <fk-pointing-to-element-class column="EQNUM"/> </collection-descriptor> " Indirection table: "<class-descriptor class="solo.test.dataobjects.CSystemVesselMapping" table="DTA.SYSTEMTABLE"> <field-descriptor id="0" name="equipmentId" column="EQNUM" jdbc-type="VARCHAR" nullable="false" length="12" indexed="true" primarykey="true" /> <field-descriptor id="1" name="plantId" column="VERKID" jdbc-type="INTEGER" nullable="false" index="true" /> <field-descriptor id="2" name="systemId" column="SYSTEMID" jdbc-type="INTEGER" nullable="false" index="true" primarykey="true" /> </class-descriptor> " --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]