Home » Search

About named queries

31-40 of 200Refresh
Manual
44

Paths and Types in JPQL and Criteria API

through a NULL value The following query retrieves country names with their capital city names: SELECT ... , string, date). Simple type values are more useful in queries. They have special operators ... .capital.name is a nested path expression that continues from the Capital entity object to its name
Manual
44

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
Manual
43

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
42

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
JDO Doc
42

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
41

Index Definition

Querying without indexes requires iteration over entity objects in the database one by ... the iteration can be avoided and complex queries over millions of objects can be executed quickly ... indexedField1; @Index(unique="true") int indexedField2; // unique @Index(name="i3") int indexedField3
Manual
40

Database Management Settings

" synchronized="false" />    <query-cache results ... and deleted by ObjectDB when the database is closed. The name of the recovery file is based on the name ... " operations (which modify the database) have to be recorded. For debugging of query failure
JPA Doc
40

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
33

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.
JPA Doc
33

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.