Home » Support » Forum » KEY() / VALUE() not recognized in JPQL??

KEY() / VALUE() not recognized in JPQL??



Explorer says "unexpected token" on KEY(..:

SELECT FROM individual.IndividualContact $1 LEFT OUTER JOIN $1.profile.title.name m
WHERE (KEY(m) = 'deu' AND VALUE(m) LIKE '%Dr%')

profile = embedded entity

title = referenced entity

name = Map<String, String>





Yes, this is one of the last JPA 2 features that are still unsupported (issue #13).

This list of 4 issues includes the main features of JPA 2 that are not implemented yet.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)

Post Reply

To post a reply and/or subscribe to update notifications - please login