95 | member visiting in jpql? TIA gzdillon Lai Yang The length field of arrays is not supported by JDOQL / JPQL queries |
95 | JPQL ErrorI am trying to run ObjectDB first time in a production server. Operating System: Ubuntu Ubuntu 22.04.1 LTS ObjectDB Version: 2.8.8 (Downloaded) ObjectDB version in Maven: 2.8.8 (I don't know how comes 2.8.1 comes in the error message) When I try to run jpql, it gives this error [ObjectDB 2.8.1 |
95 | Possible issue for JPQL IS EMPTY expressionPossible issue for JPQL IS EMPTY comparison expression: SELECT e FROM MyEntity e WHERE e.collection-valued IS EMPTY throws javax.persistence.PersistenceException: Invalid operand type for operator IS EMPTY (error 756) Thanks. Note: It doesn' t work with SIZE(): SELECT e FROM MyEntity e WHERE SIZE(e |
95 | Will Entire JPQL Supported by ObjectDb? management taken care here ? Thanks in Advance , Jana janu019 Janardhana Some JPQL features are not |
95 | find repeated records by JPQLHi, 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 |
95 | JPQL: Update fails using external object param supported in JPQL UPDATE queries. A better error message should be produced by ObjectDB. See also this forum thread. support Support |
95 | CASE WHEN...THEN...ELSE...END not working using JPQL/JDOQL something or is it an issue with ObjectDB? Anyone could help me on how to use the "case" in JPQL? Thank you in |
89 | JPQL query to get entities that does not have a child entity in their child entitiesJPQL query to get entities that does not have a child entity in their child entities |
19 | JPQL Subqueries (JPA 1.0)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 a parameter in the next queries. support Support |
19 | JPQL Case Statements (JPA 2.0)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. support Support I wish to express also my interest in CASE statement support, which I need |
