9 | JPA does not seem to be db agnostic)); return em.createQuery(query).getSingleResult(); } kasavbere kasav A valid JPQL query ... JPQL by supporting queries with no SELECT. support Support |
9 | String representation of a queryHi, Is it possible to get a JPQL string having a Query object instance? JpaQuery class doesn't have any method like "getQueryString" or "getDatabaseQuery", maybe it's going to be added in near future ... that information with JPQL string and parameters map to find and optimize the most ineffective cases. kborkowski |
9 | order by string with numbers The sql that works is ORDER BY CAST(SUBSTR(username FROM 4) AS UNSIGNED) ASC Using JPQL SELECT u FROM ... is supported by ObjectDB in JPQL string queries. You may try using Integer.parseInt as a JPA criteria query function. support Support |
9 | native sql queries. But since SQL and JPQL are very similar it could be possible in future releases to support "native SQL". But JPQL is preferred so this feature would be in a low priority. Anyway, the expected |
9 | Problems down-casting in WHERE clause) ((Practice)e).messageList.message is an invalid expression in JPQL because messageList is a List ... expression. Apparently there is no support for your query in JPQL or ObjectDB |
6 | CriteriaQuery .where() for multiple conditions, it looks fine. You may also check the result query string (JPQL) by toString() on the criteria query. support Support |
6 | UTF ErrorI tested ObjectDB. When I write JPQL, I get this error. Caused by: com.objectdb.o.InternalException: Error reading UTF string at com.objectdb.o.BYR.U(BYR.java:1217) at com.objectdb.o.BYR.U(BYR.java:523) at com.objectdb.o.BYR.L(BYR.java:504) at com.objectdb.o.QJD.a(QJD.java:241 |
1 | JPA Query Criteria API (JPA 2.0)The JPA Criteria API supports dynamic definition of JPQL queries using CriteriaBuilder as a factory. ObjectDB supports dynamic definition of JPQL queries as strings. Support of the new JPA 2 Criteria API in expected in future versions. support Support Implementation of the JPA Criteria Query API |
1 | ObjectDB 2.5.1) relationships. Fixed a bug in using IN expression in criteria queries. Fixed processing an IN(:param) expression in JPQL queries. |
1 | Strange Error with Criteria API and Sorting the ORDER BY clause". This is not just an ObjectDB limitation but a known JPQL and also SQL limitation |
