About JPQL

issue

Update query bug

Some code. Problem in UPDATE query.   ... This UPDATE query is invalid because JPQL UPDATE queries are limited to setting values not collections. ...

 
faq

Is ObjectDB better than competitive object databases?

... including aggregate queries, as part of its support in JPQL (JPA Query Language) and JDOQL (JDO Query Language). ObjectDB is ...

 
forum_thread

Object comparation never matches

Hi! I'm trying to compare 2 identical objects in SELECT with no success: @Embeddable public class PhoneNumber implements Serializable {     int countryCode;     long number;   Which is a part of Customer object: ... But what about: http://www.objectdb.com/java/jpa/query/jpql/comparison Section "Comparable Data Types" Comparison is ...

 
release

2.1.1

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
release

2.1.0

... a bug in using fields of embedded primary key in JPQL queries. Version 2.0.3 Added support ...

 
forum_thread

JPA query of a Set of terms

Hi, Is it possible to write a JPA query to select objects that contain a collection of elements? For example, suppose I have a table that maps a search terms to pages: @Entity public class SearchIndex { @Index SearchTerm term; @Index Page page; } Now suppose I have an array of SearchTerm objects. ie. ... , terms ) ; but it is not standard JPQL and it would be less efficient since indexes cannot be used. ...

 
forum_thread

migration path from JPA / Hibernate

Hi. Is there a conversion tool or documentation that is of help when migrating an existing JPA solution to ObjectDB? Any recommendations or known pitfalls when it comes to ...   ... of EntityManager , queries with HQL syntax instead of JPQL, etc.) you will have to move to standard JPA code. But if your ...

 
forum_thread

String Contains Query Result - Possible?

Hi, I have a managed database for an Entity, "Program", filled with String fields, "description", that are effectively unique sub-strings of a system generated description. Example: System: For Series Sales usage: 6014-Private Individual Swim Lessons  10-Pack Database: 6014-Private Individual Swim Lessons  10-Pack I would like to know if it is possible to have a query return the "Program" object using the System Description? I've considered doing something similar to... ... 12:55 You can use JPQL Locate : SELECT FROM Program WHERE LOCATE ( ...

 
forum_thread

Multi selection and distinct in a criteria query

hi, How can I realize multi selection with the criteria api concerning distinct? I.e. doing something like SELECT DISTINCT $1, $2 wouldn't work because I do only have something like criteria.multiselect(...) and nothing like builder.distinct(selection) so that I could do something like criteria.multiselect(builder.distinct($1), $2)... ?? Alex ... I am afraid it is not supported neither in JPQL nor in criteria queries. But does it make sense? Results ...

 
api-jpa

Criteria Query Selection and Results

Reference (JavaDoc) of JPA query criteria result interfaces, including Selection, CompoundSelection, Order and Tuple.... package, since they might be useful also in string based JPQL queries. Using tuples with non criteria queries is supported by ObjectDB ...