About between

manual

Comparison in JPQL and Criteria API

Explains how comparison operators can be used in JPQL queries, including in comparing null values.... Comparable Data Types [NOT] BETWEEN Criteria Query Comparison ... but not to a String instance. [NOT] BETWEEN The BETWEEN operator is a convenient shortcut that can replace ...

 
api-jpa

between(v, x, y)

Create a predicate for testing whether the first argument is between the second and third arguments in value.(Method of javax.persistence.criteria.CriteriaBuilder)

 
api-jpa

between(v, x, y)

Create a predicate for testing whether the first argument is between the second and third arguments in value.(Method of javax.persistence.criteria.CriteriaBuilder)

 
forum_thread

100% CPU when using multiple BETWEEN

Hi, we are evaluating ObjectDB 2.5.1_03 in embedded mode. We have a DB of about 2800 instances of a class that has two java.lang.String members: toExtension and fromExtension. There are other members in the class, but not relevant to the problem.   A query like this cause the java process to start running at 100% CPU (endless loop) and it never recovers: ... r WHERE ( ( ( r . toExtension BETWEEN '2010' AND '2099' ) OR ( r . toExtension BETWEEN '2001' AND '2002' ) ) OR ...

 
api-jpa

between(v, x, y)

Create a predicate for testing whether the first argument is between the second and third arguments in value.(Method of javax.persistence.criteria.CriteriaBuilder)

 
api-jpa

javax.persistence.criteria.CriteriaBuilder

Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)

 
api-jpa

javax.persistence.PersistenceUnitUtil

Utility interface between the application and the persistence provider managing the persistence unit.(Interface of JPA)

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... =, <>, <, <=,>, >=, IS [NOT] NULL, [NOT] BETWEEN, including  Collection operators: [NOT] IN, IS [NOT] ... Create an expression that returns the difference between its arguments. See JavaDoc Reference Page... , prod ...

 
forum_thread

JRebel integration feature

Feature request: Dynamic class enhancement during development compatible with JRebel.... I invite further expressions of support for compatibility between ObjectDB and JRebel. Webel [EDIT: I have not investigated compatibility between JRebel and other ObjectDB enhancement techniques, just javaagent, ...

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... Create an expression that returns the difference between its arguments. See JavaDoc Reference Page... , prod ... the second. See JavaDoc Reference Page... , between between(v, x, y) CriteriaBuilder's method Create a ...