About ORDER BY

api-jpa

javax.persistence.EntityNotFoundException

Thrown by the persistence provider when an entity reference obtained by EntityManager.getReference is accessed but the entity does not exist.(Exception of JPA)

 
release

2.6.9

... Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a bug in ... bugs. Fixed a performance issue with mapped by fetch. Fixed the ObjectDB Maven repository and Maven examples ...

 
api-jpa

JPA Queries

Reference (JavaDoc) of all the JPA query types, including Query, TypedQuery, CriteriaBuilder, CriteriaQuery, Tuple, Root, Expression, Order, etc. Queries are represented in JPA by the Query and TypedQuery interfaces: ... at runtime (e.g. depending on which fields are filled by a user in a form) can be done by concatenating JPQL strings into a valid complete JPQL query. JPA 2 ...

 
release

2.7.0

... include META-INF/MANIFEST.MF as the first entry (required by Apache Karaf ). Fixed a cache bug in repeating ... page sizes larger than 64KB (which are not supported by ObjectDB). Fixed an issue of very slow online backup. ...

 
forum_thread

JPQL IN Operator

How can I use the standard JPQL IN operator with ObjectDB? This JPQL query works fine with EclipseLink / postgres but throws an exception in objectDB: select distinct dv.creationtime from DataValue dv where dv.capabilityId.capabilityId ==> in <== :capabilities and dv.creationtime >= :earliest and dv.creationtime <= :latest order by dv.creationtime ASC [ObjectDB 2.2.9] javax.persistence.PersistenceException Unexpected query token 'in' (error 752) ... AND dv . creationtime <= :latest ORDER BY dv . creationtime ASC [ObjectDB ... dv.creationtime <= :latest " + " order by dv.creationtime DESC" ) , this seems to work in ... would you class that as an EclipseLink bug? Caused by: Exception [EclipseLink-8025] (Eclipse Persistence Services - ...

 
api-jpa

javax.persistence.TransactionRequiredException

Thrown by the persistence provider when a transaction is required but is not active.(Exception of JPA)

 
release

2.6.8

... Fixed a bug in ordering query result by an expression that is used in IN operator. Fixed a bug in ... bugs. Fixed a performance issue with mapped by fetch. Fixed the ObjectDB Maven repository and Maven examples ...

 
api-jdo

javax.jdo.spi.JDOImplHelper

This class is a helper class for JDO implementations.(Class of JDO)

 
forum_thread

Sorting problem

Hi, I was rewriting our DAO to support pagging in large dataset and I think I have found a problem with sorting. I send you a test case - sorry for using the same project as previous, but it was faster to write this test case. As usual, you can load data with DataLoader and then check problem with QueryData. There is a simple query with "order by" sentence: ... QueryData. There is a simple query with "order by" sentence: List<Branch> prodList = null ; ... null ; q = "select br from Branch br ORDER BY ?1 DESC" ; icQuery = em. createQuery ( q, Branch. ...

 
forum_thread

Issue with alias

Hi, This query works and correctly casts and selects my entity into the tuplet: SELECT $1, ((com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment)$1.qubletFRAGMENTMAP.get('com.lexware.vereinsverwaltung.abrechnung.api.model.mitglied.MitgliedDebitorenKontoFragment')) AS DEB FROM com.lexware.vereinsverwaltung.verein.mitglied.Mitglied $1 WHERE DEB.debitor=true however, trying to access "DEB" in the where clause causes an "unexpected token" error? Alex ... A result alias can only be used in the ORDER BY clause of the query (and after query execution in managing result elements ...     FROM -> WHERE -> GROUP BY -> HAVING -> SELECT -> ORDER BY and you cannot use an ...