Fast Object Database for Java - with JPA/JDO support

About SELECT

1-10 of 200 resultsRefresh
265

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
245

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
90

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
68

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
65

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
64

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
64

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
64

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
64

construct(resultClass, selections)

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

construct(resultClass, selections)

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

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support