About jpql

release

2.1.0

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

 
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 ...

 
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

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

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 ( ...

 
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 ...

 
page

Consulting and Training

... and goes to exploring design alternatives, advanced JPQL, using ObjectDB with JEE (EJB) and with Spring, and ObjectDB production ...

 
issue

[Explorer] Editing Database Files

Some features of ObjectDB 1 Explorer have not been implemented yet in the new Explorer of ObjectDB 2. The new Explorer of ObjectDB 2 is currently a viewer rather than editor, and database files are always opened in read only mode. The ability to create new database objects and edit existing database object has to be reimplemented in the ObjectDB 2.... for the explorer: Allow the user to run an ad-hoc JPQL query, and then browse/edit the results. This would be incredibly useful. ...

 
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 ...