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

 
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

Native ObjectDB Support for EnumSet ?

Greetings ObjectDB team, Are embedded EnumSet objects faster to query than normal classes ? Does JPA/JDO offer native support to filter persistent objects by an EnumSet field's multi values ? For example: WHERE o.es == ES.A | ES.B | ES.C Thank you !... . enumSet . contains ( :arg ) JPA/JPQL  query for example: SELECT e FROM MyEntity e JOIN ...

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

 
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

com.objectdb.o.NLV cannot be cast to com.objectdb.o.CMV

We are using ObjectDB 2.5.1_04. The following JPQL query causes an internal exception: SELECT COUNT(r) FROM RecordingMetaData AS r WHERE ((r.mapFromCli LIKE '192.168.10.13%' ESCAPE '\')) The exception: ... We are using ObjectDB 2.5.1_04. The following JPQL query causes an internal exception: SELECT COUNT ( r ...

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