ObjectDB ObjectDB

Internal Website Search

1-10 of 52 resultsRefresh

FROM clause (JPQL / Criteria API)

a program, since both are used for iteration over objects. Range Variables Range variables are query ... name annotation element. Multiple range variables are allowed. For example, the following query ... . Caution is required when using multiple range variables. Iteration over about 1,000,000 database objects

Index Definition

query execution. Indexes are especially efficient in lookup and range queries: SELECT p FROM ... a range scan, which is very efficient because only branches of the BTree that are relevant are iterated ... is specified first, the BTree is ordered by x values, so a range scan on x values is supported

JPA Query Structure (JPQL / Criteria)

a range variable. Range variables define iteration over all the database objects of a binding entity class and its descendant classes. In the query above, c is a range variable that is bound ... the iteration of the c range variable, which in this case is actually all the Country objects in the database


/ 10 The UPDATE clause defines exactly one range variable (with or without an explicit variable ... more field update expressions (using the range variable name - if defined). Multiple field update

ObjectDB Object Database Features

can manage databases of various sizes efficiently, ranging from kilobytes to terabytes. Platform ... executions. Result range settings (first, max) - for paging. Query Structure SELECT (including NEW

JPA Criteria API Queries

the built query. Then a Root instance is created to define a range variable in the FROM clause. Finally, the range variable, c, is also used in the SELECT clause as the query result expression

Server User List

in a 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

Setting and Tuning of JPA Queries

The Query and TypedQuery interfaces define various setting and tuning methods that may affect query execution if invoked before a query is run using getResultList or getSingleResult. Result Range (setFirstResult, setMaxResults) The setFirstResult and setMaxResults methods enable defining a result

[ODB1] Chapter 8 - ObjectDB Server

in a comma separated list and using a hyphen (-) to indicate a range. For example, a value "," allows connections from any IP address in the range of


, import statements, ordering and grouping specifications, result and result class, the range ... extent, result class, and range limits are not used. The String parameters are trimmed of white ... the range, result class, and ignoreCache option. The unmodifiable flag, when set, disallows

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support