mysql-employees-persistence

Jakarta Persistence for the Employees Sample Database.

---

API Versions

platform / framework	version	notes
Jakarta Persistence	Jakarta Persistence 3.2
Jakarta Persistence	Jakarta Persistence 3.1
Spring Boot Dependency Versions (current)	:jakarta.persistence-api:3.1.0
Spring Boot Dependency Versions (3.2.5)	:jakarta.persistence-api:3.1.0
Spring Boot Dependency Versions (3.2.4)	:jakarta.persistence-api:3.1.0

---

JDK

The latest LTS is required to build/run this module.

$ grep \<maven\\.compiler\\. pom.xml
    <maven.compiler.source>21</maven.compiler.source>
    <maven.compiler.target>${maven.compiler.source}</maven.compiler.target>
    <maven.compiler.release>${maven.compiler.target}</maven.compiler.release>
    <maven.compiler.testSource>${maven.compiler.source}</maven.compiler.testSource>
    <maven.compiler.testTarget>${maven.compiler.testSource}</maven.compiler.testTarget>
    <maven.compiler.testRelease>${maven.compiler.testTarget}</maven.compiler.testRelease>

Apache Maven

• Introduction to the Standard Directory Layout
• Introduction to Build Profiles

Directory Layout

$ tree -d -L 2 --charset=ascii src
src
|-- main
|   |-- java
|   |-- java-application
|   |-- java-application-jakarta-ee
|   |-- java-application-spring-boot
|   |-- java-persistence
|   |-- java-querydsl
|   |-- resources
|   |-- resources-application
|   |-- resources-application-jakarta--ee
|   |-- resources-application-spring-boot
|   |-- resources-persistence
|   `-- resources-querydsl
`-- test
    |-- java
    |-- java-application
    |-- java-application-jakarta-ee
    |-- java-framework-quarkus
    |-- java-framework-spring-boot
    |-- java-persistence
    |-- java-querydsl
    |-- resources
    |-- resources-application
    |-- resources-application-jakarta-ee
    |-- resources-application-spring-boot
    |-- resources-framework-quarkus
    |-- resources-persistence
    |-- resources-querydsl
    `-- sql

Profiles

• ✅ - should be selected
• ✓ - either one should be selected

Profiles	Java	Jakarta Persistence	Querydsl	Jakarta EE	Spring Boot	Notes
application				✅	✅
application-jakarta-ee				✅
application-spring-boot					✅
failsafe		✅	✅	✅	✅	for ITs
persistence		✅	✅
persistence-eclipselink		✓	✓
persistence-hibernate		✓	✓
querydsl			✅
querydsl-5			✓
querydsl-6			✓

e.g.

## Java
$ mvn clean test

## Jakarta Persistence + EclipseLink
$ mvn -Pfailsafe,persistence,persistence-eclipselink clean verify 

## Jakarta Persistence + Hibernate + Querydsl
$ mvn -Pfailsafe,persistence,persistence-hibernate,querydsl,querydsl-5 clean verify 

## Spring Data JPA 
$ mvn -Pfailsafe,application,application-spring-boot clean verify 

---

Docker

Build the image

$ sh ./.docker.build.sh

We don't have to repeat this job unless the Dockerfile changed.

Run the image as a container

$ sh ./.docker.run.sh

We'd better to wait a few seconds for the MySQL engine is fully up and running.

Connect to the running container

$ sh ./.docker.connect.sh

Stop the container

$ sh ./.docker.stop.sh

---

Links

Employees Sample Database

• 3 Installation
  • Employees DB on GitHub
• 5 Employees Structure

Jakarta Annotations

Jakarta Annotations 3.0

• Jakarta Annotations 3.0 Specification Document (PDF)
• Jakarta Annotations 3.0 Specification Document (HTML)
• Jakarta Annotations 3.0 Javadoc

Jakarta Persistence

Jakarta Persistence 3.2

• Jakarta Persistence 3.2 Specification Document
• Jakarta Persistence 3.2 Javadoc

Jakarta Persistence 3.1

• Jakarta Persistence 3.1 Specification Document
• Jakarta Persistence 3.1 Javadoc

EclipseLink

• EclipseLink Documentation Center

EclipseLink JPA

• EclipseLink JPA Extensions Reference
• Bug 328730 - Query.setMaxResults(0) returns unexpected results
• Using Weaving

eclipse-ee4j/eclipselink

Hibernate

Hibernate ORM

hibernate/hibernate-orm

---

Querydsl

• Apidocs
  • com.querydsl:querydsl-core
  • com.querydsl:querydsl-jpa
• Querydsl Reference Guide
  • 2.1. Querying JPA

OpenFeign/querydsl

• Why forking?
• [#274] About this fork!

---

Spring

Spring Boot

• Spring Boot Reference Documentation
  • Common Application Properties
  • Dependency Versions

Spring Data JPA

Jakarta EE

Jakarta EE Platform

Jakarta EE Web Profile

Jakarta EE Web Profile 10

• Jakarta Web Profile 10 Specification Document
• [Jakarta Web Profile 10 Javadoc](Jakarta Web Profile 10 Specification Document)
• Jakarta EE 10 Compatible Implementations

Jakarta EE Core Profile

Quarkus

• Using Hibernate ORM and Jakarta Persistence
• Simplified Hibernate ORM with Panache

GitHub

Bealdung

• JPA Entity Graph

---