[castor-dev] More again: JDO mapping: foreign key to same table

[[EMAIL PROTECTED]]

Using a table having these columns:

id char8),             -- primary key
parent_node_id char(8) -- foreign key to same table

I am now using this mapping element:

<field name="childNode" type="xdo.Node2" collection="array">
<sql many-key="parent_node_id"/>
</field>

and I am getting this error:

java.sql.SQLException: ORA-01416: two tables cannot be outer-joined
to each other

Any answers?

----------------------------------------------------------- 
If you wish to unsubscribe from this mailing, send mail to
[EMAIL PROTECTED] with a subject of:
        unsubscribe castor-dev