About jpql

Possible issue for JPQL IN expression with a set of more than one string literals values in the path expression. Error: Exception in thread "main" [ObjectDB 2.3.7_10] SELECT e FROM MyEntity e WHERE e ... : Unexpected query token ',' (closing ')' is missing) Thanks This is one of the few elements of JPQL

Hi, I know a single command in MySQL can find repeated records:
Select * from TTT t where id in (select id from TTT s group id having count(id)>1) I dont know how to do this using JPQL, but I use query from 430,000 records and put them into hashmap, finally it cost one hour and failed

JPQL 2.0 adds support of CASE statements for conditional expressions in queries, similarly to switch/case/default in Java, and based on the SQL syntax. Case statements are currently not supported by ObjectDB. I wish to express also my interest in CASE statement support, which I need for conditional

The JPQL (Java Persistence Query Language) supports defining subqueries, which are nested queries that are embedded in other queries. Subqueries are currently not supported by ObjectDB, and as a workaround, you can use a sequence of two or more queries, where the results of one query serves as