Showing posts with the label Spring Data JDBC

Spring Boot + Spring Data JDBC + Microsoft SQL Server - Build REST CRUD APIs

In this section, we will learn how to develop a REST-style web service with  Spring Boot ,  Spring Data JDBC,  and  Microsoft SQL Server . GitHub repository link is provided at the end of this tutorial. You can download the source code.  *Before development, make sure that the Microsoft SQL server is installed on your machine -  SQL Server Downloads | Microsoft Technologies used: Spring Boot 3.0.2 Spring Data JDBC Java 17 Maven  Microsoft SQL Server Driver Microsoft SQL Server These are APIs that Spring Boot backend App will export: 1. Create database. First, you need to create a database in the Microsoft SQL Server.   CREATE DATABASE testdb; 2. Creating a simple spring boot web application: First, open the Spring initializr   Then, Provide the Group and Artifact name. We have provided Group name  and Artifact  spring-boot-spring-data-jdbc-sqlserver-crud . Here I selected the  Maven  project - language  Java 17  -  Spring Boot 3.0.2  and ad

Spring Data JDBC + Azure Database for PostgresSQL - Build REST CRUD APIs

Hello everyone, Hope you are doing well. In this tutorial, you will learn how to build REST CRUD APIs with  Spring Boot ,  Spring Data JDBC  and  Microsoft  Azure Database for PostgreSQL . A little bit of Background Azure Database for PostgreSQL Single Server Single Server is a fully managed database service with minimal requirements for customizations of the database. The single server platform is designed to handle most of the database management functions such as patching, backups, high availability, and security with minimal user configuration and control. The architecture is optimized to provide 99.99% availability on a single availability zone. It supports the community version of PostgreSQL 10 and 11. The service is generally available today in a wide variety of  Azure regions . More Info -  Azure Database for PostgreSQL Single Server | Microsoft Learn Spring Boot Spring Boot makes it easy to create stand-alone, production-grade Spring-based Applications that you can "just