Self-reference relationship is not supported either. Sorry Mike. Thomas -----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] >Sent: Friday, September 14, 2001 11:21 AM >To: [EMAIL PROTECTED] >Subject: [castor-dev] More again: JDO mapping: foreign key to same table > > >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 > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
