Ordering a join fetched collection in JPA using JPQL/HQL

java jpa hql jpql
stuff22 picture stuff22 · May 5, 2011 · Viewed 11k times · Source

Given the below JPQL statement, how do I modify it so that the kittens in the resulting list are ordered by their age property?

SELECT c FROM Cat c left join fetch c.kittens WHERE c.id = :id

I've tried multiple approches but without any luck. This is esentially what I would like to do, but it doesn't work:

SELECT c FROM Cat c left join fetch c.kittens k WHERE c.id = :id ORDER BY k.age

Answer

bigZee77 picture bigZee77 · May 5, 2011

Hej,

I don't think this is possible when applied using queries. But as far as I remember, you can use this to add default ordering to your collection in the mapping:

@OrderBy("myColumName asc")

Related questions

IN-clause in HQL or Java Persistence Query Language

I have the following parametrised JPA, or Hibernate, query: SELECT entity FROM Entity entity WHERE name IN (?) I want to pass the parameter as an ArrayList<String>, is this possible? Hibernate current tells me, that java.lang.ClassCastException: …

Read More
org.hibernate.QueryException: JPA-style positional param was not an integral ordinal

I have the following JPQL request; @Query(value = "select req_t " + "from TransactionRelation tr " + "inner join tr.requestTransaction req_t " + "inner join req_t.transactionStateHistory req_t_h " + "inner join tr.responseTransaction resp_t " + "inner join resp_t.transactionStateHistory resp_…

Read More
Ignore a FetchType.EAGER in a relationship

I have a problem with EAGERs relationships in a big application. Some entities in this application have EAGER associations with other entities. This become "poison" in some functionalities. Now my team needs to optimize this functionalities, but we cannot change …

Read More