Home » Search

About SELECT

1-10 of 200Refresh
Manual
282

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
257

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
86

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
Manual
82

Shared (L2) Entity Cache

: NONE - cache is disabled. ENABLE_SELECTIVE - cache is disabled except for selected entity classes (see below). DISABLE_SELECTIVE - cache is enabled except for selected entity classes ... Cache Settings The ENABLE_SELECTIVE mode indicates that the cache is disabled for all the entity
Manual
69

JPA Query Structure (JPQL / Criteria)

and easier to use in Java. JPQL Query Structure As with SQL, a JPQL SELECT query also consists of up to 6 clauses in the following format: SELECT ... FROM ... [WHERE ...] [GROUP BY ... [HAVING ...]] [ORDER BY ...] The first two clauses, SELECT and FROM are required in every retrieval query
JPA Doc
66

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
62

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
61

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
61

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
61

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