About SELECT

1-10 of 200Refresh
Manual
211

SELECT clause (JPQL / Criteria API)

query = em.createQuery("SELECT c FROM Country c", Country.class); ListSELECT clauses ... - JPQL does not support the "SELECT *" expression (which is commonly used in SQL). Projection of Path
JPA Doc
189

Criteria Query Selection and Results

The JPA Criteria API interfaces in this group are in use for setting the SELECT and ORDER BY clauses and for representing query results as tuples. SELECT Clause Elements The content of the SELECT clause in a criteria query is represented by Selection: Because Selection is a super interface
JPA Doc
77

select(selection)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery select(   Selection selection ... selection(s), if any. Note: Applications using the string-based API may need to specify the type of the select item when it results from a get or join operation and the query result type is specified
JPA Doc
59

javax.persistence.criteria.Selection

javax.persistence.criteria Interface Selection Superinterfaces: TupleElement Subinterfaces ... , MapJoin, ParameterExpression, Path, PluralJoin, Predicate, Root, SetJoin, Subquery The Selection ... Criteria API's Selection in Chapter 4 of the ObjectDB/JPA manual. Selection alias(String name
JPA Doc
55

multiselect(selections)

Method javax.persistence.criteria.CriteriaQuery CriteriaQuery multiselect(   Selection... selections ) Specify the selection items that are to be returned in the query result. Replaces the previously specified selection(s), if any. The type of the result of the query execution depends
JPA Doc
55

array(selections)

Method javax.persistence.criteria.CriteriaBuilder CompoundSelection array(   Selection... selections ) Create an array-valued selection item. Parameters: selections - selection items Returns: array-valued compound selection Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item Since: JPA 2.0
JPA Doc
55

getCompoundSelectionItems()

Method javax.persistence.criteria.Selection List<Selection> getCompoundSelectionItems() Return the selection items composing a compound selection. Modifications to the list do not affect the query. Returns: list of selection items Throws: IllegalStateException - if selection is not a compound selection Since: JPA 2.0
JPA Doc
55

tuple(selections)

Method javax.persistence.criteria.CriteriaBuilder CompoundSelection tuple(   Selection... selections ) Create a tuple-valued selection item. Parameters: selections - selection items Returns: tuple-valued compound selection Throws: IllegalArgumentException - if an argument is a tuple- or array-valued selection item Since: JPA 2.0
JPA Doc
54

construct(resultClass, selections)

> resultClass,   Selection[] selections ) Create a selection item corresponding to a constructor ... after the query is executed. Parameters: resultClass - class whose instance is to be constructed selections - arguments to the constructor Returns: compound selection item Throws: IllegalArgumentException
JPA Doc
54

construct(resultClass, selections)

> resultClass,   Selection... selections ) Create a selection item corresponding to a constructor ... after the query is executed. Parameters: resultClass - class whose instance is to be constructed selections - arguments to the constructor Returns: compound selection item Throws: IllegalArgumentException