About JPQL

forum_thread

Help with 'not like/lower' query

Hi again,   Honestly, I'm fairly new with JPA2 Criteria queries - but as far as code effort goes, it has saved me a bit of pain. I'm writing a dynamic query builder (only 1 level deep for basic entities) - but  even though I get most queries to work, I am getting the following error. This is using Criteria with a combination of LOWER/UPPER - NOT LIKE: ... talking about criteria queries but your first query is a JPQL query. Is it the JPQL that was generated by ObjectDB from a criteria query using toString ? ...

 
forum_thread

Problem with distinct select, order by and equivalent alias/attribute path

Hi, while working with a (standard-)JPA-query generating framework we run into an exception when ordering the results of some projection when the order by expression is different (though logically equivalent) to the projection expression. Here is the example: ... 2016-01-10 16:51 JPQL restricts ORDER BY expressions to expressions in the SELECT clause. ... be better to repair that library to generate valid JPQL queries. ObjectDB Support ObjectDB - Fast ...

 
faq

Is ObjectDB a NoSQL Database?

... complex queries, using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO Query Language). The ...

 
forum_thread

ORDER BY problem, when String starts with language specific character

Dear all, I have a problem with ORDER BY clause. I have a simple query: select u from User u order by u.name When the name starts with "normal/english" character, records are ordered correctly. But when it starts with language specific character like 'Č', these records are placed after records with normal charaters. So records with 'Č' are after 'Z', but this is not correct, because 'Č' is between 'C' and 'D'. ... supports method invocation in queries (as an extension to JPQL and JDOQL) you can use the Normalizer expression directly in the query ...

 
manual

Retrieving JPA Entity Objects

Explains how to use JPA to retrieve entity objects from the database.... is to use queries. The official query language of JPA is JPQL (Java Persistence Query Language). It enables retrieval of objects from ... as well as complex, sophisticated ones. JPA queries and JPQL are described in chapter 4 . Retrieval by Refresh ...

 
release

2.2.9

... support of navigation through collections  (as a JPQL extension). Added version display to the Server and Explorer ... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
release

2.2.8

... support of navigation through collections  (as a JPQL extension). Added version display to the Server and Explorer ... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
issue

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

Hello! When I run this query SELECT t FROM Unit t WHERE t.lastGeocodedPosition IS NULL OR t.lastGeocodedPosition.receiveTime < :lastGeocodedPosition.receiveTime I get the following exception: ... I am not sure if this should be the case with queries (in JPQL or SQL) because expressions are reordered as part of the query ... I did some research on this topic. The NULL handling of JPQL or SQL queries is well defined. Have a look at the Persistence 2.0 ...

 
forum_thread

Problems down-casting in WHERE clause

I have a family of related types, like this: @Entity class Base { String val1; String val2; }; @Entity class Derived1 extends Base { String val3; }; @Entity class Derived2 extends Base { String val4; };  I'm trying to implement a query which will return all Base objects which have a given string within any of their String-typed fields.  The query I'm using looks somewhat like this: ...  is an invalid expression in JPQL because  messageList is a List and navigation from a list must be ... Apparently there is no support for your query in JPQL or ObjectDB and you should consider workarounds such splitting this query ...

 
forum_thread

New to Product & Having An Issue

Greetings ObjectDB Users! I'm new to the product, and I've setup a simple test after reading the tutorial, and I'm running into some issues with queries, specifically querying by primary key.   I have a domain object class Called Department, which has a member of type DomainId.  DomainId has two member fields:  String accountId and String objectId.  The following code shows these two classes.... wrong with the use of @Embedded, @EmbeddedId or with my JPQL queries or is this a bug? Any help would be greatly appreciated. ... generating new departmentId. I am looking now at the JPQL query issues, which might indicate an ObjectDB bug. ...