Hello everybody,

I want to sort my objects either ascending or descending but by adding null sort at the end of the result. I found that it is possible to do it using JDBC by either adding ORDER BY myField NULLS LAST but it does not work using MS SQLServer or MySQL. I found a workaround to do the same without using NULLS LAST.

But my question is : How can I sort my result using Hibernate in order to put null values at the end of my sort?
Is there a way to inject in the HQL query NULLS LAST? because Hibernate deletes NULLS LAST before querying the database.

Thanks in advance,
Matti

Hello,

I have the same problem. I saw that a bug is reported on that, but it's always marked as unresolved.

Thanks,
Elias

Did you try following the work-around that is mentioned in the bug? That seems like a quick fix that should work...

Hello,
Thanks for your answer. Yes I try the workaround and I use it until a better choice. I find that parsing the SQL query and adding NULLS FIRST or LAST depending on the sort is not the best solution but it works. Quite hard to use it with SQLServer especially with SELECT DISTINCT request but it works.

Thanks,
Matti