About ORDER BY

61-70 of 200Refresh
Manual
12

Shared (L2) Entity Cache [2019-08-09]

an entity object that is already managed by the EntityManager returns the existing instance from ... by the EntityManagerFactory and shared by all its EntityManager objects. the broader scope ... is wider, since they exist per database and are shared by all the EntityManagerFactory and EntityManager
Forum
12

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

:query"); q.setParameter("query", "%myQuery%"); I don't get any error! The order
Manual
11

CRUD Database Operations with JPA [2011-02-11]

(using an ORDER BY clause) and even group results (using GROUP BY and HAVING clauses). JPQL ... a managed entity) by the persist method. The new Point objects are physically stored in the database ... objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point
Manual
11

CRUD Database Operations with JPA

(using an ORDER BY clause) and even group results (using GROUP BY and HAVING clauses). JPQL ... a managed entity) by the persist method. The new Point objects are physically stored in the database ... objects in the database by using a simple query: Query q1 = em.createQuery("SELECT COUNT(p) FROM Point
JPA Doc
11

JPA Queries

three groups. SELECT and ORDER BY elements (including tuples): FROM clause elements (representing range ... Queries are represented in JPA by the Query and TypedQuery interfaces: The JPA Query API section ... only at runtime (e.g. depending on which fields are filled by a user in a form) can be done by
Manual
11

Database Replication and Clustering [2014-01-11]

these details to connect to the master server in order to listen to updates. The updates are automatically ... can manage different types of databases, including master databases, slave database (by using ... The configuration above demonstrates a situation in which the master database is managed by a server
Manual
11

Database Replication and Clustering

to connect to the master server in order to listen to updates. The updates are automatically applied ... can manage different types of databases, including master databases, slave database (by using one or ... The configuration above demonstrates a situation in which the master database is managed by a server
Manual
11

Database Replication and Clustering [2019-08-09]

to connect to the master server in order to listen to updates. The updates are automatically applied ... can manage different types of databases, including master databases, slave database (by using one or ... The configuration above demonstrates a situation in which the master database is managed by a server
Manual
11

UPDATE SET Queries in JPA/JPQL [2011-11-22]

queries cannot include the GROUP BY, HAVING and ORDER BY clauses, but the WHERE clause ... Existing entity objects can be updated, as explained in chapter 2, by: Retrieving the entity ... . Applying changes to the database by calling the commit method. JPQL UPDATE queries provide
Manual
11

DELETE Queries in JPA/JPQL

cannot include multiple variables and JOIN, and cannot include the GROUP BY, HAVING and ORDER BY clauses ... As explained in chapter 2, entity objects can be deleted from the database by: Retrieving ... transaction, either explicitly by calling the remove method or implicitly by a cascading operation