55 words

A nested SELECT

2014-06-24 18:22


I have a query

UPDATE Look l SET l.partlySold = FALSE
WHERE (SELECT count(a) FROM l.things a WHERE a.thing.STATUS != :STATUS) <= 1

which doesn't work: "Unexpected query token 'SELECT'". Does ObjectDB support queries like this?


Vladiator's picture
Joined on 2013-10-20
User Post #10
2014-06-25 12:11

Nested queries (issue #10) is currently not supported by ObjectDB.

See this list of JPA features that are not implemented yet by ObjectDB.

ObjectDB Support
ObjectDB - Fast Object Database for Java (JPA/JDO)
support's picture
Joined on 2010-05-03
User Post #1,976

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