Internal Website Search

1-10 of 200 resultsRefresh

Query Parameters in JPA

. Named parameters can be easily identified in a query string by their special form ... parameters are defined implicitly by appearing in the query string. The parameter type is inferred by the context. In the above example, a comparison of :name to a field whose type is

Literals in JPQL and Criteria Queries

Literals in JPQL, as in Java, represent constant values. JPQL supports various types ... once and then run many times with different parameter values. Literals should only be embedded in ... >null value, similarly to null in Java and SQL. Since JPQL is case insensitive

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as path expressions - in navigation to persistent collection fields ... (collection) function returns the number of elements in a specified collection. For example:

Paths and Types in JPQL and Criteria API

and embeddable classes) are represented in JPQL by the following types of expressions: in direct comparison using the = and <> operators. But more often they are used in JPQL path expressions that navigate to values of simple types (number, boolean

Locking in JPA

to the same data by two concurrent users. Locking in ObjectDB (and in JPA) is always at the database ... > In the rare cases in which update collision must be revealed earlier (before transaction ... number for every entity object. The initial version of a new entity object (when it is stored in

Comparison in JPQL and Criteria API

Most JPQL queries use at least one comparison operator in their WHERE clause. in the following table: in the Equal and the Not Equal operators. JPQL follows the SQL notation, where Java uses

Strings in JPQL and Criteria Queries

String values may appear in JPQL queries in various forms: as  ... - in navigation to persistent string fields. as results of predefined JPQL string ... >is evaluated to FALSE. In the expressions above only the first percent

Logical Operators in JPQL and Criteria API

Logical operators in JPQL and in JPA criteria queries enable composition of complex ... > Logical Operators ObjectDB supports 2 sets of logical operators, as shown in ... its own notation (which is also in use by JDOQL, the JDO Query Language). ObjectDB supports both forms.

Numbers in JPQL and Criteria Queries

Numeric values may appear in JPQL queries in many forms: as  ... #navigation_through_path_expressions">path expressions - in navigation to persistent ~ (bitwise complement) operators that are supported in Java and JDO. JPA

UPDATE SET Queries in JPA/JPQL

Existing entity objects can be updated, as explained in in the database. Updating entity objects in the database using an UPDATE query may be slightly more efficient than retrieving entity