Home » Search

About query

31-40 of 200Refresh
JPA Doc
41

javax.persistence.Query

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

Paths and Types in JPQL and Criteria API

, string, date). Simple type values are more useful in queries. They have special operators ... through a NULL value The following query retrieves country names with their capital city names: SELECT ... . It might be easier to understand exactly how this works by considering the equivalent JOIN query
Manual
35

Comparison in JPQL and Criteria API

Most JPQL queries use at least one comparison operator in their WHERE clause. Comparison Operators ... , the JDO Query Language). ObjectDB supports both forms. Besides the different notation ... can be compared by using any comparison operator. Equality operators (=, <>, ==, !=) on strings in queries
Manual
35

Logical Operators in JPQL and Criteria API

Logical operators in JPQL and in JPA criteria queries enable composition of complex JPQL boolean ... , the JDO Query Language). ObjectDB supports both forms. Binary AND (&&) Operator The following query ... The following query retrieves countries whose population or area exceeds a specified limit: SELECT c FROM
FAQ
34

Is ObjectDB a NoSQL Database?

of NoSQL technology, which are weak query capabilities and lack of ACID (atomicity, consistency, isolation, durability). Unlike other NoSQL solutions, ObjectDB provides full support of rich complex queries, using two standard Java query languages: JPQL (Java Persistence Query Language) and JDOQL (JDO
Tutorial
31

Step 4: Create an ObjectDB Data Set

Queries against the database are represented in BIRT as data sets. To create the data set: Open ... contains Point entity objects. We will use a simple JPQL query that retrieves points with x value in ... and paste to enter the above query and click Finish. When the data set is created successfully - a new
Result
30

ObjectDB Object Database Features

attributes, grouping queries and aggregate queries) which are usually missing from Object Oriented ...  (per EntityManagerFactory). Database file page cache. Query program cache (for repeating queries with different arguments). Query result cache (for repeating queries with the same arguments). Many
JDO Doc
30

javax.jdo.annotations.Query

javax.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
JDO Doc
29

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

CRUD Database Operations with JPA

persisting objects in the database in more detail. JPA Queries with JPQL We can get the number of Point objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point p"); System.out.println("Total Points: " + q1.getSingleResult()); The query string ("SELECT