Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 45559 invoked from network); 27 Mar 2009 18:08:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 27 Mar 2009 18:08:03 -0000 Received: (qmail 89882 invoked by uid 500); 27 Mar 2009 18:08:03 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 89858 invoked by uid 500); 27 Mar 2009 18:08:02 -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 89848 invoked by uid 99); 27 Mar 2009 18:08:02 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 18:08:02 +0000 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [209.85.221.136] (HELO mail-qy0-f136.google.com) (209.85.221.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 27 Mar 2009 18:07:56 +0000 Received: by qyk42 with SMTP id 42so2143662qyk.26 for ; Fri, 27 Mar 2009 11:07:35 -0700 (PDT) MIME-Version: 1.0 Received: by 10.229.84.72 with SMTP id i8mr1073661qcl.63.1238177254719; Fri, 27 Mar 2009 11:07:34 -0700 (PDT) In-Reply-To: <844470.51209.qm@web111109.mail.gq1.yahoo.com> References: <844470.51209.qm@web111109.mail.gq1.yahoo.com> Date: Fri, 27 Mar 2009 14:07:34 -0400 Message-ID: <5adb61290903271107n7f0bc9fh8acda9d5f3e86707@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: 7bit X-Virus-Checked: Checked by ClamAV on apache.org I'm not familiar with that option/strategy, but perhaps someone else here has used it and can jump in. mrg On Fri, Mar 27, 2009 at 1:22 PM, Joseph Schmidt wrote: > >> 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, > Well, it could, based on the naming conventions: e.g. > "artist_id" from any table is a relation to "artists" table. > When doing reverse engineering there is the SmartNamingStrategy selectable, that I think is supposed to do exactly this kind of convention based recognition. > At least from it's test class: > cayenne\framework\cayenne-modeler\src\test\java\org\apache\cayenne\modeler\util\SmartNamingStrategyTest.java > it looks like it's trying to test something in this direction. > > Thanks, > Joseph. > > > > >