Handling soft-deletes with Spring JPA

by

@Where(clause="is_active=1") is not the best way to handle soft delete with spring data jpa.

First, it only works with hibernate implement.

Second, you can never fetch soft deleted entities with spring data.

My solution is el provided by spring data. #{#entityName} expression can be used on generic repository represent concrete entity type name.

And code will be like this:

//Override CrudRepository or PagingAndSortingRepository's query method:
@Override
@Query("select e from #{#entityName} e where e.deleteFlag=false")
public List<T> findAll();

//Look up deleted entities
@Query("select e from #{#entityName} e where e.deleteFlag=true")
public List<T> recycleBin(); 

//Soft delete.
@Query("update #{#entityName} e set e.deleteFlag=true where e.id=?1")
@Modifying
public void softDelete(String id);

More Related Contents:

  1. setMaxResults for Spring-Data-JPA annotation?
  2. Using generics in Spring Data JPA repositories
  3. What is difference between CrudRepository and JpaRepository interfaces in Spring Data JPA?
  4. Spring CrudRepository findByInventoryIds(List inventoryIdList) – equivalent to IN clause
  5. Spring-Data FETCH JOIN with Paging is not working
  6. Why use returned instance after save() on Spring Data JPA Repository?
  7. How to use @Transactional with Spring Data?
  8. Spring Data JPA: query ManyToMany
  9. Spring Data JPA find by embedded object property
  10. How to enable LockModeType.PESSIMISTIC_WRITE when looking up entities with Spring Data JPA?
  11. Spring Data + JPA with multiple datasources but only one set of Repositories
  12. How to properly use findBySomeOtherId not findById in Spring data jpa?
  13. What is this spring.jpa.open-in-view=true property in Spring Boot?
  14. Spring Boot, Spring Data JPA with multiple DataSources
  15. Spring Data JPA – ZonedDateTime format for json serialization
  16. How does the FetchMode work in Spring Data JPA
  17. Filtering database rows with spring-data-jpa and spring-mvc
  18. Spring data jpa- No bean named ‘entityManagerFactory’ is defined; Injection of autowired dependencies failed
  19. How to manually force a commit in a @Transactional method? [duplicate]
  20. JPA: update only specific fields
  21. Are you supposed to have one repository per table in JPA?
  22. How to map sql native query result into DTO in spring jpa repository?
  23. Difference between save and saveAndFlush in Spring data jpa
  24. spring data jpa @query and pageable
  25. JPQL Like Case Insensitive
  26. Spring Data JPA: Query by Example?
  27. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  28. Spring Data – Multi-column searches
  29. Best way of handling entities inheritance in Spring Data JPA
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment