JPA Hibernate Update query in interface

Question

The goal is to update entries in a table. Conceptually I need...

public interface MessageRepository extends JpaRepository<Message, Long> {
    @Modifying
    @Transactional
    @Query("update Message set isRead = true where receiver = id and isRead = false")
    void markAllAsRead(Long id);

This compiles however when I run it It seems as though the transaction never commits. According to the documentation I need to flush the cache. This doesn't seem possible with my current setup with what Ive seen here because I do not have a function body. I'm trying to fix someone elses' code so I really don't want to refactor the entire thing.

czolbe · Accepted Answer · 2020-03-31 05:34:54Z

0

Have you tried using the following parameter?

@Modifying(flushAutomatically = true)

answered Mar 31, 2020 at 5:34

czolbe

6111 gold badge7 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JPA Hibernate Update query in interface

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related