Skip to main content

Multi-Tenancy, Schema Generation and Stored Procedures

Learn Multi-Tenancy, Schema Generation and Stored Procedures (Phase 9 · Advanced Hibernate (Advanced), Hibernate) with worked examples, diagrams and interview questions. Free on JavaSchoolLab.

Multi-tenancy • Multi-tenancy serves many customers (tenants) from one application. Isolation models: database per tenant (strongest isolation, costly), schema per tenant (good balance), shared schema with a discriminator column ( tenant_id ; cheapest, needs strict filtering; PostgreSQL Row Level Security adds protection). • Hibernate supports DATABASE/SCHEMA strategies with CurrentTenantIdentifierResolver (which tenant is this request?) and MultiTenantConnectionProvider (which connection/schema), and discriminator-based via @TenantId (Hibernate 6) or filters. • Keep the tenant in a...

More lessons in Phase 9 · Advanced Hibernate (Advanced)