Using a List of Values in a JdbcTemplate IN Clause
1. Introduction In a SQL statement, we can use the IN operator to test whether an expression matches any value in a list. Therefore, we […]
JAVA
Spring JDBC
1. Overview In this tutorial, we’ll go through practical use cases of the Spring JDBC module. All the classes in Spring JDBC are divided into […]
Working with Kotlin and JPA
1. Introduction One of Kotlin’s characteristics is the interoperability with Java libraries, and JPA is certainly one of these. In this tutorial, we’ll explore how to use […]
MyBatis with Spring
1. Introduction MyBatis is one of the most commonly used open-source frameworks for implementing SQL databases access in Java applications. In this quick tutorial, we’ll present […]
DynamoDB in a Spring Boot Application Using Spring Data
1. Overview In this article, we’ll explore the basics of integrating DynamoDB into a Spring Boot Application with a hands-on, practical example project. We’ll demonstrate how to […]
Database Migrations with Flyway
1. Introduction This article describes key concepts of Flyway and how we can use this framework to continuously remodel our application’s database schema reliably and easily. At […]
Introduction to Liquibase Rollback
1. Overview In our previous article, we showed Liquibase as a tool for managing database schemas and data. In this article, we’re going to look more […]
Use Liquibase to Safely Evolve Your Database Schema
1. Overview In this quick tutorial, we’ll make use of Liquibase to evolve the database schema of a Java web application. We’re going to focus on a general […]
Performance Difference Between save() and saveAll() in Spring Data
1. Overview In this quick tutorial, we’ll learn about the performance difference between save() and saveAll() methods in Spring Data. 2. Application In order to test the performance, we’ll […]
Auditing with JPA, Hibernate, and Spring Data JPA
1. Overview In the context of ORM, database auditing means tracking and logging events related to persistent entities, or simply entity versioning. Inspired by SQL […]
Calling Stored Procedures from Spring Data JPA Repositories
1. Overview A stored procedure is a group of predefined SQL statements stored in the database. In Java, there are several ways to access stored procedures. In this […]
Sorting Query Results with Spring Data
1. Introduction In this tutorial, we’re going to learn how to sort query results with Spring Data. First, we’ll take a look at the schema of the data […]
Pagination and Sorting using Spring Data JPA
1. Overview Pagination is often helpful when we have a large dataset and we want to present it to the user in smaller chunks. Also, […]
Limiting Query Results with JPA and Spring Data JPA
1. Introduction In this tutorial, we’re going to learn about limiting query results with JPA and Spring Data JPA. First, we’ll take a look at the table we want to […]
Query Entities by Dates and Times with Spring Data JPA
1. Introduction In this quick tutorial, we’ll see how to query entities by dates with Spring Data JPA. We’ll first refresh our memory about how to […]
LIKE Queries in Spring JPA Repositories
1. Introduction In this quick tutorial, we’re going to cover various ways of creating LIKE queries in Spring JPA Repositories. We’ll start by looking at the […]
@DynamicUpdate with Spring Data JPA
1. Overview When we use Spring Data JPA with Hibernate, we can use the additional features of Hibernate as well. @DynamicUpdate is one such feature. @DynamicUpdate is a […]
Disable Spring Data Auto Configuration
1. Introduction In this quick tutorial, we’ll explore two different ways to disable database auto-configuration in Spring Boot, which can come in handy, say, when testing. […]
Spring Boot With H2 Database
1. Overview In this tutorial, we’ll explore using H2 with Spring Boot. Just like other databases, there’s full intrinsic support for it in the Spring […]
Spring Data JPA and Null Parameters
1. Overview In this article, we’ll show the ways of handling null parameters in Spring Data JPA. In some cases, when we search for records by parameters we want […]
