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

Juarez Junior
Oracle Developers
Published in
9 min readDec 6, 2022

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

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.

Go to your ADB instance page, and click the Database Actions option, as highlighted below.

ODSA — ADBATPODSA instance -> Database Actions

A new window will open with its login page. Provide the Username and Password as usual, then click the Sign in button.

ODSA — ADB instance log in

On the next screen, select SQL.

ODSA — ADB DB Actions — SQL option

Copy the DDL script — ODSASpringBoot.sql — and execute it as required by clicking the Run Statement button as below. Make sure the password for the user ODSA_USER follows Oracle’s

Juarez Junior
Oracle Developers

Senior Principal #Java Developer Evangelist @ Oracle. Invite me to speak about #Java #OracleDatabase #OracleCloud #Blockchain #DevRel ☕️🥑

Recommended from Medium

Lists

See more recommendations