🚀 Spring Data: Use @Modifying with @Query for Updates & Deletes!

✅ Did you know? When using Spring Data JPA, it's common to create custom queries using . But when the goal is to update or delete data, it's ESSENTIAL to add the annotation along with .

### 🔍 Why is this important?

Spring Data JPA, by default, expects queries to return data. When you perform an update or delete operation, it doesn’t return entities but rather the number of rows affected. Without the annotation, Spring Data JPA won’t know how to handle this operation and will simply ignore its execution.

### ❌ Common Mistake:

Many developers forget to use and end up with queries that do absolutely nothing.

Problematic Example:

⚠️ Result: Nothing happens!

### ✅ The Solution: Use to ensure Spring Data JPA understands that it's an update or delete operation.

Correct Example:

### 🔨 What changed?

- : Indicates that the method modifies data and does not return entities.

- : Required to ensure the operation is executed successfully and persisted to the database. It can be applied to the method or the class.

### 💡 Pro Tips:

- Whenever you create update or delete operations with , include .

- Ensure the method is annotated with if the transaction scope is not automatically managed.

Want to avoid this problem in your code? 🔥 Add and ensure your operations work as expected! 💪

#SpringBoot #SpringDataJPA #Java #BackendDevelopment #CodingTips #Programming #LinkedInTech