Sample project for Spring Data R2DBC with Azure SQL Database

This sample project is used in the Use Spring Data R2DBC with Azure SQL Database Microsoft documentation quickstart.

Creating the infrastructure

We recommend you create an env.sh file to create the following environment variables:

#!/bin/sh

echo "Setting env variables"

export AZ_RESOURCE_GROUP=tmp-spring-r2dbc-sql-server
export AZ_DATABASE_NAME=XXXXXX-spring-r2dbc-sql-server
export AZ_LOCATION=eastus
export AZ_SQL_SERVER_USERNAME=spring
export AZ_SQL_SERVER_PASSWORD=XXXXXXXXXXXXXXXXXXX
export AZ_LOCAL_IP_ADDRESS=$(curl http://whatismyip.akamai.com/)

export SPRING_R2DBC_URL=r2dbc:pool:mssql://$AZ_DATABASE_NAME.database.windows.net:1433/demo
export SPRING_R2DBC_USERNAME=spring@$AZ_DATABASE_NAME
export SPRING_R2DBC_PASSWORD=$AZ_SQL_SERVER_PASSWORD

You will need to set up a unique AZ_DATABASE_NAME as well as a correctly secured AZ_SQL_SERVER_PASSWORD.

Once this file is created:

• Use source env.sh to set up those environment variables
• Use ./create-spring-data-r2dbc-sql-server.sh to create your infrastructure
• Use ./destroy-spring-data-r2dbc-sql-server.sh to delete your infrastructure

Running the project

This is a standard Maven project, you can run it from your IDE, or using the provided Maven wrapper:

./mvnw spring-boot:run