About named queries

31-40 of 200Refresh
Manual
46

Date and Time in JPQL and Criteria Queries

Date and time expressions may appear in JPQL queries: as date and time literals - e.g. {d '2011-12 ... that are evaluated to the date and time on the database server when the query is executed: CURRENT_DATE ... in Criteria Queries The CriteriaBuilder interface provides three factory methods for building date
JDO Doc
46

javax.jdo.Query

There are two namespaces in queries. Type names have their own namespace that is separate from the namespace for fields ... conflict with parameter names. The result of the query by default is a list of result class instances ... to this Query variableDeclaration - the name of the variable in the outer query to bind the results
Manual
45

Collections in JPQL and Criteria Queries

Collections may appear in JPQL queries: as parameters - when collections are assigned as arguments ... , which should be used for checking other collections, such as a collection that is passed to the query ... of collection, so in ObjectDB these operators are treated as synonyms. Criteria Query Collection
Manual
45

Numbers in JPQL and Criteria Queries

Numeric 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
JPA Doc
44

javax.persistence.Query

name. This method is not required to be supported for native queries. Parameters: name - parameter ... name does not exist IllegalStateException - if invoked on a native query when the implementation does ... to be supported for criteria queries only. Parameters: name - parameter name type - type Returns: parameter
JPA Doc
44

JPA Annotations for SQL Queries

The 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.
JPA Doc
44

Criteria Query Expressions

The following interfaces are in use in representing general expressions in criteria queries: See the Query Expressions section for more details and examples.
Manual
44

FROM clause (JPQL / Criteria API)

, and the same query can also be written as follows: SELECT c FROM Country c By default, the name of an entity class in a JPQL query is the unqualified name of the class (e.g. just Country with no package ... name annotation element. Multiple range variables are allowed. For example, the following query
JPA Doc
39

createNamedQuery(name, resultClass)

> resultClass ) Create an instance of TypedQuery for executing a Java Persistence query language named ... to the type specified by the resultClass argument. Parameters: name - the name of a query defined in ... : IllegalArgumentException - if a query has not been defined with the given name or if the query string is found
JPA Doc
39

createNamedQuery(name)

Method javax.persistence.EntityManager Query createNamedQuery(   String name ) Create an instance of Query for executing a named query (in the Java Persistence query language or in native SQL). Parameters: name - the name of a query defined in metadata Returns: the new query instance Throws