Hibernate version 3.2.1

Can anyone please tell me the equivalent of the following mysql statement in HQL.

select * from abc order by greatest(created_date, ifnull(modified_date,0));


I am not able to find the equivalent of the bold part in HQL.

Thanks

There are lot of times when native database specific queries cannot be executed with HQL. During those time , use of native sql queries with hibernate is recommended.

Look at the refrence at
http://www.hibernate.org/hib_docs/v3/re ... rysql.html

this should solve your problem if you wan't database specific advanatges that are not offered by HQL

Thanks for the reply.

I had done it in native SQL, but I felt that this feature is so common that it must be supported by almost all DB types and therefore must be supported by HQL. The application that I am developing needs to support multiple DB types in the future, so I am a bit reluctant to use native SQL since then those pieces of code will have to be changed.

Thanks

if greatest() is just a sql function then map it as such in your Dialect and it will work.