About arithmetic

manual

Numbers in JPQL and Criteria Queries

Shows how numbers, arithmetic expressions and numeric functions and operators (MOD, ABS) can be used in JPQL queries.... numeric, e.g. LOCATE, LENGTH. as composite arithmetic expressions that use operators and functions to combine simple ... This page covers the following topics: Arithmetic Operators The ABS Function The MOD ...

 
manual

JPA Query Expressions (JPQL / Criteria)

Describes JPA query (JPQL / Criteria API) expressions (literals, operators and functions).... Navigation operator (.) Arithmetic operators : * (multiplication), / (division), + ... See JavaDoc Reference Page... ). Arithmetic expressions ( sum sum(x, y) CriteriaBuilder's ...

 
api-jpa

neg(x)

Create an expression that returns the arithmetic negation of its argument.(Method of javax.persistence.criteria.CriteriaBuilder)

 
manual

JPA Criteria API Queries

Explains how to use the JPA Criteria API (CriteriaBuilder, CriteriaQuery, etc.) to build JPQL like queries.... See JavaDoc Reference Page... ). Arithmetic expressions ( sum sum(x, y) CriteriaBuilder's ... method Create an expression that returns the arithmetic negation of its argument. See JavaDoc Reference Page... , ...

 
api-jpa

javax.persistence.criteria.CriteriaBuilder

Used to construct criteria queries, compound selections, expressions, predicates, orderings.(Interface of JPA)

 
issue

[ObjectDB 2.5.5_03] Unexpected exception (Error 990)

Hello! When I run this query SELECT t FROM Unit t WHERE t.lastGeocodedPosition IS NULL OR t.lastGeocodedPosition.receiveTime < :lastGeocodedPosition.receiveTime I get the following exception: ... my query: Page 168 states: • Comparison or arithmetic operations with a NULL value always yield an unknown value. ... a null expression is very different from comparison and arithmetic operations. I think that according to the JPA specification, ...

 
manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query.... expression syntax , which includes many operators (arithmetic operators, relational operators, logical operators) and functions ...

 
page

ObjectDB Object Database Features

ObjectDB provides a rich set of features, many of them as the result of supporting the JPA and JDO APIs.... &&, ||). Arithmetic operators & functions (+, -, *, /, %, ABS, SQRT, MOD). ...

 
manual

[ODB1] Chapter 7 - JDOQL Queries

Explains how to use JDOQL, the Java/JDO Query Language.... function in JDOQL exactly as they do in Java. Arithmetic Operators In JDOQL, arithmetic operators ( + , - , * , / ) can be applied to numeric ...