Package org.hibernate.annotations

Annotation Interface OrderBy

@Target({METHOD,FIELD}) @Retention(RUNTIME) @Deprecated(since="6.3", forRemoval=true) public @interface OrderBy
Deprecated, for removal: This API element is subject to removal in a future version.
Use SQLOrder instead. This annotation will be removed eventually, since its unqualified name collides with OrderBy.
Order a collection using an expression written in native SQL.

The order is applied by the database when the collection is fetched, but is not maintained by operations that mutate the collection in memory.

If the collection is a Set or Map, the order is maintained using a LinkedHashSet or LinkedHashMap. If the collection is a bag or List, the order is maintained by the underlying ArrayList.

There are several other ways to order or sort a collection:

  • Use the JPA-defined OrderBy annotation to order using an expression written in HQL/JPQL. Since HQL is more portable between databases, this is the preferred alternative most of the time.
  • Use SortComparator to sort the collection in memory using a Comparator, or SortNatural to sort the collection in memory according to its natural order.
  • Use OrderColumn to maintain the order of a List with a dedicated index column.

It's illegal to use OrderBy together with the JPA-defined OrderBy for the same collection.

See Also:

  • Required Element Summary

    Required Elements
    Modifier and Type
    Required Element
    Description
    String
    clause
    Deprecated, for removal: This API element is subject to removal in a future version.
    The native SQL expression used to sort the collection elements.

  • Element Details

    • clause

      String clause
      Deprecated, for removal: This API element is subject to removal in a future version.
      The native SQL expression used to sort the collection elements.