Category: Spring Data

In Relational Database Management Systems (RDBMS), a stored procedure is a batch of prepared SQL code grouped as a logical unit that you store in the database. Stored procedures allow reusability of SQL code. In this post, I will explain how to call MySQL stored procedures from a Spring Boot application. Dependency For the application […]Continue reading

Consider a scenario where a database query matches over 1000 records. You need to display the query results to users. In this scenario, you probably won’t want to display all records on a single page. Instead,  you would want to display chunks of data of suitable sizes with high readability. To achieve this, you use […]Continue reading

If you need to quickly create a JPA-based repository layer, Spring Data JPA is the right choice. You define your repository interface by extending one of the Spring Data JPA Repository interfaces.  At runtime, Spring Data JPA will create your repository implementations with the common CRUD methods. You can then perform CRUD operations without writing […]Continue reading

Introduction In this article, we explained how to configure more than one data source in a Spring Boot Application. The source repository for the article uses CircleCI for CI builds. To build the source code, we needed to add a MySQL database for the JUnit integration tests. In this article, we will explain how to […]Continue reading

When you are developing Spring Boot applications with database interactions, you typically use Hibernate as the Object Relationship Mapping (ORM) tool. Instead of directly coupling your code with Hibernate, often you’d rather use Spring Data JPA, a Spring Framework project. Spring Data JPA makes implementation of the data access layer incredibly easy by abstracting most […]Continue reading