Secure and Efficient Oracle DB Setup with Spring Boot and Testcontainers

Having one user for creating database objects (DDL) and another for application-level data operations (DML) has many benefits. It improves security, keeps things organized, and[...]

Hibernate Schema-based Multi-Tenancy using StatementInspector

When using schema-based multi-tenancy with Hibernate, a simple way to define the schema is using a MultiTenantConnectionProvider where we call SET SCHEMA on the connection.[...]

JPA Inheritance Strategies

Relational databases have tables and columns and object-oriented programming languages have classes and fields but they also provide inheritance.

JPA Enums: Mapping Strategies and Trade-Offs

With JPA it’s possible to map Java enums to columns in a database table using the Enumerated annotation.