openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From QkI <kukis...@gmail.com>
Subject Unnecesery INNER JOIN
Date Thu, 15 Jul 2010 13:19:07 GMT

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

@Entity
public class B {

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

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

my SQL output looks like:
SELECT t1.id FROM table_b t0 INNER JOIN table_a t1 ON t0.a_id = t1.id WHERE
(t0.id = 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/Unnecesery-INNER-JOIN-tp5297321p5297321.html
Sent from the OpenJPA Users mailing list archive at Nabble.com.

Mime
View raw message