any null check(NVL) function in HQL?

karthika · **Joined:** Wed Apr 11, 2007 2:11 pm **Posts:** 2

hi,

I need to use functionality nvl of oracle in HQL. how can acheive this using HQL.

Regards,
karthika

dharmendra.pandey · **Posted:** Wed Apr 11, 2007 11:38 pm

Hi karthika,

Have you tried it in HQL .It Works in HQl in similar way as in SQl .

karthika · **Joined:** Wed Apr 11, 2007 2:11 pm **Posts:** 2

hi,
It is working in named query and not in HQL. Give me a sample code if any.
Please reply.

Regards,
Karthika

roger_rf · **Posted:** Mon Apr 16, 2007 7:33 am

Hi karthika,
You haven't provided enough information, post the stack trace of the error you're getting. As for the functionality, if you check Oracle9Dialect.java in the src/org/hibernate/dialect directory of your Hibernate distribution, you will see that the NVL() function is defined and its HQL syntax is identical to SQL. Maybe you're using the wrong dialect? Cheers,
Roger