Simple scenario: a club has multiple (sports) teams, a team being identified by its club ID plus a so-called team type code, e.g. "O20M" (over 20 male), "O35M" (over 35 male), ... "U14F" (under 14 female).
These teams want to be sorted in a special way, see order above. Full details see PR for test case coming.
Club.java (with minimal @OrderBy to break, full code in PR):
When deploying/running the Hibernate test (PR coming, I need an HHH number first), an exception gets thrown:
This is all JPA, except for the @org.hibernate.annotations.OrderBy annotation.
Hibernate ORM test suite