Return-Path: Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: (qmail 51889 invoked from network); 10 Apr 2009 17:13:34 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 10 Apr 2009 17:13:34 -0000 Received: (qmail 17304 invoked by uid 500); 10 Apr 2009 17:13:34 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 17259 invoked by uid 500); 10 Apr 2009 17:13:34 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 17249 invoked by uid 99); 10 Apr 2009 17:13:34 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 10 Apr 2009 17:13:34 +0000 X-ASF-Spam-Status: No, hits=-0.6 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_MED,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [64.18.2.217] (HELO exprod7og115.obsmtp.com) (64.18.2.217) by apache.org (qpsmtpd/0.29) with SMTP; Fri, 10 Apr 2009 17:13:24 +0000 Received: from source ([209.85.217.180]) by exprod7ob115.postini.com ([64.18.6.12]) with SMTP ID DSNKSd9+HcDdpLR8+n8Ai+EPvTaQ49Y5QKDw@postini.com; Fri, 10 Apr 2009 10:13:03 PDT Received: by gxk28 with SMTP id 28so2544865gxk.2 for ; Fri, 10 Apr 2009 10:13:01 -0700 (PDT) MIME-Version: 1.0 Received: by 10.231.36.8 with SMTP id r8mr156477ibd.44.1239383581319; Fri, 10 Apr 2009 10:13:01 -0700 (PDT) In-Reply-To: <44ce749d.589b6a3c.49df69e1.6c7ce@o2.pl> References: <1f6aacb70904062211n66be620fj9d58fcd568d70739@mail.gmail.com> <44ce749d.589b6a3c.49df69e1.6c7ce@o2.pl> Date: Fri, 10 Apr 2009 13:13:01 -0400 Message-ID: Subject: Re: Multiple join fetches From: Daryl Stultz To: users@openjpa.apache.org Content-Type: multipart/alternative; boundary=0021cc0224d21ae43d0467367ab9 X-Virus-Checked: Checked by ClamAV on apache.org --0021cc0224d21ae43d0467367ab9 Content-Type: text/plain; charset=ISO-8859-2 Content-Transfer-Encoding: quoted-printable On Fri, Apr 10, 2009 at 11:46 AM, Mi=B3osz Tylenda wrote: > Hi Daryl, > > Are you sure your native query is what you want? In case I wasn't clear, the "native query" is not part of the code I'm running, but just something I'm running in a sql console to double-check things. > There might be some caveats with join precedence. No idea which database > you run against but to take an example, MySQL has the following: I'm running PostgreSQL. I admit I'm a little confused because there are no commas in the from table clause. I never use that approach, preferring explicit joins. As well, the data returned from the query agrees with the data imported from a text file and the variation run with the fetch plan commented out. So, yeah, I'm sure. --=20 Daryl Stultz _____________________________________ 6 Degrees Software and Consulting, Inc. http://www.6degrees.com mailto:daryl@6degrees.com --0021cc0224d21ae43d0467367ab9--