Hi guys,
I have to execute a complexe SQL Request on Oracle DataBase.
My request uses an Oracle function like this :

SUM(DECODE(table.field,value,1,0)

The problem is that when I try to execute this request through Hibernate
I get the following exception :

net.sf.hibernate.QueryException: undefined alias: decode [.....

Obviously Hibernate does not understand the DECODE function.

How could I make it understand this function ?

Is there any place, for example the mapping.xml file
where I could specify to Hibernate to ignore the DECODE function ?

Any idea about this issue ?

moh.

You can add it to the OracleDialect class.

I don't think you can, AFAIK only one- or zero-Argument functions are yet supported in the select clause of HQL (and you can only add those to the dialect). So currently I don't think there is a way to use multiple-argument functions in the select clause.

Hi,

Is it possible to use createSQLQuery()? I'd try it myself, but I do not have Oracle on my machine.

hope this helps