About JPQL

release

2.0.5

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

 
forum_thread

dual access

Hello Exploring the product having had significant experience win Kodo/BEA/JDO1.x, yes I know dated but still works.  Is it possible to still have the SQL emitted from only the JAVA syntax?  If so is it also possible get each SQL statement before it is sent to the store?  Does objectdb only permit direct SQL coding? ... ObjectDB doesn't support SQL but JDOQL and JPQL (the later is very similar to SQL). Queries can be logged before ...

 
manual

JPA Named Queries

Explains how to define and how to run JPA named queries.... may improve code organization by separating the JPQL query strings from the Java code. It also enforces the use of query  ...

 
forum_thread

Spatial queries with ObjectDB

Hello ! Can some-one explain me if it's possible to fill ObjectDB with objects containing Geometric-properties and howto execute spatial queries on them? Or: maybe there's an extension I've missed (like HibernateSpatial for Hibernate) ? Thanks!   ... in queries to provide your own spatial extension to JPQL. Obviously this is not a complete solution but it could be considered for ...

 
faq

What are the main benefits of using ObjectDB?

... accelerates applications. For instance, ObjectDB processes JPQL (JPA Query Language) and JDOQL (JDO Query Language) queries directly, ...

 
forum_thread

CriteriaQuery .where() for multiple conditions

When using the below, there appears to be an OR condition:   ... fine. You may also check the result query string (JPQL) by toString() on the criteria query. ...

 
issue

Different behavior for casting and not casting

Hi, Please use attached db for testing the queries. Query #1 which works and selects a few entities: SELECT DISTINCT $1 FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE $1.qubletFRAGMENTMAP.get('com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedVertraegeFragment') IS NOT NULL Query #2 which is equal to the previous one though includes a casting and returns NO entities: ... in casting was broken. Since casting in not part of JPQL and rarely used I am afraid it might not be the last problem that you ...

 
forum_thread

Question about overriding default equals and hashcode

Hello Support, I have overrided equals and hashcode method in my entities beans. I don't know if you use these methods in your objectdb implementation. ( for comparing bean ? ) If yes, does it have an impact on performance of database ? Regards, Xirt   ... user defined methods in queries as an extension to JPQL and JDOQL), when comparing collections in queries, etc. ...

 
forum_thread

Entity with java.util.Date column gives ClassCastException in BIRT

Copied a straightforward entity class from my coleague. Using Eclipse Kepler (Reporting) and stored it in ObjectDB 2.5.3_02. After creating an ObjectDB BIRT DataSource and a DataSet, entered a simple JPQL query to select the fields. Entity looks like this: ... ObjectDB BIRT DataSource and a DataSet, entered a simple JPQL query to select the fields. Entity looks like this: package ...

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