How to define null-handling in Spring Data JPA sorts?

Question

I need my data to be ordered by null and not null only. Like below:

Column A
null 
null 
null
8 
10
5

Meaning once all the null values are on top, the rest of the values should not be sorted at all and come as is. Any idea how this can be done using jpa query/ native query.

Answer 1

If you project use Spring Boot, you can add YML configuration like this, it work for me.

spring:
  jpa:
    properties:
        hibernate.order_by.default_null_ordering: last

Answer 2

Use JPQL and you will be happy.

SELET f FROM Foo f ORDER BY f.name NULLS LAST