About ORDER BY

41-50 of 200Refresh
Manual
13

Shared (L2) Entity Cache

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

FROM clause (JPQL / Criteria API)

at the WHERE clause level by using a type expression. For example, in the following query, c iterates ... , and the same query can also be written as follows: SELECT c FROM Country c By default, the name ... name). The default name can be overridden by specifying another name explicitly in the @Entity's
JPA Doc
12

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
12

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
12

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

Database Replication and Clustering

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
12

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

UPDATE SET Queries in JPA/JPQL

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
12

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
Forum
12

Update is ignored by ObjectDB

Hi! Sorry for my bad english skills. When I execute fulfilOrder, only Order entity is updated in ... ; @PersistenceContext(unitName = "SMShop") private EntityManager shopdb; ... public Order fulfilOrder(Long orderID, Long userID, int itemID) { Order order = shopdb.find(Order.class, orderID); if (order