Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 92761 invoked from network); 15 Aug 2008 18:18:05 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 15 Aug 2008 18:18:05 -0000 Received: (qmail 89422 invoked by uid 500); 15 Aug 2008 18:18:03 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 89390 invoked by uid 500); 15 Aug 2008 18:18:03 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 89379 invoked by uid 99); 15 Aug 2008 18:18:03 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Aug 2008 11:18:03 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 15 Aug 2008 18:17:15 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 42A3E234C1AD for ; Fri, 15 Aug 2008 11:17:44 -0700 (PDT) Message-ID: <546691275.1218824264258.JavaMail.jira@brutus> Date: Fri, 15 Aug 2008 11:17:44 -0700 (PDT) From: =?utf-8?Q?Geraldo_Xex=C3=A9o_=28JIRA=29?= To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-694) @SecondaryTable expected behavior is INNER JOIN? MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org @SecondaryTable expected behavior is INNER JOIN? ------------------------------------------------ Key: OPENJPA-694 URL: https://issues.apache.org/jira/browse/OPENJPA-694 Project: OpenJPA Issue Type: Question Components: docs, jpa Environment: Any Reporter: Geraldo Xex=C3=A9o I have some code running that makes me believe that the @Secondarytable ann= otation has the INNER JOIN behavior.=20 I checked both the original JPA specification and many implementations and = none of them talks about the subject. Hibernate, however, has this in the d= ocumentation. Can you confirm it? It has a lot of side effects, for example: 1) Some implementations will not create a row in the secondary table if all= the fields are NULL, this will make an object impossible to retrieve or ed= it. (since the inner join will return null, but it will exist on the primar= y table). 2) Rows from legacy tables that can=C2=B4t be extended, a good reason to us= e secondarytable, will not be retrieved if we do not create, probably "out = of the box", rows in the secondary table, even if we don=C2=B4t have any in= formation to fill there. Can you answer on the implemented behavior and comment on my two examples? Should this be pointed to JPA specification responsibles? Thanks, xexeo --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.