CASE-WHEN in Hibernate

[Siva Prasad Reddy Katamreddy]

HI,

Suppose i have a statement written in JDBC as:

SELECT CASE status WHEN 'ACTIVE' THEN '1' WHEN 'PASSIVE' THEN '2' END STATUS_FLAG FROM EMPLOYEE

How to implement this kind of CASE-WHEN type of conditions in Hibernate?

Thanks,
Siva.

[David Newton]

The other solution is cleaner, easier, and more extensible.

[Siva Prasad Reddy Katamreddy]

The other solution is cleaner, easier, and more extensible.

What is that solution??

Thanks,
Siva

[David Newton]

The one we're discussing in your other post about the same thing.

[Jeanne Boyarsky]

And this is why we request a question be kept in one thread. Locking this one. Please continue discussion in your other thread.