Spring Boot Data JPA – Modifying update query – Refresh persistence context

by

I know this is not a direct answer to your question, since you already have built a fix and started a pull request on Github. Thank you for that!

But I would like to explain the JPA way you can go. So you would like to change all entities which match a specific criteria and update a value on each. The normal approach is just to load all needed entities:

@Query("SELECT * FROM Email e where e.active = true and e.expire <= NOW()")
List<Email> findExpired();

Then iterate over them and update the values:

for (Email email : findExpired()) {
  email.setActive(false);
}

Now hibernate knows all changes and will write them to the database if the transaction is done or you call EntityManager.flush() manually. I know this won’t work well if you have a big amount of data entries, since you load all entities into memory. But this is the best way, to keep the hibernate entity cache, 2nd level caches and the database in sync.

Does this answer say “the `@Modifying´ annotation is useless”? No! If you ensure the modified entities are not in your local cache e.g. write-only application, this approach is just the way to go.

And just for the record: you don’t need @Transactional on your repository methods.

Just for the record v2: the active column looks as it has a direct dependency to expire. So why not delete active completely and look just on expire in every query?

More Related Contents:

  1. Disable all Database related auto configuration in Spring Boot
  2. Spring Data optional parameter in query method
  3. Can’t Autowire @Repository annotated interface in Spring Boot
  4. Spring Boot – Loading Initial Data
  5. Spring Data and Native Query with pagination
  6. Spring Data JPA map the native query result to Non-Entity POJO
  7. How to use Spring managed Hibernate interceptors in Spring Boot?
  8. Joining two table entities in Spring Data JPA
  9. Spring boot – Not a managed type
  10. Spring data JPA query with parameter properties
  11. How to test Spring’s declarative caching support on Spring Data repositories?
  12. Spring Data – ignore parameter if it has a null value
  13. Spring Data JPA – Multiple EnableJpaRepositories
  14. Hibernate Transactions and Concurrency Using attachDirty (saveOrUpdate)
  15. Spring Data: “delete by” is supported?
  16. Can Spring Data REST’s QueryDSL integration be used to perform more complex queries?
  17. How to use OrderBy with findAll in Spring Data
  18. No property found for type… custom Spring Data repository
  19. How to generate a ddl creation script with a modern Spring Boot + Data JPA and Hibernate setup?
  20. Spring @Transactional with a transaction across multiple data sources
  21. Spring Boot and how to configure connection details to MongoDB?
  22. Configure Multiple MongoDB repositories with Spring Data Mongo
  23. Missing CrudRepository#findOne method
  24. Best way of handling entities inheritance in Spring Data JPA
  25. With Spring Data REST, why is the @Version property becoming an ETag and not included in the representation?
  26. Multiple data source and schema creation in Spring Boot
  27. Spring and hibernate: No Session found for current thread
  28. Spring Data JDBC / Spring Data JPA vs Hibernate
  29. LazyInitializationException in JPA and Hibernate
  30. Spring Data JPA – Is it possible to sort on a calculated property?

Leave a Comment