page_type	languages	products	description	urlFragment
sample	java	azure	This sample shows how to use Spring JDBC module with different Azure Database services.	spring-data-jdbc-on-azure

Spring Data JDBC on Azure

This sample shows how to use Spring JDBC module with different Azure Database services.

TOC

• Prerequisite
• Build and Package
• Run

Prerequisite

• Azure Account
• JDK 1.8 or above
• Maven 3.0 or above
• Curl
• Database Client
  • MySQL CLI
  • pgAdmin for PostgreSQL

Build and Package

You can build this sample with different Azure Database services. SQL Server, MySQL and PostgreSQL are supported by Azure. Follow below sections to use one of them.

• Azure Database for MySQL
• Azure Database for PostgreSQL
• Azure SQL Database

Azure Database for MySQL

1. Create an Azure Database for MySQL server by following tutorial at here.

2. Configure a firewall rule to allow your machine accessing the created MySQL server by following tutorial at here.

3. Use mysql to connect to your MySQL server and create a database named mysqldb by following tutorial at here.

4. Find application.properties at src/main/resources directory and fill in below properties.

   spring.datasource.url=<replace with your database server URL>
   spring.datasource.username=<replace with your database server username>
   spring.datasource.password=<replace with your database server password>
   

   NOTE spring.datasource.url should be in the form of jdbc:mysql://<MySQL Host>:3306/mysqldb?useSSL=true&requireSSL=false&serverTimezone=utc

5. Package the sample application by running below command.

   mvn package -P mysql

Azure Database for PostgreSQL

1. Create an Azure Database for PostgreSQL server by following tutorial at here.

2. Configure a firewall rule to allow your machine accessing the created PostgreSQL server by following tutorial at here.

3. Use pgAdmin to connect to your PostgreSQL server and create a database named mypgsqldb by following tutorial at here.

4. Find application.properties at src/main/resources directory and fill in below properties.

   spring.datasource.url=<replace with your database server URL>
   spring.datasource.username=<replace with your database server username>
   spring.datasource.password=<replace with your database server password>
   

   NOTE spring.datasource.url should be in the form of jdbc:postgresql://<PostgreSQL Host>:5432/mypgsqldb?ssl=true&sslmode=prefer

5. Package the sample application by running below command.

   mvn package -P postgresql

Azure SQL Database

1. Create an Azure SQL Database by following tutorial at here.

2. Create a firewall rule to allow your machine accessing the created Azure SQL Database by following tutorial at here.

3. Find application.properties at src/main/resources directory and fill in below properties.

   spring.datasource.url=<replace with your database server URL>
   spring.datasource.username=<replace with your database server username>
   spring.datasource.password=<replace with your database server password>
   

   NOTE spring.datasource.url should be in the form of jdbc:sqlserver://{SQL Host}:1433;database=sqldb;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;

4. Package the sample application by running below command.

   mvn clean package -P sql

Run

Following below steps to run and test the sample application.

1. Run application.

   java -jar target/spring-data-jdbc-on-azure-0.1.0-SNAPSHOT.jar

2. Create new users by running below command.

   curl -s -d '{"name":"Tom","species":"cat"}' -H "Content-Type: application/json" -X POST http://localhost:8080/pets
   curl -s -d '{"name":"Jerry","species":"mouse"}' -H "Content-Type: application/json" -X POST http://localhost:8080/pets

   Sample output is as below.

   Added Pet(id=1, name=Tom, species=cat).
   ...
   Added Pet(id=2, name=Jerry, species=mouse).
   

3. Get all existing pets by running below command.

   curl -s http://localhost:8080/pets

   Sample output is as below.

   [{"id":1,"name":"Tom","species":"cat"},{"id":2,"name":"Jerry","species":"mouse"}]