ObjectDB ObjectDB

Internal Website Search

11-20 of 200 resultsRefresh
166

Criteria Query Selection and Results

The JPA Criteria API interfaces in this group are used for setting the SELECT and ORDER BY clauses ... clause in a criteria query is represented by Selection: Because Selection is a super interface of Expression, any criteria expression can be used as the SELECT clause content. Multiple selection
163

Chapter 4 - JPA Queries (JPQL / Criteria)

well as how to use the JPA Criteria API, which provides an alternative way for building queries in JPA, based on JPQL. The first section describes the API that JPA provides for using dynamic and static ... (and a criteria query) is explained by describing the main clauses of JPQL queries (SELECT, FROM, WHERE, GROUP
157

JPA Query Expressions (JPQL / Criteria)

Query expressions are the foundations on which JPQL and criteria queries are built. Every query ... of JPQL / Criteria query expressions. Atomic Expressions The atomic query expressions are: JPQL / Criteria Variables JPQL / Criteria Parameters JPQL / Criteria Literals Every query expression consists
156

JPA Query Structure (JPQL / Criteria)

on how to set criteria query clauses are provided as follows: Criteria SELECT (select, distinct, multiselect, array, tuple, construct). Criteria FROM (from, join, fetch). Criteria WHERE (where). Criteria GROUP BY / HAVING (groupBy, having, count, sum, avg, min, max, ...). Criteria ORDER BY (orderBy, Order, asc, desc).
156

Criteria Query From Elements

The interfaces in this group are in use for setting a criteria query FROM clause. Criteria Query ... are represented in criteria queries by descendant interfaces of the From interface: Range variables ... and its descendant interfaces: See the FROM in Criteria Queries section for more details and examples. Join
152

Strings in JPQL and Criteria Queries

operator). Criteria Query String Expressions JPQL string operators and functions (which are described above) are available also as JPA criteria query expressions. The CriteriaBuilder interface provides ... and when applicable simple Java objects as well as criteria expressions.
152

Numbers in JPQL and Criteria Queries

of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described above) are available also as JPA criteria query ... two operands. At least one operand must be a criteria numeric expression. The other operand
150

Date and Time in JPQL and Criteria Queries

in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date ... when the query is run. Functions for extracting date and time parts are also available in criteria queries
150

Collections in JPQL and Criteria Queries

of collection, so in ObjectDB these operators are treated as synonyms. Criteria Query Collection ... criteria query expressions. The CriteriaBuilder interface provides factory methods for building
147

Criteria Query Expressions

The following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples.

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