Tables with foreign keys to themselves don't maintain Lists of related rows.

Tue, 23 Sep 2003 13:56:29 -0700 

I've got a table with a foreign key to itself. 

Shouldn't the BaseXXX class maintain a List of related rows based on
that foreign key...

For example... 

<table name="XXX">
        <column name="XXX_ID" type="VARCHAR" size="40"
primaryKey="true"/>
        <column name="SUPER_ID" type="VARCHAR" size="40"/>
        <foreign-key foreignTable="XXX">
            <reference local="SUPER_ID" foreign="XXX_ID"/>
        </foreign-key>
</table>

Shouldn't there be a property on BaseXXX called collXxx of type List??
(there isn't one)
There are other tables with foreign keys to this table and such Lists
exist for those tables.
I'm using version 3.1?
Is this by design?  Or is this a short-coming?

Thanks,
-Gary

Reply via email to