Spring Boot + jOOQ Tutorial - 5 : Fetching Many-to-Many Relationships

Spring Boot + jOOQ Tutorial - 5 : Fetching Many-to-Many Relationships

In the previous tutorial, we have learned how to fetch One-to-Many relationships using jOOQ. In this tutorial, we will learn how to fetch Many-to-Many relationships using jOOQ. Source Code: You can find the complete source code of this project on GitHub: https://github.com/sivaprasadreddy/spring-boot-jooq-demo In our sample database, we have bookmarks and tags tables. Each bookmark can be associated with multiple bookmarks and vice-versa, so there is a Many-to-Many relationship between bookmarks and tags tables.

Continue reading »
Spring Boot + jOOQ Tutorial - 4 : Fetching One-to-Many Relationships

Spring Boot + jOOQ Tutorial - 4 : Fetching One-to-Many Relationships

In the previous tutorial, we have learned how to fetch One-to-One relationships using jOOQ. In this tutorial, we will learn how to fetch One-to-Many relationships using jOOQ. Source Code: You can find the complete source code of this project on GitHub: https://github.com/sivaprasadreddy/spring-boot-jooq-demo In our sample database, we have users and bookmarks tables. Each user can create multiple bookmarks, so there is a One-to-Many relationship between users and bookmarks tables. Let’s see how we can fetch a User details along with the bookmarks created by the user.

Continue reading »
Spring Boot + jOOQ Tutorial - 3 : Fetching One-to-One Relationships

Spring Boot + jOOQ Tutorial - 3 : Fetching One-to-One Relationships

In the previous tutorial, we have learned how to implement basic CRUD Operations using jOOQ. In this tutorial, we will learn how to fetch One-to-One relationships using jOOQ. Source Code: You can find the complete source code of this project on GitHub: https://github.com/sivaprasadreddy/spring-boot-jooq-demo Generally, when we are displaying a list of records, we will display minimal information about the record, and when the user clicks on the record, we will display the complete information about the record.

Continue reading »
Spring Boot + jOOQ Tutorial - 2 : Implementing CRUD Operations

Spring Boot + jOOQ Tutorial - 2 : Implementing CRUD Operations

In the previous tutorial, we have seen how to generate jOOQ code using the testcontainers-jooq-codegen-maven-plugin and use jOOQ Typesafe DSL to execute SQL queries. In this tutorial, we will learn how to implement basic CRUD Operations using jOOQ. Source Code: You can find the complete source code of this project on GitHub: https://github.com/sivaprasadreddy/spring-boot-jooq-demo In this tutorial, we will see how to perform basic CRUD (Create, Read, Update, Delete) operations on USERS table using jOOQ.

Continue reading »
Spring Boot + jOOQ Tutorial - 1 : Getting Started

Spring Boot + jOOQ Tutorial - 1 : Getting Started

jOOQ is a Java persistence library that provides SQL DSL for writing typesafe SQL queries. It supports most of the popular databases like MySQL, PostgreSQL, Oracle, SQL Server, and many more. In this tutorial, we will learn how to get started with jOOQ for implementing persistence layer in a Spring Boot application. You can also use jOOQ in other JVM based languages like Kotlin, Scala, etc. In this jOOQ tutorial series, you will learn how to use jOOQ in a Spring Boot application for implementing:

Continue reading »

SpringBoot : Working with JOOQ

In my previous article SpringBoot : Working with MyBatis we have learned how to use SpringBoot MyBatis Starter to quickly get up and running with Spring and MyBatis. In this article we are going to learn about how to use SpringBoot JOOQ Starter. JOOQ (JOOQ Object Oriented Querying) is a persistence framework which embraces SQL. JOOQ provides the following features: Building Typesafe SQL using DSL API Typesafe database object referencing using Code Generation Easy to use API for Querying and Data fetching SQL logging and debugging

Continue reading »