Sample project for Spring Data JDBC with Azure Database for PostgreSQL

This sample project is used in the Use Spring Data JDBC with Azure Database for PostgreSQL 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-jdbc-postgresql
export AZ_DATABASE_NAME=XXXXXX-tmp-spring-jdbc-postgresql
export AZ_LOCATION=eastus
export AZ_POSTGRESQL_USERNAME=spring
export AZ_POSTGRESQL_PASSWORD=XXXXXXXXXXXXXXXXXXX
export AZ_LOCAL_IP_ADDRESS=$(curl http://whatismyip.akamai.com/)

export SPRING_DATASOURCE_URL=jdbc:postgresql://$AZ_DATABASE_NAME.postgres.database.azure.com:5432/demo
export SPRING_DATASOURCE_USERNAME=spring@$AZ_DATABASE_NAME
export SPRING_DATASOURCE_PASSWORD=$AZ_POSTGRESQL_PASSWORD

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

Once this file is created:

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