Spring Data JPA Delete Multiple Rows

🎓 Top 15 Udemy Courses (80-90% Discount): My Udemy Courses - Ramesh Fadatare — All my Udemy courses are real-time and project oriented courses.

▶️ Subscribe to My YouTube Channel (178K+ subscribers): Java Guides on YouTube

▶️ For AI, ChatGPT, Web, Tech, and Generative AI, subscribe to another channel: Ramesh Fadatare on YouTube

Spring Data JPA simplifies CRUD operations for databases, including the ability to delete multiple rows based on specific criteria. Deleting multiple rows can often be more efficient than deleting them one by one, especially when working with large datasets. In this blog post, we'll walk you through the steps to delete multiple rows with Spring Data JPA.

Create JPA Entity - Order

To demonstrate this example, we will use below Order JPA entity:

@Entity
public class Order {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String status;
    private LocalDate orderDate;

    // getters, setters, and other methods...
}

Spring Data JPA Repository - OrderRepository

And a corresponding JPA repository for Order entity:

public interface OrderRepository extends JpaRepository<Order, Long> {
}

Deleting Multiple Rows by Criteria 

You might want to delete multiple Order records based on a certain criteria, such as all orders with a specific status. Here's how you can do it: 

Using Derived Delete Queries:

public interface OrderRepository extends JpaRepository<Order, Long> {

    @Transactional
    void deleteByStatus(String status);
    
    @Transactional
    void deleteByOrderDateBefore(LocalDate date);
}

With these method declarations, Spring Data JPA will generate the necessary code to delete orders that match the given criteria. The @Transactional annotation ensures the operation is wrapped within a transaction.

Using @Modifying with @Query: 

For more complex scenarios, or if you want more control over the query, you can use the @Query annotation:

@Modifying
@Transactional
@Query("delete from Order o where o.status = ?1")
void deleteOrdersWithStatus(String status);

The @Modifying annotation tells Spring Data JPA that this query will modify data, thus requiring a transaction. The @Query annotation allows you to provide a custom JPQL statement.

Service Layer Integration 

To maintain a clean separation of concerns, let's create a service class that uses our repository:

@Service
public class OrderService {

    private final OrderRepository orderRepository;

    @Autowired
    public OrderService(OrderRepository orderRepository) {
        this.orderRepository = orderRepository;
    }

    public void deleteOrdersByStatus(String status) {
        orderRepository.deleteByStatus(status);
    }
    
    public void deleteOrdersBeforeDate(LocalDate date) {
        orderRepository.deleteByOrderDateBefore(date);
    }
}

Important Points 

Error Handling: Deleting multiple rows can lead to database constraint violations or other unforeseen issues. Ensure you handle potential errors gracefully. 

Cascade Deletes: If your entity has relationships with CascadeType.REMOVE, then deleting the main entity might also delete related entities. Always review your entity relationships and cascade settings before bulk delete operations. 

Performance Implications: While deleting multiple rows in one go can be efficient, it's also resource-intensive. If you're deleting a very large number of rows, consider breaking the operation into smaller batches.

Conclusion 

Spring Data JPA provides powerful tools for bulk delete operations, enabling you to delete multiple rows efficiently based on specific criteria. While this simplifies database operations, always be mindful of potential implications in terms of database constraints, relationships, and performance.

My Top and Bestseller Udemy Courses. The sale is going on with a 70 - 80% discount. The discount coupon has been added to each course below:

Build REST APIs with Spring Boot 4, Spring Security 7, and JWT

🆕 High-Demand 80–90% OFF

[NEW] Learn Apache Maven with IntelliJ IDEA and Java 25

🆕 High-Demand 80–90% OFF

ChatGPT + Generative AI + Prompt Engineering for Beginners

🚀 Trending Now 80–90% OFF

Spring 7 and Spring Boot 4 for Beginners (Includes 8 Projects)

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Building Real-Time REST APIs with Spring Boot - Blog App

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Building Microservices with Spring Boot and Spring Cloud

🌟 Top Rated 80–90% OFF
Available in Udemy for Business

Java Full-Stack Developer Course with Spring Boot and React JS

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Build 5 Spring Boot Projects with Java: Line-by-Line Coding

🌟 Top Rated 80–90% OFF

Testing Spring Boot Application with JUnit and Mockito

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Spring Boot Thymeleaf Real-Time Web Application - Blog App

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Master Spring Data JPA with Hibernate

🔥 Bestseller 80–90% OFF
Available in Udemy for Business

Spring Boot + Apache Kafka Course - The Practical Guide

🎓 Student Favorite 80–90% OFF
Available in Udemy for Business

Java Testing: Mastering JUnit 5 Framework

🆕 New 80–90% OFF

Reactive Programming in Java: Spring WebFlux and Testing

🌟 Top Rated 80–90% OFF

Spring Boot + RabbitMQ Course - The Practical Guide

🌟 Top Rated 80–90% OFF
Available in Udemy for Business

Functional Programming in Java (Includes Java Collections)

🎓 Student Favorite 80–90% OFF

ChatGPT for Java Developers: Boost Your Productivity with AI

🚀 Trending Now 80–90% OFF