Spring data jpa. Find max if no result return default value

java spring spring-data-jpa hql
Sergii picture Sergii · Jun 23, 2017 · Viewed 25.9k times · Source

I've implemented in my spring repository interface:

@Query("SELECT max(ch.id) FROM MyEntity ch")
Long getMaxId();

It works correctly if db is not empty. If I start my environment with test configuration (H2DB is used) - there is no data in the very beginning. And result returned by getMaxId() is null. I would like to have here 0.

Is it possible to modify my *JpaRepository to have 0 result? If yes, how it should be modified?

Answer

YCF_L picture YCF_L · Jun 23, 2017

You can use coalesce like :

@Query("SELECT coalesce(max(ch.id), 0) FROM MyEntity ch")
Long getMaxId();

If there are no data it will return 0 instead of null.

Related questions

JpaRepository Not supported for DML operations [delete query]

I have written a query to delete some objects in my interface extending JPaRepository, but when I execute the query it throws an exception! Can anyone explain it for me? Query: public interface LimitRepository extends JpaRepository<CLimit, Long> { @…

Read More
What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?

What is the difference between CrudRepository and JpaRepository interfaces in Spring Data JPA? When I see the examples on the web, I see them there used kind of interchangeably. What is the difference between them? Why would you want to …

Read More
Spring CrudRepository findByInventoryIds(List<Long> inventoryIdList) - equivalent to IN clause

In Spring CrudRepository, do we have support for "IN clause" for a field? ie something similar to the following? findByInventoryIds(List<Long> inventoryIdList) If such support is not available, what elegant options can be considered? Firing queries for …

Read More