Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@openjpa.apache.org
Received-SPF: pass (nike.apache.org: local policy)
From: Russell Collins <Russell.Collins@mclaneat.com>
To: "'users@openjpa.apache.org'" <users@openjpa.apache.org>
Date: Thu, 15 Jul 2010 16:41:09 -0500
Subject: RE: Unnecesery INNER JOIN
Thread-Topic: Unnecesery INNER JOIN
Thread-Index: AcskPOVgPQ9rRqX2ST6I3fThAbHfBQAKRz4A
Message-ID: 
 <69BEFCE5AAEBCA44B1301AD2360E83C7BEA00953EB@MATSVEC14.mclane.local>
References: <1279199947537-5297321.post@n2.nabble.com>
In-Reply-To: <1279199947537-5297321.post@n2.nabble.com>
Accept-Language: en-US
Content-Language: en-US
acceptlanguage: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

>From the looks of what you have in your query, there has to be a join of so=
me kind.  You are trying to get the "id" of class "A" that is associated wi=
th class "B".  If this is not your desire, what are you trying to do?

-----Original Message-----
From: QkI [mailto:kukismen@gmail.com]
Sent: Thursday, July 15, 2010 8:19 AM
To: users@openjpa.apache.org
Subject: Unnecesery INNER JOIN


Hi,
Let's say I have the following persistence class:

@Entity
public class B {

  @OneToOne(cascade =3D CascadeType.PERSIST, fetch =3D FetchType.LAZY)
  @JoinColumn(name =3D "a_id")
  private A a;
}

and when I try to execute this JPA query:
SELECT b.a.id FROM B where B.id =3D 123

my SQL output looks like:
SELECT t1.id FROM table_b t0 INNER JOIN table_a t1 ON t0.a_id =3D t1.id WHE=
RE
(t0.id =3D 123)

Why does openJPA add unnecesery JOIN to the SQL query.
Can I somehow change this behaviour of openJPA

Thanks,
QkI


--
View this message in context: http://openjpa.208410.n2.nabble.com/Unneceser=
y-INNER-JOIN-tp5297321p5297321.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

CONFIDENTIALITY NOTICE: The information contained in this electronic mail (=
email) transmission (including attachments), is intended by MCLANE ADVANCED=
 TECHNOLOGIES for the use of the named individual or entity to which it is =
addressed and may contain information that is privileged, confidential and/=
or protected as a trade secret. It is not intended for transmission to, or =
receipt by, any individual or entity other than the named addressee(s). If =
you have received this email in error, please delete it (including attachme=
nts) and any copies thereof without printing, copying or forwarding it, and=
 notify the sender of the error by email reply immediately.