r2dbc

TODO - Java Spring Boot (with R2DBC) API

• TODO - Java Spring Boot (with R2DBC) API
  • Requirements
  • Getting started with the app
    • Configure the code
    • Build the code
    • 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 the application.properties file from the folder resources folder.

Example implementation:

spring.r2dbc.url=r2dbc:mariadb://example.skysql.net:5001/todo
spring.r2dbc.username=DB00000001
spring.r2dbc.password=****************
spring.r2dbc.properties.sslMode=VERIFY_CA
spring.r2dbc.properties.serverSslCert=classpath:static/skysql_chain.pem

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

$ java -jar target/todo-r2dbc.jar

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.