About WHERE

manual

WHERE clause (JPQL / Criteria API)

Explains how to use the WHERE clause in a JPQL query. The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is ... Out of the four optional clauses of JPQL queries, the WHERE clause is definitely the most frequently used. This page covers the following topics: How a WHERE Clause Works WHERE Predicate and Indexes ...

 
manual

JPA Query Structure (JPQL / Criteria)

Explains the structure of a JPQL query, which consists of 6 clauses: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.... SELECT ... FROM ... [ WHERE ... ] [ GROUP BY ... [ HAVING ... have a slightly different form). The other JPQL clauses, WHERE , GROUP BY , HAVING and ORDER BY are optional. The ...

 
api-jpa

where(restriction)

Modify the query to restrict the query result according to the specified boolean expression.(Method of javax.persistence.criteria.CriteriaQuery)

 
api-jpa

where(restrictions)

Modify the query to restrict the query result according to the conjunction of the specified restriction predicates.(Method of javax.persistence.criteria.CriteriaQuery)

 
manual

Chapter 4 - JPA Queries (JPQL / Criteria)

Describes the Java Persistence Query Language (JPQL), the JPA Criteria API, and explains how to use queries in JPA.... describing the main clauses of JPQL queries (SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY): JPA Query Structure (JPQL / ...

 
api-jpa

where(restriction)

Modify the query to restrict the query results according to the specified boolean expression.(Method of javax.persistence.criteria.AbstractQuery)

 
api-jpa

where(restrictions)

Modify the query to restrict the query results according to the conjunction of the specified restriction predicates.(Method of javax.persistence.criteria.AbstractQuery)

 
forum_thread

Using aliases in WHERE clause

Hi, I'm trying to run query : SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE i.status IS NOT NULL Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected query token 'i' SELECT DISTINCT ppi.inquiries AS i FROM ProjectPartInfo ppi WHERE  ==> i <== .status IS NOT NULL   ... ppi . inquiries AS i FROM ProjectPartInfo ppi WHERE i . STATUS IS NOT NULL Unfortunately, 'i' alias doesn't work in WHERE clause : Query Execution Error ===================== Unexpected ...

 
forum_thread

CriteriaQuery .where() for multiple conditions

When using the below, there appears to be an OR condition:   ... to be an OR condition:   criteriaQuery. where ( criteriaBuilder. equal ( root. get ( "name" ) , name ) ) ; criteriaQuery. where ( criteriaBuilder. equal ( root. get ( ...

 
forum_thread

Where Does ObjectDB Block/Lock?

These are questions asked in the context of the proposed architecture described in the forum thread titled, "Sample JDO Architecture for Follow Up Questions".   Questions about blocking/locking.  With my PersistenceManager multiThreaded=true architecture, I desire to know where ObjectDB is actually blocking/locking so I might adapt to achieve better concurrency. 1) Where are locks when accessing PersistenceManager by multiple threads? 2) Does it lock at PersistenceManager.currentTransaction()? ... multiThreaded=true architecture, I desire to know where ObjectDB is actually blocking/locking so I might adapt to achieve better concurrency. 1) Where are locks when accessing PersistenceManager by multiple threads? ...