Internal Website Search
1-50 of 200 resultsJPA 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 |