I like Vanilla Cayenne :-) Maybe I'll give it a try then. Thanks, Fredrik
-----Original Message----- From: Andrus Adamchik [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 12, 2007 2:14 PM To: [email protected] Subject: Re: Self-join Hmm... I know self-joins worked for me in the past with vanilla Cayenne. I haven't used such schemas in a while though. I guess I need to look closer at that bug report. Andrus On Jun 12, 2007, at 10:33 PM, Mike Kienenberger wrote: > Not really sure as I don't use them, but at least one issue with > self-joins is solved if you use my outer join patch for 1.2. > > https://issues.apache.org/cayenne/browse/CAY-732 > > > > On 6/12/07, Fredrik Liden <[EMAIL PROTECTED]> wrote: >> What is the status of self joins in v. 1.2.3? >> From the 2 posts I find in the archive seems like some people are >> using >> it. >> The documentation doesn't mention it. >> Just wondering if it's ok to use or if there are any limitations that >> discourages it's use? >> >> I'm have a set of nodes. I'm guessing the source node will have >> Source_node_id NULL or 0. And then the target nodes will refer >> back to >> the source nodes Node_id. Would it be worth using self joins here or >> should I just look up the target nodes based on the source nodes >> using >> regular queries and not worry about the relations? >> >> NODE >> >> Node_id (pk) >> Text >> Source_node_id (fk) >> >> Thanks! >> Fredrik >> >
