JPA: contains()/in() don't work for member collections

[Maia Everett]

I have two classes with a one-to-many association through a List. When I try to make a query using contains() or in() with the member collection, JPAQuery generates an IN ELEMENTS() query, which is Hibernate-specific. Instead, it should use MEMBER OF, which is part of the JPA standard.

As a workaround, currently I use the reverse mapping reference for comparison, i.e. q2.parent.eq(q1) instead of q1.children.contains(q2) or q2.in(q1.children). Still not very clean.

[Timo Westkämper (timo-westkamper)]

The JPAQuery uses HQLTemplates by default because we prioritize Hibernate compatibility. For JPA 2 standard compliant JPQL use JPQLTemplates.DEFAULT instead.

e.g.

JPAQuery query = new JPAQuery(entityManager, JPQLTemplates.DEFAULT);

[Timo Westkämper (timo-westkamper)]

Maia, does the proposed solution work for you?

[Maia Everett (linneris)]

Haven't tested. I'll do so tomorrow. (I also think the documentation should clearly state the fact that a Hibernate-compatible mode is used by default. Implementation independence is the whole point of the JPA standard.)

[Timo Westkämper (timo-westkamper)]

Yes, you are right. I just updated the documentation concerning this.