About range


Setting and Tuning of JPA Queries

Explains various JPA query settings - result range, flush and lock.... page covers the following topics: Result Range (setFirstResult, setMaxResults) Flush Mode (setFlushMode) ... Query Hints Result Range (setFirstResult, setMaxResults) The setFirstResult ...


FROM clause (JPQL / Criteria API)

Explains how to use the FROM clause and JOIN expressions in a JPA/JPQL query.... This page covers the following topics: Range Variables [INNER] JOIN LEFT [OUTER] JOIN ... FROM and JOIN in Criteria Queries Range Variables Range variables are query identification variables that ...


LIMIT or TOP functions

Is there LIMIT or TOP functions in object db? If so can you provide some examples? ... You can set query result range by using the setFirstResult setFirstResult(startPosition) ...


Criteria Query From Elements

Reference (JavaDoc) of JPA query criteria FROM clause interfaces, including From, Root, Join and Fetch.... javax.persistence.criteria.From Range variables (bound by an entity class) are represented by the Root ...



The Query interface allows applications to obtain persistent instances, values, and aggregate data from the data store.(Interface of JDO)


ObjectDB Object Database Features

ObjectDB provides a rich set of features, many of them as the result of supporting the JPA and JDO APIs.... executions. Result range settings (first, max) - for paging. ...


Index Definition

Describes how to define indexes in JPA entity classes and explains how indexes are used in JPQL queries.... Indexes are especially efficient in lookup and range queries: SELECT p FROM Point p WHERE p . x = ... on field x , ObjectDB can find the results using a range scan, which is very efficient because only branches of the BTree that are ...


JPA Query Structure (JPQL / Criteria)

Explains the structure of a JPQL query, which consists of 6 clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.... that is bound to an entity class is referred to as a range variable. Range variables define iteration over all the database objects of a binding ...



Set the range of results to return.(Method of javax.jdo.Query)


setRange(fromIncl, toExcl)

Set the range of results to return.(Method of javax.jdo.Query)