Is there such thing CASE expression in JPQL?

by

It has been added in JPA 2.0

Usage:

SELECT e.name, CASE WHEN (e.salary >= 100000) THEN 1 WHEN (e.salary < 100000) THEN 2 ELSE 0 END FROM Employee e

Ref: http://en.wikibooks.org/wiki/Java_Persistence/JPQL_BNF#New_in_JPA_2.0

More Related Contents:

  1. Difference between FetchType LAZY and EAGER in Java Persistence API?
  2. How to map a composite key with JPA and Hibernate?
  3. How to map an entity field whose name is a reserved word in JPA
  4. Do I need elements in persistence.xml?
  5. What’s the difference between JPA and Hibernate? [closed]
  6. What is the “owning side” in an ORM mapping?
  7. What is the solution for the N+1 issue in JPA and Hibernate?
  8. JPA CascadeType.ALL does not delete orphans
  9. What is the difference between persist() and merge() in JPA and Hibernate?
  10. JPQL Create new Object In Select Statement – avoid or embrace?
  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: How to have one-to-many relation of the same Entity type
  14. JPA/Hibernate Native Queries do not recognize Parameters
  15. How to solve the LazyInitializationException when using JPA and Hibernate
  16. JPA – Persisting a One to Many relationship
  17. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  18. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  19. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  20. JPA Criteria builder IN clause query
  21. Doing an “IN” query with Hibernate
  22. @Basic(optional = false) vs @Column(nullable = false) in JPA
  23. The onFlushDirty Hibernate Interceptor method is never called
  24. How to map a map JSON column to Java Object with JPA
  25. No operator matches the given name and argument type(s). You might need to add explicit type casts. — Netbeans, Postgresql 8.4 and Glassfish
  26. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  27. Batch inserts with JPA/EJB3
  28. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  29. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  30. Does JPA support mapping to sql views?

Leave a Comment