Prev Next

Hibernate / EclipseLink Interview questions

How do you implement multitenancy in EclipseLink?

EclipseLink supports multitenancy natively through the @Multitenant annotation, which lets multiple tenants' data coexist while keeping each tenant's queries automatically scoped to only their own rows.

@Entity
@Multitenant(MultitenantType.SINGLE_TABLE)
@TenantDiscriminatorColumn(name = "TENANT_ID", contextProperty = "tenant.id")
public class Invoice {

    @Id
    private Long id;

    private BigDecimal amount;
}

The most common strategy, SINGLE_TABLE, stores all tenants in one shared table with a discriminator column, and EclipseLink automatically appends the tenant filter to every query based on a context property (like tenant.id) supplied when the EntityManager is created. Other strategies include TABLE_PER_TENANT, where each tenant gets a physically separate table, and, for Oracle databases specifically, integration with Virtual Private Database (VPD) to enforce tenant isolation at the database layer itself.

Because the tenant context is tied to the property supplied at EntityManager creation, mixing tenant data within a single persistence context isn't possible by design, which is exactly the safety property multitenancy support is meant to guarantee.

The @Multitenant annotation with SINGLE_TABLE strategy stores tenant data:
For Oracle databases, EclipseLink can additionally integrate with:

More Related questions...

What is EclipseLink? What is JPA (Jakarta Persistence API)? What is the relationship between EclipseLink and Jakarta Persistence? What is a Persistence Unit in EclipseLink? What is persistence.xml used for? What is an EntityManager in EclipseLink? What is an EntityManagerFactory? What is a JPA entity? What are EclipseLink's core components? What is EclipseLink MOXy? What is class weaving in EclipseLink? What is the EclipseLink shared cache (L2 cache)? What is a fetch group in EclipseLink? What is optimistic locking in EclipseLink and JPA? What is the @Convert annotation used for? What is a Customizer in EclipseLink? What is JPQL? What are EclipseLink query hints? What is DDL generation in EclipseLink? What is a UnitOfWork in EclipseLink's native API? What is EclipseLink's native Session API? What is static weaving in EclipseLink? What are EclipseLink descriptors? What is EclipseLink DBWS? What is EclipseLink SDO? Explain the lifecycle of a JPA entity managed by EclipseLink? Why is class weaving important for lazy loading in EclipseLink? How does EclipseLink's shared cache differ from Hibernate's second-level cache? What is the difference between static weaving and dynamic weaving? How do you configure batch fetching using EclipseLink query hints? When should you use pessimistic locking instead of optimistic locking? How do you troubleshoot lazy loading failures caused by missing weaving in EclipseLink? What is the difference between EAGER and LAZY fetch strategies, and how does EclipseLink implement lazy loading without a live session? How does EclipseLink implement change tracking for detecting entity modifications? Explain the internal working of EclipseLink's cache coordination? What is the difference between EclipseLink and Hibernate? How do you implement multitenancy in EclipseLink? Why use fetch groups instead of always fetching the full entity? What is the difference between attribute change tracking and deferred change detection? How does EclipseLink cache query results, and what invalidation strategies are available? When would you choose isolated cache over shared cache for a multitenant entity? How do you configure a Customizer to add native EclipseLink mappings not expressible via annotations? What is the difference between JPQL and the EclipseLink native Expression/Criteria API? Explain the internal working of EclipseLink's Unit of Work commit process? How do you optimize EclipseLink performance for a high-throughput application? What is the difference between EclipseLink's @Convert and JPA's standard AttributeConverter? How does EclipseLink decide when to use join fetch versus batch fetch? Why should you use @Version for optimistic locking instead of manual version checks? What is the difference between EntityManager persistence context types: transaction-scoped vs extended? How do you troubleshoot stale data issues caused by EclipseLink's shared cache?
Show more question and Answers...


Comments & Discussions