cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fredrik Liden" <fli...@translate.com>
Subject RE: Self-join
Date Tue, 12 Jun 2007 20:33:44 GMT
I like Vanilla Cayenne :-)
Maybe I'll give it a try then.

Thanks,
Fredrik


-----Original Message-----
From: Andrus Adamchik [mailto:andrus@objectstyle.org] 
Sent: Tuesday, June 12, 2007 2:14 PM
To: user@cayenne.apache.org
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 <fliden@translate.com> 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
>>
>


Mime
View raw message