Home » Search

About query

21-30 of 200Refresh
JPA Doc
84

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
84

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.
Manual
59

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

SELECT clause (JPQL / Criteria API)

, the following query returns Country objects that become managed by the EntityManager em: TypedQuery query = 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
Manual
49

GROUP BY and HAVING clauses

The GROUP BY clause enables grouping of query results. A JPQL query with a GROUP BY clause returns ... clause in the query execution order is after the FROM and WHERE clauses, but before the SELECT clause. When a GROUP BY clause exists in a JPQL query, database objects (or tuples of database objects
Manual
46

WHERE clause (JPQL / Criteria API)

JPQL query that retrieves selective objects from the database. Out of the four optional clauses of JPQL queries, the WHERE clause is definitely the most frequently used. How a WHERE Clause Works The following query retrieves only countries with population size that exceeds a specified limit
Manual
44

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 ... ; : } Indexes in Queries ObjectDB manages a BTree for every index. A BTree is an ordered map data structure
JDO Doc
43

javax.jdo.Query

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

Database Management Settings

" synchronized="false" />    <query-cache results ... " operations (which modify the database) have to be recorded. For debugging of query failure ... execution of relevant queries. The <query-cache> element <query-cache results="32mb" programs="500
Manual
43

ORDER BY clause (JPQL / Criteria API)

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not ... Expressions The following query returns names of countries whose population size ... directly from expressions in the SELECT clause are allowed in the ORDER BY clause. The following query