Java JPA Inner JOIN with WHERE statement

Question

Hi folks,

I want to annotate following structure:

I have this query:

SELECT A.*, BES.*, BES_2.*
INNER JOIN BES ON A.a = BES.a AND A.b = BES.b
INNER JOIN BES AS BES_2 ON A.a = BES_2.a AND A.b = BES_2.b
WHERE (BES.c = N'foo') AND (BES_2.c = N'bar')

I have the entities Job (representing A) and JobEndPoint (representing BES). The Job object should contain two JobEndPoint which map like a one-to-one relation. I need two JOIN the table two times checking for the same values only differed by the column "c" which I check in the WHERE statement.

@OneToOne
private JobEndPoint from;

@OneToOne
private JobEndPoint to;

My problem is now that the database columns and the object fields differ a lot and I don't know how to add the WHERE statement.

Thanks a lot if anyone can help!

Marco

Answer 1

i have the same problem, somebody can help me