Hibernate Named Query Order By parameter

by

Not supported, input parameters are only allowed in the WHERE and HAVING clauses and you cannot use parameters for the ORDER BY clause. Or if I rephrase, you can’t use parameters for columns, only values. So, either:

  • Have as much named queries as possible sort orders
  • Concatenate the ordering string to the query string
  • Use criteria queries

More Related Contents:

  1. HQL recursion, how do I do this?
  2. How do you do a limit query in JPQL or HQL?
  3. How to fix org.hibernate.LazyInitializationException – could not initialize proxy – no Session
  4. What is lazy loading in Hibernate?
  5. How to print a query string with parameter values when using Hibernate
  6. Why does Hibernate require no argument constructor?
  7. When and why JPA entities should implement the Serializable interface?
  8. JPQL Create new Object In Select Statement – avoid or embrace?
  9. org.hibernate.MappingException: Could not determine type for: java.util.List, at table: College, for columns: [org.hibernate.mapping.Column(students)]
  10. How to map a PostgreSQL array with Hibernate
  11. What is the difference between Unidirectional and Bidirectional JPA and Hibernate associations?
  12. How to remove entity with ManyToMany relationship in JPA (and corresponding join table rows)?
  13. JPA/Hibernate Native Queries do not recognize Parameters
  14. Getting Database connection in pure JPA setup
  15. Difference Between One-to-Many, Many-to-One and Many-to-Many?
  16. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  17. Error : java.lang.NoSuchMethodError: org.objectweb.asm.ClassWriter.(I)V
  18. Postgresql UUID supported by Hibernate?
  19. Hibernate, iBatis, Java EE or other Java ORM tool
  20. How to perform a non-polymorphic HQL query in Hibernate?
  21. Is it possible to dynamically define column names in Hibernate / JPA?
  22. How do you map a “Map” in hibernate using annotations?
  23. Batch inserts with JPA/EJB3
  24. HQL – row identifier for pagination
  25. No data type for node: org.hibernate.hql.internal.ast.tree.IdentNode HQL
  26. Is there a more efficient way of making pagination in Hibernate than executing select and count queries?
  27. Change Table Name of an Entity on runtime? [duplicate]
  28. Hibernate saving User model to Postgres
  29. How to map one class to different tables using hibernate/jpa annotations
  30. How to use JTA support in Tomcat 6 for Hibernate?

Leave a Comment