Internal Website Search

Logical operators in JPQL and in JPA criteria queries enable composition of complex JPQL boolean expressions out of simple JPQL boolean expressions. Logical Operators ObjectDB supports 2 sets of logical operators, as shown in the following table:

/query/jpql/string">[NOT] LIKE operator. logical">Logical ... ="/java/jpa/query/jpql/logical#criteria_query_logical_operators">Logical expressions (

the ordinary Java logic, in which, for example, null == null is true. All the other operators implement the SQL logic in which NULL represents an unknown value ... in queries follow the logic of Java's equals, comparing the content

(arithmetic operators, relational operators, logical operators) and functions (numeric functions ... >See the logical#criteria_query_logical_operators">Logical Operators

The following code doesn't respect the logical "or" correctly. Instead of returns all 2 datasets it returns only this one, which matches the first predicate in the or. BUT: this happens only, if the field for the "or" is the first one defined as @Id. public class OrTest

>isNull, ...) logical#criteria_query_logical_operators">Logical expressions (

(<, <=, >=, <>, =, !=, ==, BETWEEN, IS NULL). logical">Logical operators (AND, OR, NOT, &&, ||).

A JPA Persistence Unit is a logical grouping of user defined persistable classes (entity classes, embeddable classes and mapped superclasses) with related settings. Defining a persistence unit is optional when using ObjectDB, but required by JPA. persistence.xml

>, double). Logical Operators Logical operators (&&

>This method is modified by the enhancer so that fields referenced can be used in the business logic