Home » Search

About results

11-20 of 200Refresh
JPA Doc
49

when(condition, result)

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

when(condition, result)

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

Running JPA Queries

when exactly one result object is expected. Query.getResultList - for general use in any other case ... - for use when exactly one result object is expected. TypedQuery.getResultList - for general use in any ... result objects are expected, the query should be run using the getResultList method: TypedQuery
Manual
23

ORDER BY clause (JPQL / Criteria API)

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY ... clause produces objects for examination and the WHERE clause selects which objects to collect as results
Manual
21

CRUD Database Operations with JPA

. The getSingleResult method executes the query and returns the result. It should only be used when exactly one result value is expected (a single Long object in the query above). Let's see another example of a query that returns a single result: Query q2 = em.createQuery("SELECT AVG(p.x) FROM Point p
Manual
19

FROM clause (JPQL / Criteria API)

pair of countries that do not share a border, returning as results only neighbor countries. Caution ... ) is not part of any iterated pair and is therefore excluded from the query results. INNER JOIN simply ... could also cause performance problems. For example, let's look at the following query execution and result
JDO Doc
18

javax.jdo.Query

. There are three required elements in a Query: the class of the results, the candidate collection ... , import statements, ordering and grouping specifications, result and result class, the range of results, and flags indicating whether the query result is unique and whether the query can be modified
Manual
17

Database Management Settings

" synchronized="false" />    results ... execution of relevant queries. The element results="32mb" programs="500 ... manages for queries: The results attribute specifies the size of the query result cache. Caching results
Manual
17

JPA Query API

should be used mainly when the query result type is unknown or when a query returns polymorphic results and the lowest known common denominator of all the result objects is Object. When a more specific result type is expected queries should usually use the TypedQuery interface. It is easier to run
Manual
17

Logical Operators in JPQL and Criteria API

the result is FALSE, because one FALSE operand is sufficient for a FALSE result. If one operand is NULL and the other operand is either TRUE or NULL, the result is NULL (unknown). ObjectDB supports ... NULL represents unknown. Therefore, if one operand is NULL and the other operand is TRUE the result