Sample project for Spring Data JDBC with Azure Database for MySQL

This sample project is used in these documents.

1. Use Spring Data JDBC with Azure Database for MySQL.
2. Deploy a Spring application to Azure Spring Apps with a passwordless connection to an Azure database.

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-jdbc-mysql
export AZ_DATABASE_SERVER_NAME=XXXXXX-tmp-spring-jdbc-mysql
export AZ_DATABASE_NAME=XXXXXX-tmp-spring-db
export AZ_LOCATION=eastus
export AZ_MYSQL_USERNAME=spring
export AZ_MYSQL_PASSWORD=XXXXXXXXXXXXXXXXXXX
export AZ_LOCAL_IP_ADDRESS=$(curl http://whatismyip.akamai.com/)

export SPRING_DATASOURCE_URL=jdbc:mysql://$AZ_DATABASE_SERVER_NAME.mysql.database.azure.com:3306/$AZ_DATABASE_NAME?serverTimezone=UTC
export SPRING_DATASOURCE_USERNAME=spring@$AZ_DATABASE_SERVER_NAME
export SPRING_DATASOURCE_PASSWORD=$AZ_MYSQL_PASSWORD

You will need to set up a unique AZ_DATABASE_SERVER_NAME as well as a correctly secured AZ_MYSQL_PASSWORD.

Once this file is created:

• Use source env.sh to set up those environment variables
• Use ./create-spring-data-jdbc-mysql.sh to create your infrastructure
• Use ./destroy-spring-data-jdbc-mysql.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