Criteria Query with multiple cascaded joins involved

Question

I have three entities: Block, Viewand TargetBlockand want to create a JPA Criteria query for the following sql.

select * from Block INNER JOIN TargetBlock tb ON tb.blockID = b.blockID INNER JOIN view v ON tb.viewID = v.viewID

Block has many views and many TargetBlocks.

This is neither a valid Criteria or JPQL query. What is your question exactly? — Perception, Nov 28 '12 at 06:51
i want to convert this query to a criteria query... the second inner join is joining targetBlock's viewId with viewId from View entity. I am not sure how to add this on condition in criteria query as default is inner join will be blockID. — user942309, Nov 28 '12 at 06:55

score 0 · Answer 1 · answered Nov 28 '12 at 14:41

0

For documentation of the Criteria API see,

answered Nov 28 '12 at 14:41

James

1 Answers1