This is my schema fragment. Could you point me, what's wrong? Thank you.I guess your column is named exactly as the related table, eg. foreign column name ="SomeTable" and related table name="SomeTable".
<table name="o_objects" javaName="Item" idMethod="idbroker" description="Objects Table"> ... <column name="o_o_otype" javaName="itemType" required="true" type="INTEGER" description="Book Title"/> ... <foreign-key foreignTable="o_types" > <reference local="o_o_otype" foreign="o_t_id" /> </foreign-key>
</table>
and
<table name="o_types" javaName="ItemType" idMethod="idbroker" > <column name="o_t_id" javaName="itemTypeID" required="true" primaryKey="true" type="INTEGER" description="Object Type Id"/> .... </table>
-- BR, Eugene Nebrat.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]