ObjectDB ObjectDB

Internal Website Search

1-10 of 200 resultsRefresh

ORDER BY clause (JPQL / Criteria API)

The ORDER BY clause specifies a required order for the query results. Any JPQL query that does not include an ORDER BY clause produces results in an undefined and non-deterministic order. ORDER BY ... is at least one million people, ordered by the country name: SELECT c.name FROM Country c WHERE c.population > 1000000


javax.persistence.criteria Interface Order An object that defines an ordering over the query results. Since: JPA 2.0 Learn how to use JPA Criteria API's Order in Chapter 4 of the ObjectDB/JPA manual. Expression<?> getExpression() Return the expression that is used for ordering. Return


Method javax.persistence.criteria.Order Order reverse() Switch the ordering. Returns: a new Order instance with the reversed ordering Since: JPA 2.0


Method javax.persistence.criteria.Order boolean isAscending() Whether ascending ordering is in effect. Returns: boolean indicating whether ordering is ascending Since: JPA 2.0


Method javax.persistence.criteria.Order Expression<?> getExpression() Return the expression that is used for ordering. Returns: expression used for ordering Since: JPA 2.0


javax.jdo.annotations Annotation Order Target: Fields (including property get methods) Annotation for the ordering component of an ordered container member, such as Java Collections Framework Array and List types and Java native array types. Corresponds to the xml element "order". Since: JDO 2.1


Method javax.jdo.Query void setOrdering( String ordering ) Set the ordering specification for the result Collection. The ordering specification is a String containing one or more ordering declarations separated by commas. Each ordering declaration is the name of the field on which to order


Annotation Element javax.jdo.annotations.Order Column[] columns The definition of the column(s) to use for ordering. Returns: the columns to use for ordering Default value: {} Since: JDO 2.1


Annotation Element javax.jdo.annotations.Order String column The name of the column to use for ordering the elements of the member. Returns: the name of the ordering column Default value: "" Since: JDO 2.1


Annotation Element javax.jdo.annotations.Order String mappedBy Name of a field or property in the target class that acts as the ordering field or property for this member. Return the name of the field or property in the target class Default value: "" Since: JDO 2.1

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support