Adding OrderBy clause to a named query

Question

Is it possible to add an OrderBy clause in to JPA Named query at runtime?

Answer 1

Named queries are processed by the persistence provider when the EntityManagerFactory is created. You can't change/modify/append anything about a named query dynamically at runtime.

If you are using JPA 2.0 and you need a way to do high-performance dynamic queries at runtime, you should look into the Criteria API.

Answer 2

From Java EE 5 Documentation : "Is used to specify a named query in the Java Persistence query language, which is a static query expressed in metadata. Query names are scoped to the persistence unit".

As it says, it is static & you can't change the query at runtime. Rather use custom query or if ordering element is fixed then you can use annotation;

Field:

@OrderBy(value="nickname")
List<Person> friends;

Method:

@OrderBy("nickname ASC")
public List<Person> getFriends() {...};