Understanding Repositories in Spring Data JPA!

Spring Data JPA provides several repository interfaces to facilitate data persistence and retrieval. These interfaces extend each other to build upon functionality, starting from basic CRUD operations to more advanced capabilities like pagination and sorting.

This article explores the following repository interfaces:

CrudRepository
ListCrudRepository
JpaRepository
PagingAndSortingRepository
ListPagingAndSortingRepository

Repository Hierarchy in Spring Data JPA

Basic Structure

CrudRepository
   |
   --> PagingAndSortingRepository
         |
         --> JpaRepository
   |
   --> ListCrudRepository
         |
         --> ListPagingAndSortingRepository

Overview of Interfaces

CrudRepository:
- Provides CRUD operations: Create, Read, Update, Delete.
- Returns Optional for nullable results.
ListCrudRepository:
- An extension of CrudRepository.
- Returns List instead of Iterable for find operations, making it easier to work with collections.
PagingAndSortingRepository:
- Extends CrudRepository.
- Adds support for pagination and sorting.
JpaRepository:
- Extends PagingAndSortingRepository.
- Provides JPA-specific methods like flush() and saveAndFlush().
ListPagingAndSortingRepository:
- Extends ListCrudRepository.
- Combines ListCrudRepository and PagingAndSortingRepository.
- Returns List instead of Iterable while supporting pagination and sorting.

CrudRepository

Key Features

Basic CRUD operations.

Methods:

  Optional<T> findById(ID id);
  Iterable<T> findAll();
  void deleteById(ID id);
  T save(T entity);

Example

@Repository
public interface EmployeeCrudRepository extends CrudRepository<Employee, Long> {}

// Usage
@Autowired
private EmployeeCrudRepository repository;

public void demoCrud() {
    Employee emp = new Employee("John", "Developer");
    repository.save(emp); // Create

    Optional<Employee> retrievedEmp = repository.findById(emp.getId()); // Read
    repository.deleteById(emp.getId()); // Delete
}

ListCrudRepository

Key Features

Returns List instead of Iterable, improving usability.

Example

@Repository
public interface EmployeeListCrudRepository extends ListCrudRepository<Employee, Long> {}

// Usage
@Autowired
private EmployeeListCrudRepository repository;

public void demoListCrud() {
    List<Employee> employees = repository.findAll(); // Returns a List instead of Iterable
}

PagingAndSortingRepository

Key Features

Adds support for pagination and sorting.

Methods:

  Iterable<T> findAll(Sort sort);
  Page<T> findAll(Pageable pageable);

Example

@Repository
public interface EmployeePagingRepository extends PagingAndSortingRepository<Employee, Long> {}

// Usage
@Autowired
private EmployeePagingRepository repository;

public void demoPagingAndSorting() {
    Pageable pageable = PageRequest.of(0, 5, Sort.by("name").ascending());
    Page<Employee> page = repository.findAll(pageable);
}

JpaRepository

Key Features

JPA-specific methods like saveAndFlush, flush, and deleteInBatch.
Suitable for complex queries and JPA-specific use cases.

Example

@Repository
public interface EmployeeJpaRepository extends JpaRepository<Employee, Long> {}

// Usage
@Autowired
private EmployeeJpaRepository repository;

public void demoJpa() {
    repository.saveAndFlush(new Employee("Jane", "Manager")); // Saves and flushes immediately
    repository.deleteAllInBatch(); // Efficient batch delete
}

ListPagingAndSortingRepository

Key Features

Combines ListCrudRepository with PagingAndSortingRepository.
Supports pagination, sorting, and returns List instead of Iterable.

Example

@Repository
public interface EmployeeListPagingRepository extends ListPagingAndSortingRepository<Employee, Long> {}

// Usage
@Autowired
private EmployeeListPagingRepository repository;

public void demoListPagingAndSorting() {
    Pageable pageable = PageRequest.of(0, 5);
    List<Employee> employees = repository.findAll(pageable).getContent();
}

Comparison Table

Repository Interface	CRUD Operations	Pagination/Sorting	JPA-Specific	Return Type for FindAll
CrudRepository	✅	❌	❌	`Iterable`
ListCrudRepository	✅	❌	❌	`List`
PagingAndSortingRepository	✅	✅	❌	`Iterable`
JpaRepository	✅	✅	✅	`List`
ListPagingAndSortingRepository	✅	✅	❌	`List`

When to Use Each Repository

CrudRepository: For simple CRUD operations with minimal dependencies.
ListCrudRepository: When working with collections and List is preferred.
PagingAndSortingRepository: When pagination or sorting is required.
JpaRepository: For advanced JPA-specific functionalities.
ListPagingAndSortingRepository: When combining ListCrudRepository with pagination/sorting.

More such articles:

medium.com/techwasti

youtube.com/@maheshwarligade

techwasti.com/series/spring-boot-tutorials

techwasti.com/series/go-language

Understanding Repositories in Spring Data JPA!

Comments

Spring Boot

Implementing Distributed and Scheduled Locks Using Redis and Spring Boot (Without ShedLock)!

More from this blog

Adopting an MCP-First API Design for the Agentic Era | Beyond REST.

Article 6: Mastering Kestra's Plugin Ecosystem.

Article 5: Advanced Workflow Patterns in Kestra.

Article 4: Building Your First ETL Pipeline with Kestra.

Article 3: Understanding Kestra's Architecture: Flows, Tasks, and Namespaces

Repository Hierarchy in Spring Data JPA

Basic Structure

Overview of Interfaces

CrudRepository

Key Features

Example

ListCrudRepository

Key Features

Example

PagingAndSortingRepository

Key Features

Example

JpaRepository

Key Features

Example

ListPagingAndSortingRepository

Key Features

Example

Comparison Table

When to Use Each Repository

Command Palette

Comments

Spring Boot

Implementing Distributed and Scheduled Locks Using Redis and Spring Boot (Without ShedLock)!

More from this blog

Repository Hierarchy in Spring Data JPA

Basic Structure

Overview of Interfaces

CrudRepository

Key Features

Example

ListCrudRepository

Key Features

Example

PagingAndSortingRepository

Key Features

Example

JpaRepository

Key Features

Example

ListPagingAndSortingRepository

Key Features

Example

Comparison Table

When to Use Each Repository