java - How to JPA join from child element -
i want select elements via jpa query/criteriaquery can't quite figure out how it.
i'm using h2 db. query i've tested in h2 console is:
select element.*  element left join group_element on element.id  = group_element.elements_id group_id null   in other words want select groupless elements.
classes are:
@entity class element{     @id     @generatedvalue     private integer id; }  @entity class group{     @id     @generatedvalue     private integer id;      @manytomany     private list<element> elements; }   i've had no problem doing in similar cases "elements" mapped field in element, in specific case can't add field. can't quite figure out how join entities in case.
jql joins owner owned. groupless elements do
select e element e e not in (select e2 group g inner join g.elements e2)      
Comments
Post a Comment