Internal Website Search

1-10 of 200 resultsRefresh

Criteria Query Selection and Results

and for representing query results as tuples. SELECT Clause Elements The content of the SELECT ... ;for more details and examples. Query Results as Tuples JPA 2 introduces a new way to represent multi selection results (i.e. results of a query with multiple expressions in the SELECT clause) using

SELECT clause (JPQL / Criteria API)

= em. createQuery ("SELECT c FROM Country c", Country.class); List results = query. getResultList (); Because the results are managed entity objects they have all the support that JPA provides ... detection , support for delete , etc. Query results are not limited to entity objects. JPA 2 adds

Setting and Tuning of JPA Queries

. Result Range (setFirstResult, setMaxResults) The setFirstResult and  setMaxResults methods enable defining a result window that exposes a portion of a large query result list (hiding anything outside that window). The setFirstResult method is used to specify where the result window begins, i.e

Running JPA Queries

- for use when exactly one result object is expected. Query.getResultList - for general use in any ... - for use when exactly one result object is expected. TypedQuery.getResultList - for general use in any ... : TypedQuery query = em. createQuery ("SELECT c FROM Country c", Country.class); List results = query

SimpleCase.otherwise(result)

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase Expression otherwise (   R  result ) Add an "else" clause to the case expression. Parameters: result - "else" result Return: expression Since: JPA 2.0

SimpleCase.otherwise(result)

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase Expression otherwise (    Expression   result ) Add an "else" clause to the case expression. Parameters: result - "else" result expression Return: expression Since: JPA 2.0

SimpleCase.when(condition,result)

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase CriteriaBuilder $ SimpleCase when (   C condition,     Expression   result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result expression Return: simple case expression Since: JPA 2.0

SimpleCase.when(condition,result)

JPA Method in javax.persistence.criteria.CriteriaBuilder$SimpleCase CriteriaBuilder $ SimpleCase when (   C condition,    R  result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Return: simple case expression Since: JPA 2.0

Case.when(condition,result)

JPA Method in javax.persistence.criteria.CriteriaBuilder$Case CriteriaBuilder $ Case when (    Expression  condition,    R  result ) Add a when/then clause to the case expression. Parameters: condition - "when" condition result - "then" result value Return: general case expression Since: JPA 2.0

[ODB1] Chapter 7 - JDOQL Queries

to boost recycling rates in Manchester approved n criteria, and iteration over the results in ... result is a subset of objects from the candidate collection that contains only the instances ... result = (Collection)query.execute(); Queries are represented by the javax.jdo.Query interface. A Query