Eclipse Community Forums: EclipseLink » Outer Join with 3 tables is not working

Home » Eclipse Projects » EclipseLink » Outer Join with 3 tables is not working(Outer join with 3 tables is issuing a lot of selects for each relation on each row.)

Show: Today's Messages :: Show Polls :: Message Navigator

Outer Join with 3 tables is not working [message #844402]

Sat, 14 April 2012 00:53

Missing name Missing name

Messages: 3
Registered: June 2010

Junior Member

Table A has One to One relation with Table B on non primary key of Table A
Table A has One to One relation with Table C on primary key of Table C

While I retrieve rows of Table A with simple JPQL query, I am getting outer join effect but, Eclipse link is issuing One select for rows of Table A and One select to fetch related objects of Table B and Table C. So if Table A has 25 rows, I am seeing 51 selects in all.

How can I tell Eclipselink to issue one select with 2 outer joins.

Thanks
Suri

Report message to a moderator