Custom sort order for enumeration field

Question

Is it possible to change alphabetical sorting in JPA for self-determination?

I have this data in a column division:

BRONZE
SILVER
GOLD
DIAMOND

And I matched this with the entity field:

public enum Division {
    BRONZE,
    SILVER,
    GOLD,
    DIAMOND
}

@Entity
public class MyEntity {

  @Enumerated(EnumType.STRING)
  private Division division;

  ...
}

If I use the default sort, I get the alphabetical order:

• In RONZE
• D iamond
• G OLD
• S ilver

But I want to sort by ore quality (in order of listing).

Answer 1

( ) . , Comparator - . -, .

. , - :

@Enumerated(EnumType.ORDINAL) // The default
private Division division;

, enum Entity . , .

- Formula ( ):

@Enumerated(EnumType.STRING)
private Division division;

@Formula("case division when 'BRONZE' then 0 when 'SILVER' then 1 ... end")
private int divisionQuality;

- .

Answer 2

@OrderBy, Collection. http://www.objectdb.com/api/java/jpa/OrderBy