Since being back in 2009, has become one of the most popular databases of choice for developers over the past decade. While many technologists have likely gravitated to it as a solution due to its open source roots and that it's rooted in the relational database world, that really only begins to scratch the surface of what MariaDB has to offer. forked from MySQL MariaDB Over the years MariaDB has diverged from MySQL by adding many features and functionality, much of which we won't be able to dive into within the context of this article. However, one thing, above all else, has remained the same; providing a modern, open-source, high quality database solution that developers can use to power their innovation. But before you can dive into MariaDB and check out all it has to offer you'll need to answer the most fundamental of questions; how do you get started using MariaDB? MariaDB and Java Database Connectivity ( ) JDBC It likely comes as no surprise that , and ultimately the environment as a whole, has been an extremely popular option used by developers to create applications. Java Java Virtual Machine (JVM) With that in mind, I've written this short walkthrough to take you through the steps for getting started with using a image, ava and the . MariaDB (Community Server) Docker J MariaDB JDBC client In this walkthrough you'll be utilizing MariaDB and JDBC to create a simple ( based) "To do" application that, using , will expose a variety of endpoints to use to perform basic CRUD (create-read-update-delete) operations on a MariaDB database instance. Maven Java Spring Let's get started! Requirements Before jumping into code, you're going to need to make sure you have a few things on your machine: MariaDB client Docker Java (v. 8+) (for testing the API endpoints) Curl Creating a new MariaDB instance using Docker One of the simplest ways to get started with MariaDB, regardless of which operating system you're using, is to pull the Docker , from Docker Hub, and use it create a new container. MariaDB Server image To do this simply open a terminal window and run the following: $ docker run -p 3306:3306 -d --name mariadb -eMARIADB_ROOT_PASSWORD=Password123! mariadb/server:10.4 That's it. You should now have a running instance of MariaDB. Pretty painless, right? You can confirm the instance within a Docker container by running the following: $ docker ps And you should see your container within the output. Connecting to MariaDB Now that you've got a running MariaDB Server instance within a new Docker container the next step will be to connect to and communicate with the database instance using the . MariaDB client There are many SQL clients available out in the wild. For simplicity's sake, I've chosen to demonstrate how to use the official MariaDB Client, but certainly feel free to use whatever client you prefer. Connect to your MariaDB instance by executing the following: $ mariadb --host 127.0.0.1 -P 3306 --user root -pPassword123! You should see something like the following, which means you've successfully connected to the MariaDB instance! Once you're connected you can create a new database. todo; CREATE DATABASE Then create a new table. todo.tasks ( ( ) AUTO_INCREMENT,
  description ( ) ,
  completed ,
  PRIMARY ( )
); CREATE TABLE id INT 11 unsigned NOT NULL VARCHAR 500 NOT NULL BOOLEAN NOT NULL DEFAULT 0 KEY id Getting Started with Java Spring, JDBC and MariaDB With a database instance spun up and schema created you're ready to create a new application. Java Create a Maven project Start by navigating to , which will enable you to create a new -based project. For this project you can enter the following criteria. https://start.spring.io Spring Maven Next, add the following dependencies: : A library that will eliminate having to create boiler plate code (e.g. getters, setters) within the domain objects. Lombok : A library to create and expose RESTful API endpoints. Spring Web : A library that provides abstractions to help eliminate boiler plate code for connecting to and communicating with databases. Spring Data JPA Finally, click the "GENERATE" button to create and download the project (contained within a .zip file) to a desired location on your machine. Add the MariaDB R2DBC connector Navigate to the location where you downloaded the new Maven project (.zip file) to, and unzip.  Then use a code editor to open the project, and open pom.xml. Add a new dependency for MariaDB's JDBC connector to the collection of dependencies. <dependency> <artifactId>mariadb-java-client< version> org.mariadb.jdbc < > groupId </ > groupId /artifactId>
   <version>2.6.0</ </ > dependency Preparing the data integration Now that you've created a project that contains all of the dependencies you'll need, it's to jump into the Java code. Typically, I like to start by creating the entity classes. Navigate to , create a new folder called "domain", and create a new file within it named "Task.java". /src/main/java/com/mariadb/todo Open "Task.java" and add the following code. com.mariadb.todo.domain; javax.persistence.*; lombok.Data; (name = ) { (strategy = GenerationType.IDENTITY) Integer id; String description; Boolean completed = ;
} package import import @Data @Entity @Table "tasks" public class Task @Id @GeneratedValue private private private false Next, create a new folder called "repositories" in , and create a new filed within it named "TaskRepository.java". /src/main/java/com/mariadb/todo Open "TaskRepository.java" and add the following code. com.mariadb.todo.repositories; com.mariadb.todo.domain.Task; org.springframework.data.repository.CrudRepository; {
} package import import public < , > interface TaskRepository extends CrudRepository Task Integer Like the name suggests the interface provides basic CRUD operations on a repository for a generic type (your Task class in this case) and the primary key type for that generic type. CrudRepository Create a data service Services can be used to manage the business logic of your application. The only service, TaskService, in this application is used for validating a Task object and integrating with the TaskRepository. Create a new folder called "services" in , and create a new filed within it named "TaskService.java". /src/main/java/com/mariadb/todo Open "TaskService.java" and add the following code. com.mariadb.todo.services; java.util.Optional; com.mariadb.todo.domain.Task; com.mariadb.todo.repositories.TaskRepository; org.springframework.beans.factory.annotation.Autowired; org.springframework.stereotype.Service; org.springframework.transaction.annotation.Transactional; { TaskRepository repository; { (task != && !task.getDescription().isEmpty()) { ;
        } ;
    } { .repository.findAll();
    } { .repository.save(task);
    } {
        Optional<Task> ot = .repository.findById(task.getId());
        Task t = ot.get();
        t.setDescription(task.getDescription());
        t.setCompleted(task.getCompleted()); .repository.save(t);
    } {
        Optional<Task> ot = .repository.findById(id);
        Task t = ot.get(); .repository.delete(t);
    }
} package import import import import import import // Registered as a Spring Service (Component) @Service public class TaskService // Automatically instantiate (via Spring IoC) @Autowired private // Boolean public isValid ( Task task) final if null return true return false // Get all records from the tasks table Iterable<Task> public getAllTasks () return this // Save a new task record Task public createTask ( Task task) final return this // Update an existing task record @Transactional Task public updateTask ( Task task) final this return this // Delete the task record by specified id @Transactional public void deleteTask ( id) final int this this Expose API endpoints Finally, you'll need to create a to expose four endpoints that can be used to perform the basic CRUD operations on your Tasks. controller Create a new folder called "controllers" in , and create a new filed within it named "TaskController.java". /src/main/java/com/mariadb/todo Open "TaskController.java" and add the following code. com.mariadb.todo.controllers; com.mariadb.todo.domain.Task; com.mariadb.todo.services.TaskService; org.springframework.beans.factory.annotation.Autowired; org.springframework.http.HttpStatus; org.springframework.http.ResponseEntity; org.springframework.web.bind.annotation.DeleteMapping; org.springframework.web.bind.annotation.GetMapping; org.springframework.web.bind.annotation.PostMapping; org.springframework.web.bind.annotation.PutMapping; org.springframework.web.bind.annotation.RequestBody; org.springframework.web.bind.annotation.RequestMapping; org.springframework.web.bind.annotation.RequestParam; org.springframework.web.bind.annotation.RestController; ( ) { TaskService service; () ResponseEntity<Iterable<Task>> get() { ResponseEntity.ok( .service.getAllTasks());
    } () { (service.isValid(task)) { ResponseEntity.ok( .service.createTask(task));
        } ResponseEntity.status(HttpStatus.I_AM_A_TEAPOT).build();
    } () { (service.isValid(task)) { ResponseEntity.ok( .service.updateTask(task));
        } ResponseEntity.status(HttpStatus.I_AM_A_TEAPOT).build();
    } () { (id > ) { .service.deleteTask(id); ResponseEntity.ok().build();
        } ResponseEntity.status(HttpStatus.I_AM_A_TEAPOT).build();
    }
} package import import import import import import import import import import import import import @RestController @RequestMapping "/api/tasks" public class TaskController @Autowired private // Get all tasks @GetMapping public return this // Create a new task @PostMapping ResponseEntity<Task> public post (@RequestBody Task task) if return this return // Update a task @PutMapping ResponseEntity<Task> public put (@RequestBody Task task) if return this return // Delete a task @DeleteMapping ResponseEntity<Void> public delete (@RequestParam id) int if 0 this return return Testing it out Now that everything has been constructed, it's time to test it out! First, build the application. $ mvn package And then run it. $ mvn spring-boot:run First, start by adding a new task to your to do list. $ curl --header \
  --request POST \
  --data \
  http: "Content-Type: application/json" '{"description":"A New Task"}' //localhost:8080/api/tasks While you can certainly query the database directly to confirm that a new task record has been added, where's the fun in that? Back to the API! $ curl https: //localhost:8080/api/tasks If all goes well you should receive the following JSON response: { : , : , : } "id" 1 "description" "A New Task" "completed" false Voilà, a fully reactive Java Spring application using JDBC and MariaDB! To view this code in its entirety check out the source . And if you're wondering "it'd sure be nice to see an implementation with a user interface", you're in luck! You can find a fully fleshed out implementation of a TODO application using and your choice of multiple API projects (R2DBC, JDBC, Node.js and Python) that integrate directly with MariaDB ! here React.js here Just getting started Now that you've successfully created a new Maven project using Spring Data JPA, JDBC and MariaDB, you have all the tools you need to get started creating fully reactive applications, utilizing the power of MariaDB, of your own!If you have any questions, suggestions or concerns with this blog post please let me know here or reach out to me directly on Twitter at !Thanks for taking the time to read this and happy coding! @probablyrealrob

Twitter

2022 - HackerNoon Contributor of the Year - Cicd

2022 - HackerNoon Contributor of the Year - Database

2022 - HackerNoon Contributor of the Year - Devops

2022 - HackerNoon Contributor of the Year - Mobile

2022 - HackerNoon Contributor of the Year - Open Source

2022 - HackerNoon Contributor of the Year - Sql

2022 - Ios Writer of the Year

Nominated for 2022 - HackerNoon Contributor of the Year - Cicd

Nominated for 2022 - HackerNoon Contributor of the Year - Open Source

Nominated for 2022 - Most Authentic Developer Advocate of the Year

Nominated for 2022 - Ios Writer of the Year

Nominated for 2022 - HackerNoon Contributor of the Year - Database

Nominated for 2022 - HackerNoon Contributor of the Year - Devops

Nominated for 2022 - HackerNoon Contributor of the Year - Sql

Nominated for 2022 - HackerNoon Contributor of the Year - Mobile

Developer Relations @ MariaDB

Too Long; Didn't Read

In your car, at home, or at work — Bosch technology shapes many areas of life.

How To Connect MariaDB Docker Containers with Java Spring And JDBC

How To Connect MariaDB Docker Containers with Java Spring And JDBC

Too Long; Didn't Read

Company Mentioned

Rob Hedgpeth

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

How To Connect MariaDB Docker Containers with Java Spring And JDBC

Too Long; Didn't Read

Company Mentioned

Rob Hedgpeth

About Author

TOPICS

THIS ARTICLE WAS FEATURED IN...

RELATED STORIES