ODSA for Java Developers (Part 2) — Connecting to Oracle ADB from a Spring Boot 3.0 App with Spring Data JPA on Azure App Service

Oracle Database Service for Microsoft Azure (ODSA)

by Juarez Junior

Introduction

Part 1 in this series introduced the Oracle Database Service for Microsoft Azure (ODSA), its benefits concerning a multi-cloud strategy, and an example of accessing it from a Java application with the JDBC API.

This blog post will explore another scenario with ODSA and a Spring Boot 3.0 application with Spring Data JPA on Azure App Service.

Without further ado, let’s get started!

Prerequisites

• JDK — Java Development Kit 17
• Your preferred Java IDE — Eclipse, IntelliJ, VS Code
• Apache Maven
• Maven Plugin for Azure App Service
• Azure Subscription
• Oracle Database Service on Azure

Connect to your ADB instance on ODSA and run the DDL script

First, you must connect to the ADB instance on ODSA created in Part 1 of this series and execute the DDL script to create the tables for our sample Spring Boot application.