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


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 "," allows connecting from any IP address in the range of to , as well as from . ...


Possible issue with String fields

Hi I'm brand new to objectdb and I'm trying to create an objectdb from a sample db via jdbc. The code all works and for a few thousand records but when I increase the number of records I get the following " ... to commit transaction: String index out of range: 5 (error 613) at com.objectdb.jpa.EMImpl.commit(EMImpl.java:279) at ... String index out of range: 5 at java.lang.String.charAt(String.java:695) at ...