CODEWITHSUNDEEP
jpaouter-join
Dewfy
Dewfy

Reputation: 23644

JPA OUTER JOIN without relation

I need make OUTER JOIN of two entities in JPA (saying master, detail), but the problem that at the entity level there are no relations (and I don't want add it).

@Entity
class Master
{
    @Column(name="altKey")
    Integer altKey;
}

@Entity
class Detail
{
    @Column(name="altKeyRef")
    @Basic (optional = true)
    Integer altKeyRef;
}

SELECT m, d FROM Master m OUTER JOIN ????? d.altKeyRef = m.altKey

Upvotes: 3

Views: 3590

Answers (1)

Pascal Thivent
Pascal Thivent

Reputation: 570525

My understanding of the spec (see 4.14 BNF) is that a [ LEFT [OUTER] | INNER ] JOIN mush be done along a path expression (either a single valued association field or a collection valued association field).

Upvotes: 5

Related Questions