I have two table with 1:1 association. How can I realize a reference with 2 foreign
keys where one of them is a constant?
I should read in the INT.GKN_GENERIC_MAPPING_VALUES_ALL with following keys:
- "22" (constant)
- ORIGINATING_SYSTEM_ID
many thanks in advance
Johann
<class-descriptor
class="com.gknplc.db.wlive.StgPartBasisPriceOvr"
table="STG.STG_PART_BASIS_PRICE_OVR"
>
<field-descriptor
name="originatingSystemId"
column="ORIGINATING_SYSTEM_ID"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor
name="year"
column="YEAR"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor
name="localPartNumber"
column="LOCAL_PART_NUMBER"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor
name="basePriceRu"
column="BASE_PRICE_RU"
jdbc-type="NUMERIC"
/>
<field-descriptor
name="basePriceCurrency"
column="BASE_PRICE_CURRENCY"
jdbc-type="VARCHAR"
/>
<reference-descriptor
name="aMappingValues"
class-ref="com.gknplc.db.wlive.GknGenericMappingValuesAll"
auto-retrieve="true"
auto-update="false"
auto-delete="false">
<foreignkey field-ref="??????"/>
<foreignkey field-ref="originatingSystemId"/>
</reference-descriptor>
</class-descriptor>
<class-descriptor
class="com.gknplc.db.wlive.GknGenericMappingValuesAll"
table="INT.GKN_GENERIC_MAPPING_VALUES_ALL"
>
<field-descriptor
name="typeId"
column="TYPE_ID"
jdbc-type="INTEGER"
primarykey="true"
/>
<field-descriptor
name="systemId"
column="SYSTEM_ID"
jdbc-type="VARCHAR"
primarykey="true"
/>
<field-descriptor
name="oracleValue"
column="ORACLE_VALUE"
jdbc-type="VARCHAR"
/>
</class-descriptor>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
