Enterprise Java

Writing Tests for Data Access Code – Don’t Test the Framework

When we write tests to our data access code, should we test every method of its public API?

It sounds natural at first. After all, if we don’t test everything, how can we know that our code works as expected?

That question provides us an important clue:

Our code.

We should write tests only to our own code.

What Is Our Own Code?

It is sometimes hard to identify the code which we should test. The reason for this is that our data access code is integrated tightly with the library or framework which we use when we save information to the used data storage or read information from it.

For example, if we want to create a Spring Data JPA repository which provides CRUD operations to Todo objects, we should create an interface which extends the CrudRepository interface. The source code of the TodoRepository interface looks as follows:

import org.springframework.data.repository.CrudRepository;

public TodoRepository extends CrudRepository<Todo, Long> {


Even though we haven’t added any methods to our repository interface, the CrudRepository interface declares many methods which are available to the classes that use our repository interface.

These methods are not our code because they are implemented and maintained by the Spring Data team. We only use them.

On the other hand, if we add a custom query method to our repository, the situation changes. Let’s assume that we have to find all todo entries whose title is equal to the given search term. After we have added this query method to our repository interface, its source code looks as follows:

import org.springframework.data.repository.CrudRepository;
import org.springframework.data.repository.query.Param;

public TodoRepository extends CrudRepository<Todo, Long> {

	@Query("SELECT t FROM Todo t where t.title=:searchTerm")
	public List<Todo> search(@Param("searchTerm") String searchTerm)

It would be easy to claim that this method is our own code and that is why we should test it. However, the truth is a bit more complex. Even though the JPQL query was written by us, Spring Data JPA provides the code which passes that query forward to the used JPA provider.

And still, I think that this query method is our own code because the most essential part of it was written by us.

If we want to identify our own data access code, we have to locate the essential part of each method. If this part was written by us, we should treat that that method as our own code.

This is all pretty obvious, and the more interesting question is:

Should We Test It?

Our repository interface provides two kinds of methods to the classes which use it:

  1. It provides methods that are declared by the CrudRepository interface.
  2. It provides a query method that was written by us.

Should we write integration tests to the TodoRepository interface and test all of these methods?

No. We should not do this because

  1. The methods declared by the CrudRepository interface are not our own code. This code is written and maintained by the Spring Data team, and they have ensured that it works. If we don’t trust that their code works, we should not use it.
  2. Our application probably has many repository interfaces which extend the CrudRepository interface. If we decide to write tests to the methods declared by the CrudRepository interface, we have to write these tests to all repositories. If we choose this path, we will spend a lot of time writing tests to someone else’s code, and frankly, it is not worth it.
  3. Our own code might be so simple that writing tests to our repository makes no sense.

In other words, we should concentrate on finding an answer to this question:

Should we write integration tests to our repository methods (methods which were written by us), or should we just write end-to-end tests?

The answer to this question depends from the complexity of our repository method. I am aware that complexity is a pretty vague word, and that is why we need a some kind of guideline that will help us to find the best way of testing our repository methods.

One way to make this decision is to think about the amount of work which is required to test the every possible scenario. This makes sense because:

  1. It takes less work to write integration tests to a single repository method than to write the same tests to the feature that uses the repository method.
  2. We have to write end-to-end anyway.

That is why it makes sense to minimize our investment (time) and maximize our profits (test coverage). We can do this by following these rules:

  • If we can test all possible scenarios by writing only a few tests, we shouldn’t waste our time for writing integration tests to our repository method. We should write end-to-end tests which ensure that the feature is working as expected.
  • If we need to write more than a few tests, we should write integration tests to our repository method, and write only a few end-to-end tests (smoke tests).


This blog post has taught us two things:

  • We should not waste our time for writing tests to a data access framework (or library) written by someone else. If we don’t trust that framework (or library), we should not use it.
  • Sometimes we should not write integration tests to our data access code either. If the tested code is simple enough (we can cover all situations by writing a few tests), we should test it by writing end-to-end tests.

Want to know how to develop your skillset to become a Java Rockstar?

Join our newsletter to start rocking!

To get you started we give you our best selling eBooks for FREE!


1. JPA Mini Book

2. JVM Troubleshooting Guide

3. JUnit Tutorial for Unit Testing

4. Java Annotations Tutorial

5. Java Interview Questions

6. Spring Interview Questions

7. Android UI Design


and many more ....


Receive Java & Developer job alerts in your Area

I have read and agree to the terms & conditions


Petri Kainulainen

Petri is passionate about software development and continuous improvement. He is specialized in software development with the Spring Framework and is the author of Spring Data book.
Notify of

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Inline Feedbacks
View all comments
Back to top button