ObjectDB Database Search

Jakarta Persistence (JPA) Interface in jakarta.persistence. criteria .CriteriaBuilder jakarta.persistence. criteria .CriteriaBuilder.SimpleCase Super Interfaces: Expression , Selection , TupleElement ... which they are specified. Since: Jakarta Persistence (JPA) 1 .0 Public Instance Methods Selection alias

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Path Type Parameters: - the type ... . Since: Jakarta Persistence (JPA) 2.0 The Paths and Types in JPQL and Criteria API article explains ... (JPA) 1 .0 Expression as ( Class type ) Perform a typecast upon the expression, returning a new

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .CriteriaDelete Type Parameters ... The CriteriaDelete interface defines functionality for performing bulk delete operations using the Criteria API Criteria API bulk delete operations map directly to database delete operations. The persistence

Jakarta Persistence (JPA) Interface in jakarta.persistence. criteria .CriteriaBuilder jakarta.persistence. criteria .CriteriaBuilder.Case Super Interfaces: Expression , Selection , TupleElement ... which they are specified. Since: Jakarta Persistence (JPA) 1 .0 Public Instance Methods Selection alias ( String

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Predicate Super Interfaces ... . Since: Jakarta Persistence (JPA) 2.0 The Logical Operators in JPQL and Criteria API article explains ... Persistence (JPA) 1 .0 Expression as ( Class type ) Perform a typecast upon the expression, returning

Jakarta Persistence (JPA) Interface in jakarta.persistence. criteria .CriteriaBuilder jakarta.persistence. criteria .CriteriaBuilder.Coalesce Super Interfaces: Expression , Selection , TupleElement ... otherwise. Since: Jakarta Persistence (JPA) 1 .0 Public Instance Methods Selection alias ( String

Jakarta Persistence (JPA) Class jakarta.persistence. criteria .LocalDateTimeField java.lang.Object ∟ jakarta.persistence. criteria .LocalDateTimeField Type Parameters: - the resulting type ... The date part of a datetime. Since: Jakarta Persistence (JPA) 1 .0 DAY The calendar day of the month

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Expression Type Parameters ... . Since: Jakarta Persistence (JPA) 2.0 The JPA Query Expressions (JPQL / Criteria ) article explains ... Persistence (JPA) 1 .0 Expression as ( Class type ) Perform a typecast upon the expression, returning a new

Jakarta Persistence (JPA) Enum in jakarta.persistence. criteria .CriteriaBuilder jakarta.persistence. criteria .CriteriaBuilder.Trimspec java.lang.Object ∟ java.lang.Enum ∟ jakarta.persistence. criteria ... to specify how strings are trimmed. Since: Jakarta Persistence (JPA) 1 .0 Enum Constants BOTH Trim from

Jakarta Persistence (JPA) Class jakarta.persistence. criteria .LocalDateField java.lang.Object ∟ jakarta.persistence. criteria .LocalDateField Type Parameters: - the resulting type of the extracted ... day of the month, numbered from 1 . Since: Jakarta Persistence (JPA) 1 .0 MONTH The calendar month

Jakarta Persistence (JPA) Enum in jakarta.persistence. criteria .Predicate jakarta.persistence. criteria .Predicate.BooleanOperator java.lang.Object ∟ java.lang.Enum ∟ jakarta.persistence. criteria ... Persistence (JPA) 1 .0 Enum Constants AND Since: Jakarta Persistence (JPA) 1 .0 OR Since: Jakarta

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .AbstractQuery Type Parameters ... Persistence (JPA) 1 .0 Root from ( Class entityClass ) Create and add a query root corresponding ... class Returns: query root corresponding to the given entity. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Selection Type Parameters ... / Criteria API) article explains how to use Selection . Public Instance Methods Selection alias ... . Since: Jakarta Persistence (JPA) 1 .0 String getAlias () Return the alias assigned to the tuple element or

Jakarta Persistence (JPA) Class jakarta.persistence. criteria .LocalTimeField java.lang.Object ∟ jakarta.persistence. criteria .LocalTimeField Type Parameters: - the resulting type of the extracted ... of the day in 24-hour time, numbered from 0 to 23. Since: Jakarta Persistence (JPA) 1 .0 MINUTE The minute

Jakarta Persistence (JPA) Enum jakarta.persistence. criteria .Nulls java.lang.Object ∟ java.lang.Enum ∟ jakarta.persistence. criteria .Nulls Implemented Interfaces: Constable , Comparable , Serializable ... ) 1 .0 LAST Null values occur at the end of the result set. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Order An object that defines ... / Criteria API) article explains how to use Order . Public Instance Methods Expression getExpression ... . Since: Jakarta Persistence (JPA) 1 .0 Nulls getNullPrecedence () Return the precedence of null values. Returns

Jakarta Persistence (JPA) Enum jakarta.persistence. criteria .JoinType java.lang.Object ∟ java.lang.Enum ∟ jakarta.persistence. criteria .JoinType Implemented Interfaces: Constable , Comparable ... (JPA) 1 .0 LEFT Left outer join. Since: Jakarta Persistence (JPA) 1 .0 RIGHT Right outer join

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .Fetch Type Parameters ... : the resulting fetch join. Since: Jakarta Persistence (JPA) 1 .0 Fetch fetch ( SingularAttribute ... Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1 .0 Fetch fetch ( PluralAttribute

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .FetchParent Type Parameters ... Persistence (JPA) 1 .0 Fetch fetch ( SingularAttribute attribute , JoinType jt ) Create a fetch join ... attribute - target of the join Returns: the resulting fetch join. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Interface jakarta.persistence. criteria .CompoundSelection Type Parameters ... . Since: Jakarta Persistence (JPA) 1 .0 String getAlias () Return the alias assigned to the tuple element or null ... Persistence (JPA) 1 .0 List getCompoundSelectionItems () Return the selection items composing a compound

does not provide an API to define parameters explicitly (except when using the Criteria API). Instead ... = ? 1 ", Country.class); return query. setParameter ( 1 , name). getSingleResult (); } The format ... over ordinal parameters. Criteria Query Parameters In a JPA query built using the JPA Criteria API

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaQuery CriteriaQuery ... of the query execution depends on the specification of the type of the criteria query object ... : If the type of the criteria query is CriteriaQuery (i.e., a criteria query object created by

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaQuery CriteriaQuery ... of the query execution depends on the specification of the type of the criteria query object created as ... follows: If the type of the criteria query is CriteriaQuery (i.e., a criteria query object created

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaQuery createQuery() Create a CriteriaQuery object. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaQuery createQuery (    Class resultClass ) Create a CriteriaQuery object with the given result type. Parameters: resultClass - type of the query result Returns: criteria query object. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder CriteriaQuery createTupleQuery() Create a CriteriaQuery object that returns a tuple of objects as its result. Returns: criteria query object. Since: Jakarta Persistence (JPA) 1 .0

HAVING COUNT(c) 1 can be built using the criteria query API as follows: CriteriaQuery q = cb ... SUBSTRING(c.name, 1 , 1 ) FROM Country c GROUP BY SUBSTRING(c.name, 1 , 1 ); The FROM clause iterates ... : SELECT DISTINCT SUBSTRING(c.name, 1 , 1 ) FROM Country c GROUP BY with aggregate functions JPQL supports

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression sign (    Expression x ) Create an expression that returns the sign of its argument, that is, 1 if its argument is positive, - 1 if its argument is negative, or 0 if its argument is exactly zero

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression ... . First position is 1 . Parameters: x - string expression from - start position expression Returns: expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression ... position is 1 . Parameters: x - string expression from - start position Returns: expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression ... at the specified position. First position is 1 . Parameters: x - string expression from - start position expression len - length expression Returns: expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression ... . First position is 1 . Parameters: x - string expression from - start position len - length Returns: expression corresponding to substring extraction. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateField MONTH The calendar month of the year, numbered from 1 . Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateField DAY The calendar day of the month, numbered from 1 . Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateField QUARTER The calendar quarter, numbered from 1 to 4. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateTimeField QUARTER The calendar quarter, numbered from 1 to 4. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateTimeField MONTH The calendar month of the year, numbered from 1 . Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Field in jakarta.persistence. criteria .LocalDateTimeField DAY The calendar day of the month, numbered from 1 . Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression locate ... if found. The first position in a string is denoted by 1 . If the string to be located is not found, 0 ... to be located from - position at which to start search Returns: expression corresponding to position. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression locate ... position in a string is denoted by 1 . If the string to be located is not found, 0 is returned. Warning ... Returns: expression corresponding to position. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression locate ... in a string is denoted by 1 . If the string to be located is not found, 0 is returned. Warning ... corresponding to position. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression locate ... character if found. The first position in a string is denoted by 1 . If the string to be located is not ... Returns: expression corresponding to position. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder SetJoin treat (    SetJoin join ,    Class type ) Downcast SetJoin object to the specified type. Parameters: join - SetJoin object type - type to be downcast to Returns: SetJoin object of the specified type. Since: Jakarta Persistence (JPA) 2. 1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Expression nullif (    Expression x ,    Y y ) Create an expression that tests ... . Parameters: x - expression y - value Returns: nullif expression. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Coalesce coalesce() Create a coalesce expression. Returns: coalesce expression. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder SimpleCase selectCase (    Expression expression ) Create a simple case expression. Parameters: expression - to be tested against the case conditions Returns: simple case expression. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Case selectCase() Create a general case expression. Returns: general case expression. Since: Jakarta Persistence (JPA) 1 .0

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder ListJoin treat (    ListJoin join ,    Class type ) Downcast ListJoin object to the specified type. Parameters: join - ListJoin object type - type to be downcast to Returns: ListJoin object of the specified type. Since: Jakarta Persistence (JPA) 2. 1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder MapJoin treat (    MapJoin join ,    Class type ) Downcast MapJoin object to the specified type. Parameters: join - MapJoin object type - type to be downcast to Returns: MapJoin object of the specified type. Since: Jakarta Persistence (JPA) 2. 1

Jakarta Persistence (JPA) Method in jakarta.persistence. criteria .CriteriaBuilder Path treat (    Path path ,    Class type ) Downcast Path object to the specified type. Parameters: path - path type - type to be downcast to Returns: Path object of the specified type. Since: Jakarta Persistence (JPA) 2. 1