Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 8354 invoked from network); 27 Mar 2009 17:05:07 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 27 Mar 2009 17:05:07 -0000 Received: (qmail 96301 invoked by uid 500); 27 Mar 2009 17:05:07 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 96283 invoked by uid 500); 27 Mar 2009 17:05:06 -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 96114 invoked by uid 99); 27 Mar 2009 17:05:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 17:05:06 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [74.125.92.144] (HELO qw-out-1920.google.com) (74.125.92.144) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 17:04:58 +0000 Received: by qw-out-1920.google.com with SMTP id 5so948437qwc.28 for ; Fri, 27 Mar 2009 10:04:37 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.85.21 with SMTP id m21mr1041114qcl.9.1238173476598; Fri, 27 Mar 2009 10:04:36 -0700 (PDT) In-Reply-To: <722286.62967.qm@web111110.mail.gq1.yahoo.com> References: <722286.62967.qm@web111110.mail.gq1.yahoo.com> Date: Fri, 27 Mar 2009 13:04:36 -0400 Message-ID: <5adb61290903271004r29d88493k1600108b69744452@mail.gmail.com> Subject: Re: Relationships without FK constraints? From: Michael Gentry To: user@cayenne.apache.org Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org I don't reverse engineer often, but I believe if the constraints aren't defined in the DB, then the reverse engineering process has no way of knowing about the relationship, so you have to go in after-the-fact and add it to your model by hand. A little cumbersome, but hopefully not too bad (unless you have a huge model). mrg On Fri, Mar 27, 2009 at 12:59 PM, Joseph Schmidt wrote: > >> I've used Cayenne with a DB that >> didn't have FK constraints (the DB >> basically only had PK uniqueness constraints).=A0 Worked >> fine. > Nice. Good to know :). > >> Just map >> things correctly in the modeler. > But the Cayenne Modeler doesn't recognize those relationships when revers= e engineering the DB, does it? > > Or am I doing something wrong? > > Thanks > Joseph. > > > > > >