NVL function usage in Order.asc() gives error message. COuld you please suggest if there is any alternate solution.

results = criteria.setFirstResult(page * pageSize)
.addOrder( Order.asc("nvl(preferred_name, first_name)") )
.setMaxResults(pageSize)
.list();

Error Message:

10:35:45,637 DEBUG web.servlet.DispatcherServlet | Could not complete request
org.hibernate.QueryException: could not resolve property: nvl(preferred_name, first_name) of: com.test.pojo.EmployeeInfo

Hello achintya, does your database support the nvl function? if it does you could see the dialect of the database extend it and register the nvl function yourself,

It worked for me a while ago,

regards,

Thaks for the post. I am using oracle 10g database. This DB supports NVL.
I see the same issue with other oracle functions like decode also.

I never used dialect. If possible could you please provide more infomation on registering function or provide the sample code. It would be of great help. Thanks.