plan for the migration

[qianwens]

run .github\prompts\appmod-kit.create-plan.prompt.md to migrate this app to azure

[qianwens]

Plan Creation Succeeded ✅

The modernization plan has been successfully created and is ready for review.

Branch: 001-migrate-photoalbum-to-azure
Plan Location: .github/modernization/001-migrate-photoalbum-to-azure/plan.md

Plan Summary

Modernization Goal: Migrate the PhotoAlbum Java application to Azure cloud platform with modern Azure services, including upgrading to the latest Java version, migrating from Oracle Database to Azure Database for PostgreSQL, containerizing the application, and deploying to Azure Container Apps.

Task Breakdown (7 Tasks)

1. Upgrade Spring Boot to 3.x (Java Upgrade)

Upgrade Spring Boot from 2.7.18 to 3.x, which includes upgrading JDK to 17, Spring Framework to 6.x, and migrating from JavaEE (javax.) to Jakarta EE (jakarta.)

2. Migrate from Oracle DB to PostgreSQL (Migration To Azure)

Migrate the database from Oracle Database to Azure Database for PostgreSQL, including converting Oracle-specific SQL dialects, BLOB storage to BYTEA, and updating JDBC driver and configuration

3. Migrate from Plaintext Credentials to Azure Key Vault (Migration To Azure)

Remove hardcoded database credentials from application.properties and migrate them to Azure Key Vault for secure storage and access

4. Migrate to Azure Database for PostgreSQL with Managed Identity (Migration To Azure)

Configure the application to use Managed Identity for passwordless authentication to Azure Database for PostgreSQL, eliminating the need for credential management

5. Enable Session Persistence with Azure Cache for Redis (Migration To Azure)

Migrate from local in-memory session storage to Azure Cache for Redis for distributed session management, enabling horizontal scaling and high availability

6. Migrate to Console Logging (Migration To Azure)

Migrate from file-based logging to console logging to support cloud-native applications and enable integration with Azure Monitor and Application Insights

7. Deploy to Azure (Deploy)

Generate Azure infrastructure files (Bicep templates) for Azure Container Apps, Azure Database for PostgreSQL, Azure Cache for Redis, and Azure Key Vault. Deploy the containerized application to Azure Container Apps with all required Azure resources.

Architecture Transition

Current: Java 8 + Spring Boot 2.7.18 + Oracle Database 21c XE (Docker)
Target: Java 17 + Spring Boot 3.x + Azure Database for PostgreSQL + Azure Container Apps + Azure Cache for Redis + Azure Key Vault

Next Steps

Review the plan in .github/modernization/001-migrate-photoalbum-to-azure/plan.md and use /appmod-kit.run-plan to execute the modernization tasks.