|Outer Join with 3 tables is not working [message #844402]
||Fri, 13 April 2012 20:53
| Missing name Missing name
Registered: June 2010
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.
Powered by FUDForum
. Page generated in 0.02283 seconds