Skip to content

This repository contains code samples for getting started with Java and MariaDB.

License

Notifications You must be signed in to change notification settings

mariadb-developers/java-quickstart

Repository files navigation

Quick Start: Java and MariaDB

License

This repository contains examples on how to connect to MariaDB databases using a combination of different Java libraries and frameworks.

Before you run the examples

  1. Make sure you have a MariaDB Server (Enterprise or Community) running. If you don't have a MariaDB server running, you can easily run one using Docker:
docker run --name mariadb --detach --publish 3306:3306 --env MARIADB_ROOT_PASSWORD='RootPassword123!' mariadb

Alternatively, you can Download and install the server directly on your OS.

  1. Connect to the database using the MariaDB CLI client:
mariadb -h 127.0.0.1 -u root -p'RootPassword123!'

Alternatively, you can use any database client compatible with MariaDB.

  1. Prepare the database schema and user as follows:
CREATE DATABASE demo;
CREATE USER 'user'@'%' IDENTIFIED BY 'Password123!';
GRANT SELECT, INSERT, UPDATE, DELETE, DROP ON demo.* TO 'user'@'%';

CREATE TABLE demo.programming_language(
	pl_id INT PRIMARY KEY AUTO_INCREMENT,
	pl_name VARCHAR(50) NOT NULL UNIQUE,
	pl_rating INT
);

JDBC & JPA

Spring Boot

  • Spring Boot Data JPA: Spring-based programming model for data access on top of JPA.
  • R2DBC ➚: Reactive database connectivity.
  • jOOQ: Type-safe SQL queries in Java.
  • MyBatis: Map SQL results to Java methods in a simple way.

Jakarta EE (Java EE)

Quarkus

(work in progress)