I got this error in application:


releaseDate is a property in a OrdersValue.java.
in HQL, it tries to execute using order by (current_date() - releaseDate), I got this error.
Could someone tell me how to fix this issue, does hibernate allow us to use current_date() in order by clause? I saw in documentation, we can use it in where clause.
Or We must calculate it in java first then add it to HQL.
Thank you.

Hibernate forms query according to mapping between entity class and mapping file.So if you will use (current_date() - releaseDate) in HQL query then (current_date() - releaseDate) property should be there in your bean class i.e. you should have getter setter method for (current_date() - releaseDate)

Maybe this will help you.


Chirag

I know this error occured because of there is not a property in my value class.
But is there any other solutions that i don't need to change data structure?

Then you have to assign difference of (current_date() - releaseDate) to some entity class property and then add to HQL.