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 ...
javax.jdo.Query
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 ...
Server User List
Explains how to define and set users, directories and permissions in the ObjectDB fast Java database server for JPA/JDO.... comma separated list and using a hyphen (-) to indicate a range. For example, a value "192.18.0.0-192.18.194.255,127.0.0.1" allows connecting from any IP address in the range of 192.18.0.0 to 192.18.194.255 , as well as from 127.0.0.1 . ...
