Spring data JPA and parameters that can be null

by

You are right.

A request has been made to support better handling of null parameters.
https://jira.spring.io/browse/DATAJPA-121

In your case, i would advise you to write your repository implementation and to use a custom CriteriaQuery to handle your case.

Also you can use the @Query annotation with the is null syntax :

@Query("[...] where :parameter is null"
public List<Something> getSomethingWithNullParameter();

EDIT

Since Spring data jpa 2.0, spring now supports @Nullable annotation. This can be helpful to handle null parameters passed.

From the documentation :

@Nullable – to be used on a parameter or return value that can be null.

More Related Contents:

  1. Avoiding NullPointerException in Java
  2. Does Java support default parameter values?
  3. What are the -Xms and -Xmx parameters when starting JVM?
  4. How to add custom method to Spring Data JPA
  5. Http Servlet request lose params from POST body after read it once
  6. Is it possible to use raw SQL within a Spring Repository
  7. Java null check why use == instead of .equals()
  8. Check chains of “get” calls for null
  9. How to check if my string is equal to null?
  10. Is null check needed before calling instanceof?
  11. How do I update an entity using spring-data-jpa?
  12. Filtering database rows with spring-data-jpa and spring-mvc
  13. Spring data jpa- No bean named ‘entityManagerFactory’ is defined; Injection of autowired dependencies failed
  14. Spring Data JPA: Batch insert for nested entities
  15. why do we have to use @Modifying annotation for queries in Data Jpa
  16. JPA: update only specific fields
  17. Embed a 3rd-party JApplet in a Swing GUI & pass it parameters
  18. Proper usage of Java -D command-line parameters
  19. Does Spring Data JPA have any way to count entites using method name resolving?
  20. How to replace table name with parameter value while using Spring Data JPA nativeQuery
  21. Having a Column name as Input Parameter of a PreparedStatement
  22. Hibernate order by with nulls last
  23. Why can we use ‘this’ as an instance method parameter?
  24. %Like% Query in spring JpaRepository
  25. JPQL Like Case Insensitive
  26. Spring Data JPA: query ManyToMany
  27. Missing CrudRepository#findOne method
  28. Why has javax.persistence-api been replaced by jakarta.persistence-api in spring data jpa starter?
  29. How to instrument / advice a Spring Data (JPA) repository?
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment