Using Decode in HQL

janiceileen · **Joined:** Tue Mar 10, 2009 10:48 pm **Posts:** 18

Hi,

I am having errors when using select decode in my HQL createQuery.
Does it support?? What is the workaround??? I cant use native SQL for my project. How?? I am totally lost.

Appreciate any kinds of help!
Thanks in advance!

ethnarch · **Joined:** Tue Aug 01, 2006 9:24 pm **Posts:** 120

Decode is not a function readily available on most databases, actually to my knowledge it's oracle specific. If you are using a database specific command then your not really database agnostic anyway. Which is why there is not a similar hql function for this.

http://forum.hibernate.org/viewtopic.ph ... 348dfc83f3

There is a way to do this with formula's but I have never done it myself. Take a look at these links
http://forum.springsource.org/showthread.php?t=32177

http://www.onjava.com/pub/a/onjava/2005 ... rnate.html

http://www.hibernate.org/hib_docs/v3/ap ... rmula.html

hope this helps