ObjectDB Database Search

? thanks! Alex quasado Alexander Adam You can use a JPQL query with a simple date comparison: SELECT p

I prefer to keep custom JPQL named queries in an external file, e.g. orm.xml, rather than in the entity classes, for example: delete from DataValue d where d.capabilityId = :capabilityId and d.creationtime <= :creationtime This works fine with e.g. eclipseLink and postgres, but objectDB

id WHERE item.sku = :key OR id = :id ORDER BY item.sku DESC You may also try this (not valid JPQL

Hibernate API / extensions (e.g. Session instead of EntityManager , queries with HQL syntax instead of JPQL

). Added support for a JPQL update query with multiple variables (issues #2369 , #3009 ). Fixed