Internal Website Search

1-50 of 200 results

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

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.

Strings in JPQL and Criteria Queries

' , ''. as parameters - when string values are assigned as arguments. as  path expressions - in ... is always the string to check for a match (usually a path expression ) and the right operand is always the pattern ... ;is evaluated to TRUE . '100' LIKE '%\%' ESCAPE '\' is evaluated to FALSE . In the expressions

How to use regular expressions in Criteria Builder

does not support regular expressions in queries, so currently you cannot use regular expressions in ... so you can use regular expressions in queries, just use string-based JPQL ("e.g. e.field.matches(regexp)") instead of criteria queries. support Support ... I'm struggling to understand how to use the matches method on the String class when using regular

FROM clause (JPQL / Criteria API)

.capital The JOIN FETCH expression is not a regular JOIN and it does not define a JOIN variable ... at the WHERE clause level by using a type expression . For example, in the following query, c iterates ... variable that serves as a root and additional join variables that are bound to path expressions

Numbers in JPQL and Criteria Queries

, -12.5 . as parameters - when numeric values are assigned as arguments. as  path expressions - in navigation to persistent numeric fields. as aggregate expressions - e.g. COUNT. as collection ... value is numeric, e.g. LOCATE, LENGTH. as composite arithmetic expressions that use operators

Paths and Types in JPQL and Criteria API

classes) are represented in JPQL by the following types of  expressions : Variables - FROM ... are assigned as arguments. Path expressions that navigate from one object to another. Instances of user ... . But more often they are used in JPQL path expressions that navigate to values of simple types (number, boolean

ORDER BY clause (JPQL / Criteria API)

Expressions The following query returns names of countries whose population size ... . Then the SELECT clause builds the results by evaluating the result expressions . Finally the results are ordered by evaluation of the ORDER BY expressions . Only expressions that are derived directly from

SELECT clause (JPQL / Criteria API)

the ability to use almost any valid JPQL expression in SELECT clauses. Specifying the required query ... the "SELECT *" expression (which is commonly used in SQL). Projection of Path Expressions JPQL ... path expressions , such as c.name , in query results is referred to as projection. The field values

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ...   path expressions - in navigation to persistent date and time fields. as results of predefined JPQL current date and time functions. Current Date and Time JPA defines special JPQL expressions

Literals in JPQL and Criteria Queries

expressions . Ordinary Literals The main method, literal , takes a Java object and returns a literal expression . For example: // Boolean literals: Expression t = cb. literal (true); Expression f = cb. literal (Boolean.FALSE); // Numeric literals: Expression i1 = cb. literal (1); Expression i2 = cb

GROUP BY and HAVING clauses

which returns the first letters as result. ObjectDB is very flexible in allowing JPQL expressions anywhere in ... . Only identification variables and path expressions are currently supported in the GROUP BY clause by all the JPA ... that are in use by countries in that group. The DISTINCT keyword in a COUNT aggregate expression , as

JPA Criteria API Queries

expression . A  CriteriaQuery instance is equivalent to a JPQL string and not to a TypedQuery instance ... criteria query clauses and build criteria expressions . Running this query requires setting the parameter ... the context of string based JPQL queries. Criteria Query Expressions JPA query clauses are composed

Logical Operators in JPQL and Criteria API

expressions out of simple JPQL boolean expressions . Logical Operators ObjectDB supports 2 sets ... part of its JDO support. Criteria Query Logical Operators Boolean Expressions and Predicates Boolean expressions are represented in criteria queries by Expression and descendant interfaces. For example

javax.persistence.criteria.Expression

JPA Interface Expression Type Parameters: - the type of the expression Super Interfaces: Selection , TupleElement Type for query expressions . Since: JPA 2.0 The JPA Query Expressions (JPQL / Criteria) article explains how to use Expression . Public Methods Expression as (Class  type) Perform

Collections in JPQL and Criteria Queries

. as  path expressions - in navigation to persistent collection fields. IS [NOT] EMPTY ... are treated as synonyms. Criteria Query Collection Expressions JPQL collection operators and functions (which are described above) are available also as JPA criteria query expressions

Expression.as(type) - JPA Method

JPA Method in javax.persistence.criteria. Expression Expression as (   Class  type ) Perform a typecast upon the expression , returning a new expression object. This method does not ... . Parameters: type - intended type of the expression Return: new expression of the given type Since: JPA 2.0

JPA Annotations for Value Generation

Automatically generated values are mainly useful for primary key fields, but are supported by ObjectDB also for regular (non primary key) persistent fields. At the field level, the @GeneratedValue with an optional GenerationType strategy is specified: The @GeneratedValue annotation

CriteriaBuilder.selectCase(expression) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder CriteriaBuilder.SimpleCase selectCase (    Expression   expression ) Create a simple case expression . Parameters: expression - to be tested against the case conditions Return: simple case expression Since: JPA 2.0

Expression.in(values) - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate in (    Expression  values ) Create a predicate to test whether the expression is a member of the collection. Parameters: values - expression corresponding to collection to be tested against Return: predicate testing for membership Since: JPA 2.0

Expression.in(values) - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate in (    Expression ... values ) Create a predicate to test whether the expression is a member of the argument list. Parameters: values - expressions to be tested against Return: predicate testing for membership Since: JPA 2.0

CriteriaBuilder.in(expression) - JPA Method

JPA Method in javax.persistence.criteria.CriteriaBuilder CriteriaBuilder.In in (    Expression   expression ) Create predicate to test whether given expression is contained in a list of values. Parameters: expression - to be tested against list of values Return: in predicate Since: JPA 2.0

Subquery.select(expression) - JPA Method

JPA Method in javax.persistence.criteria.Subquery Subquery select (    Expression   expression ) Specify the item that is to be returned as the subquery result. Replaces the previously specified selection, if any. Parameters: expression - expression specifying the item

WHERE clause (JPQL / Criteria API)

to function as a filter. The boolean expression in the WHERE clause, which is also known as the WHERE predicate, defines which objects to accept. Only Country objects for which the predicate expression ... Expressions in WHERE The above queries demonstrate only a small part of the full capabilities

Expression.isNull() - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate isNull () Create a predicate to test whether the expression is null. Return: predicate testing whether the expression is null Since: JPA 2.0

Expression.isNotNull() - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate isNotNull () Create a predicate to test whether the expression is not null. Return: predicate testing whether the expression is not null Since: JPA 2.0

Expression.in(values) - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate in (   Collection  values ) Create a predicate to test whether the expression is a member of the collection. Parameters: values - collection of values to be tested against Return: predicate testing for membership Since: JPA 2.0

Expression.in(values) - JPA Method

JPA Method in javax.persistence.criteria. Expression Predicate in (   Object... values ) Create a predicate to test whether the expression is a member of the argument list. Parameters: values - values to be tested against Return: predicate testing for membership Since: JPA 2.0

Criteria Query Selection and Results

of Expression , any criteria expression  can be used as the SELECT clause content. Multiple selection expressions can be represented by  CompoundSelection , which is itself a subinterface ... interface is a thin wrapper around Expression , which adds order direction - either ascending (ASC) or

javax.persistence.criteria.CriteriaBuilder

JPA Interface CriteriaBuilder Used to construct criteria queries, compound selections, expressions , predicates, orderings. Note that Predicate is used instead of Expression in this API in order ... Criteria API Queries article explains how to use CriteriaBuilder . Public Methods Expression abs

Comparison in JPQL and Criteria API

which NULL represents an unknown value and expressions that include an unknown value are evaluated as ... IS NOT NULL The expressions above are equivalent (respectively) to the following non standard JPQL (but standard Java and JDOQL) expressions : c.president == null c.president != null Comparable Data

ObjectDB Object Database Features

JOIN and JOIN FETCH ). WHERE (with both JPQL and JDOQL expressions ). GROUP BY (including HAVING ... Expressions Path navigation expressions using the dot (.) operator. Comparison operators (

[ODB1] Chapter 7 - JDOQL Queries

(usually a persistent class) A filter, which is a boolean expression in a Java like syntax The query ... can include other optional components, such as parameters, variables and import and order expressions ... represents the iterated object. Only instances for which the evaluation of the filter expression is true

Setting and Tuning of JPA Queries

number ( 0 for the first page), the following expression retrieves the results for a specified page ... (); These methods can be invoked in a single expression with getResultList since the setter methods

Query Parameters in JPA

), so invocation of getSingleResult can be chained to the same expression . Named parameters can be easily ... as is. Instead of a simple country name, a malicious user may provide JPQL expressions that change

Eclipse Public License - v 1.0

disclaims on behalf of all Contributors all warranties and conditions, express and implied, including ... , THE PROGRAM IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, EITHER EXPRESS OR

UPDATE SET Queries in JPA/JPQL

supported. The SET clause defines one or more field update expressions (using the range variable name - if defined). Multiple field update expressions , separated by commas, are also allowed

Apache License, Version 2.0, January 2004

CONDITIONS OF ANY KIND, either express or implied, including, without limitation, any warranties or

ObjectDB License Agreement [ver. 2.0.4]

"AS IS" without a warranty of any kind. All express or implied representations and warranties

JPA Queries

elements (representing range variables, join and fetch): Other criteria query expressions (for all the query clauses):

JPA Class Enhancer

: java com.objectdb.Enhancer -s "*.class" The "*.class" expression above is enclosed in quotes

Eclipse Distribution License - v 1.0

HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED

ObjectDB Website - Terms and Conditions of Use

Software's web site are provided "as is". ObjectDB Software makes no warranties, expressed or implied

Chapter 4 - JPA Queries (JPQL / Criteria)

BY, HAVING, ORDER BY): Then the expressions that are used for building JPQL and criteria query

javax.persistence.criteria.Subquery

: AbstractQuery , CommonAbstractCriteria , Expression , Selection , TupleElement The Subquery interface defines functionality that is specific to subqueries. A subquery has an expression as its selection item. Since: JPA 2.0 Public Methods Expression as (Class  type) Perform a typecast

javax.persistence.criteria.CriteriaBuilder$Coalesce

JPA Interface Coalesce Super Interfaces: Expression , Selection , TupleElement Interface used to build coalesce expressions . A coalesce expression is equivalent to a case expression that returns ... otherwise. Since: JPA 2.0 Public Methods Expression as (Class  type) Perform a typecast upon the expression

[ODB1] Chapter 6 - Persistent Objects

well using complex, sophisticated queries. The results can also be sorted by specified order expressions ... are locked. Therefore, a persistent object obj is locked only when the following expression

[ODB1] Chapter 3 - Persistent Classes

directories using the -s option (the "*.class" expression is in quote marks here to avoid auto resolving

[ODB1] Chapter 5 - JDO Connections

, the call to getClass() should be replaced by some other expression (e.g. MyClass.class ) in a static context (i

javax.jdo.Query

, cast expression , etc.) a type name must be the name of the candidate class, the name of a class or ... of the subquery candidateCollectionExpression - the candidate collection of the subquery as an expression using ... of the expression in the outer query. If the trimmed expression is the empty String