mariadb-dev-example-places/api/r2dbc

Places - Java Spring Boot (with R2DBC) API

1. Requirements
2. Getting started with the app
   1. Configure the code
   2. Build the code
   3. Run the app

Requirements

This sample was created using the following techologies and they must be installed before proceeding.

• Java 8+
• Maven v.3+

Getting started with the app

Configure the code

Configure the MariaDB connection by changing a application.properties file to the Java project from the folder resources folder.

Example implementation:

spring.r2dbc.url=r2dbc:mariadb://sky000XXX.mdb000XXXX.db.skysql.net:5002/places?sslMode=ENABLE_TRUST
spring.r2dbc.username=DB0000XXXX
spring.r2dbc.password=*************
spring.r2dbc.pool.initial-size=5
spring.r2dbc.pool.max-size=10
spring.r2dbc.pool.max-idle-time=30m

Build the code

Once you have retrieved a copy of the code you're ready to build and run the project!

Build the project by executing the following CLI command:

$ mvn package

Run the app

Once you've pulled down the code and have verified built the project you're ready to run the application!

1. Execute the following CLI command

$ mvn spring-boot:run

The following steps also exist within the "Build and run" section of the root README, and are for startin the React.js project once this API project has been started.

2. Navigate to the ../../client folder and execute the following CLI command to start the React.js application.

$ npm install
$ npm start

3. Open a browser window and navigate to http://localhost:3000.