Snippet

Executing Bulk Updates with @Modifying and @Query

When performing updates or deletions via JPQL in Spring Data JPA, the @Modifying annotation is required. This informs the framework that the query is an 'execute' operation rather than a 'select', allowing it to properly manage the persistence context.

snippet.java

java

@Repository
public interface UserRepository extends JpaRepository<User, Long> {
    @Modifying
    @Query("UPDATE User u SET u.status = :status WHERE u.lastLogin < :date")
    int updateStatusForInactiveUsers(String status, LocalDateTime date);
}

spring

Breakdown

@Modifying

Signals that the query modifies the database state (INSERT, UPDATE, or DELETE).

@Query("UPDATE User u...")

Defines the custom JPQL statement for the bulk update operation.

Previous snippet Next snippet

More Intermediate Java exercises →

Executing Bulk Updates with @Modifying and @Query

Related