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



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


Date and Time in JPQL and Criteria Queries

Shows how date and time can be used in JPQL queries.... date and time parts are also available in criteria queries by using the generic CriteriaBuilder ...


composite index not used in query

we defined a composite index for class Action: @Index(name="ssst",members={"startDate","state","subType","type"}) and an index for the OneToMany @OneToMany(fetch=FetchType.LAZY) @Index  public List<ObjectNode> objectsInCharge = new ArrayList<ObjectNode>(); on running a query like ... Avoid overflow of published source code examples by breaking long lines . You may mark in paragraph code words ... names) with the code style (can be applied by ctrl + D). Long stack traces (> 50 lines) and complex ...



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



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


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



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


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



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