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 |
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 | Help with 'not like/lower' query William You are talking about criteria queries but your first query is a JPQL query. Is it the JPQL |
6 | How do I achieve a Deep Fetch using JOIN FETCH? that I can express one level of eager fetch in JPQL as follows: SELECT c FROM C JOIN FETCH c.bList |
6 | Get the last occurence of a list attribut "(" and the "LIMIT". Is it possible de make a sub request in a JPQL query ? dwighthaul Paul HUBERT Subqueries |
6 | ObjectDB data migration/extractionHi What is the way to extract data from ObjectDB to relational databases (Oracle). We need to feed an Oracle database with data for reporting/datawarehosing. Should JPQL be used or is there some tools to do it. Thanks. peric.emil Emil Perić Currently there is no such tool |
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 BIRT Driver UpdateThe ObjectDB BIRT/ODA driver is an extension of the open source Business Intelligence and Reporting Tools (BIRT) that adds support of ObjectDB as a data source and JPQL as a data set query language. In the current implementation ObjectDB is embedded in the driver. Any 2.x version of the driver |
1 | ObjectDB 2.3.7 and issue #634). Fixed a bug in using JPQL operations (e.g. UPPER) in DISTINCT results. Fixed an exception |
1 | ObjectDB 2.0.4 when using GWT/Jetty. Fixed a bug in using fields of embedded primary key in JPQL queries. |
