> -----Original Message----- > From: Thomas Yip [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 19, 2001 2:29 AM > To: [EMAIL PROTECTED] > Subject: Re: [castor-dev] More again: JDO mapping: foreign > key to same table > > > Self-reference relationship is not supported either. Sorry Mike. Current castor from CVS support self-reference for both 1:N and M:N relations (I tested it with PostgreSQL) for loading objects and for OQL. Petr > 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 > ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
