67 words

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

2011-12-13 08:41


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>




quasado's picture
Joined on 2011-04-30
User Post #49
2011-12-13 10:30

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

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)
support's picture
Joined on 2010-05-03
User Post #799

Post Reply

Please read carefully the posting instructions - before posting to the ObjectDB website.

  • You may have to disable pop up blocking in order to use the toolbar (e.g. in Chrome).
  • Use ctrl + right click to open the browser context menu in the editing area (e.g. for using a browser spell checker).
  • To insert formatted lines (e.g. Java code, stack trace) - select a style in the toolbar and then insert the text in the new created block.
  • Avoid overflow of published source code examples by breaking long lines.
  • You may mark in paragraph code words (e.g. class names) with the code style (can be applied by ctrl + D).
  • Long stack traces (> 50 lines) and complex source examples (> 100 lines) should be posted as attachments.
Maximum file size: 32 MB