89 | Numbers in JPQL and Criteria QueriesNumeric values may appear in JPQL queries in many forms: as numeric literals - e.g. 123, -12.5. as ... of any type and always returns a double value. Criteria Query Arithmetic Expressions JPQL arithmetic operators and functions (which are described above) are available also as JPA criteria query |
88 | Criteria Query ExpressionsThe following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples. |
88 | JPA Annotations for SQL QueriesThe following JPA annotations are designated for SQL queries on relational databases: ObjectDB supports only the preferred JPA query language, JPQL, and silently ignores all the above annotations. |
38 | javax.persistence.Queryjavax.persistence Interface Query Subinterfaces: TypedQuery Interface used to control query execution. Since: JPA 1.0 See Also: TypedQuery Parameter Learn how to define and use JPA/JPQL queries in ... : IllegalStateException - if called for a Java Persistence query language SELECT statement or for a criteria |
29 | SELECT clause (JPQL / Criteria API), the following query returns Country objects that become managed by the EntityManager em: TypedQuery<Country> query = em.createQuery("SELECT c FROM Country c", Country.class); List<Country> results = query.getResultList(); Because the results are managed entity objects they have all the support |
29 | FROM clause (JPQL / Criteria API)The FROM clause declares query identification variables that represent iteration over objects in the database. A query identification variable is similar to a variable of a Java enhanced for loop in a program, since both are used for iteration over objects. Range Variables Range variables are query |
4 | javax.jdo.Queryjavax.jdo Interface Query Superinterfaces: Serializable The Query interface allows applications ... is the factory for Query instances. There may be many Query instances associated with a PersistenceManager. Multiple queries might be executed simultaneously by different threads |
3 | javax.jdo.annotations.Queryjavax.jdo.annotations Annotation Query Target: Classes Annotation for a named query. Corresponds to the xml element "query". Since: JDO 2.1 Extension[] extensions Vendor extensions. Vendor extensions ... of the fetch plan used by this query The name of the fetch plan used by this query Returns: the fetch plan |
2 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)Method javax.jdo.Query void addSubquery( Query sub, String variableDeclaration, String candidateCollectionExpression, String... parameters ) Add a subquery to this query. A subquery is composed as a Query and subsequently attached to a different query (the outer query) by calling this method |
2 | addSubquery(sub, variableDeclaration, candidateCollectionExpression, parameters)Method javax.jdo.Query void addSubquery( Query sub, String variableDeclaration, String candidateCollectionExpression, Map parameters ) Add a subquery to this query. The Map version of the method ... without the leading ":", and the value as the name of the expression in the outer query. If the trimmed expression |
