About ORDER BY

41-50 of 200Refresh
Issue
14

Collation and String Order

will affect the way strings are sorted in queries (with ORDER BY). Currently strings are always ordered by Unicode order, and a workaround that enables controlling the order is to use normalizing, as discussed ... , DMS and other systems requires correct collation when using order by clause.  +1 for this ... lwalkowski dmarko Arne
Forum
14

How the sort order (in queries) works for non english letters?

definition or the ORDER BY clause, so the sort uses the correct collation per defined locale. Thank ... (we are Czech company). How the sort order works for international (for us 'czech') letters? Does the ordering respects the national requirements? Thank you for clarification ...       ObjectDB uses
Manual
14

Paths and Types in JPQL and Criteria API

classes) are represented in JPQL by the following types of expressions: Variables - FROM ... and functions (e.g. for strings and for numbers), they can be compared by all six comparison operators, and they can be used in ordering. Navigation through Path Expressions A path expression always starts
Tutorial
14

Getting Started with JPA

to start by running a live sample application in your IDE, you should be able to follow this tutorial
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
13

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
13

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
13

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