Blog
Spring Boot and JOOQ - Getting started

Spring Boot and JOOQ - Getting started

January 3, 2024

This article will show how to use jOOQ in your spring boot projects.

Why do we need jOOQ? There is a lot of pain using JPA and Hibernate. That is why we have something jOOQ.

First, we need to create a database schema. In this article, we will develop a simple CRUD (create, read, update, and delete) application to manage goods.

The first step is to design our database. The application will contain only one table — goods. The table looks like below.

GOODS
id
uuid
pk
ID
name
string
The name of good
price
numeric
The price of good
total_count
int
The total count of good
sold_count
int
The sold count of good
deleted
bool
The flag indicated that good was deleted

ERD
ERD

Access full article

Medium
Follow & read
 Substack
Subscribe & read

ko-fi

Status Hub

Status Hub is simple uptime monitoring for your business. Start your free trial today! Have a question? We are ready to answer!

Start your 2 weeks free trial
No credit card required
Have a question?
Ask us

JUnit 5 - How to write more test with less codeSpring Boot and gRPC - Boost your service communication