Organizational Research By

Surprising Reserch Topic

Experts Most Trusted Topic


is there such thing case expression in jpql


is there such thing case expression in jpql  using -'java,oracle,orm,jpa'

Let say there is a table:

TableA:Field1, Field2, Field3


and associated JPA entity class

@Entity
@Table(name="TableA")
public class TableA{
  @Id
  @Column(name="Field1")
  private Long id;

  @Column(name="Field2")
  private Long field2;

  @Column(name="Field3")
  private Long field3;

  //... more associated getter and setter...
}


Is there any way to construct a JPQL statement that loosely translated to this SQL, ie how to translated the case expression to JPQL?

select field1,
case
  when field2 = 1 then 'One'
  when field2 = 2 then 'Two'
  else 'Other number'
end,
field3
from tableA;

    

asked Sep 30, 2015 by deepak07.s
0 votes
32 views



Related Hot Questions



Government Jobs Opening


...