Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 70145 invoked from network); 28 Mar 2009 16:29:46 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 28 Mar 2009 16:29:46 -0000 Received: (qmail 2795 invoked by uid 500); 28 Mar 2009 16:29:45 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 2742 invoked by uid 500); 28 Mar 2009 16:29:45 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 2732 invoked by uid 99); 28 Mar 2009 16:29:45 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Mar 2009 16:29:45 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of mkienenb@gmail.com designates 209.85.221.136 as permitted sender) Received: from [209.85.221.136] (HELO mail-qy0-f136.google.com) (209.85.221.136) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 28 Mar 2009 16:29:37 +0000 Received: by qyk42 with SMTP id 42so2693392qyk.26 for ; Sat, 28 Mar 2009 09:29:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:in-reply-to:references:date :received:message-id:subject:from:to:content-type :content-transfer-encoding; bh=/4h8RLAvXBBE/Nz1PoVXgCUopvLnn1aRAHKRcY1QrBE=; b=tosLMlowVxA5URso6haJkPnLZ3uO1gPiO3ugNdjR+uOBoX0kR/pQmsJIPLeJd/Ntr7 J5wHqObfNJEckjx+7FVvGENqXQ2UB6w9Th/kGCDRPL+ZgZjybI8QK8+BVVrar9qud57+ sqTbew+fYxjCA9xNsoKTWNBnhviXx7c5JlMRE= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; b=Na9+CoETkxJc3yLIIv5T9+HhlwsBFjnUDQ8Wf5HzxVNniyO/EUBvuajxFJ1N0L2ggU 9XZwWY6ztE9IOX+0Pyzf7gn8sFAsACpZ5tF92PEatiyeczZhsRW+2fgwAXhoHNGKlgc/ pgweGdaJbuIaalsx41iSb4Y1arrM3e6yGjBYk= MIME-Version: 1.0 In-Reply-To: <930547.24813.qm@web111108.mail.gq1.yahoo.com> References: <930547.24813.qm@web111108.mail.gq1.yahoo.com> Date: Sat, 28 Mar 2009 12:28:59 -0400 Received: by 10.229.96.132 with SMTP id h4mr1347437qcn.65.1238257755280; Sat, 28 Mar 2009 09:29:15 -0700 (PDT) Message-ID: <8f985b960903280928u3dd13155q774174f0f2fbbece@mail.gmail.com> Subject: Re: Does Cayenne require a reversed relationship? From: Mike Kienenberger To: user@cayenne.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org It used to be true that the reverse db relationship was required, but the reverse obj relationship was not required. From the application's point of view, it doesn't have to be there. On Sat, Mar 28, 2009 at 12:21 PM, Joseph Schmidt wrote: > > Does Cayenne require the use of a reversed relationship always? > > Of course they're practical, but in many schemes e.g. in the case of the 'user' table, just too many other tables (~2/3 of them) point to it because of the required "updated_by_user_id". > > If reversed relationships would be required, than in this case the User entity would be totally bloated with reverse list attributes to almost all other entities. > > What is the best strategy to map in this case? > > Thanks, > Joseph. > > > > >