JavaStandalone

Database Per Service with Oracle AI Database Pluggable Databases

Database-per-service sample that separates students and courses services into independent pluggable databases.

TestcontainersSpring#Java#microservices#PDB#SpringBoot#Testcontainers
What this sample helps you learn

This sample demonstrates the database-per-service pattern on Oracle AI Database with a simple cross-service workflow: **course registration checks**.

What this sample demonstrates

Testcontainers

Disposable Oracle AI Database Free containers for repeatable local and integration tests.

Use when tests need real database behavior without sharing a long-lived development instance.

Spring

Runnable Spring behavior on Oracle AI Database.

Use when Spring needs to be tested against real database behavior.

Highlights

  • students/: student profile and completed-course history in studentpdb
  • courses/: course catalog, prerequisites, and term offerings in coursepdb
  • sample/: command-line runner and end-to-end test that compose data from both services over HTTP
  • students: university ID, name, status, and completed course codes