multi tenant - Difference between @multitenant(SINGLE_TABLE) and @multitenant(VPD) in EclipseLink -

Despite the fact, I search for a lot of things in the internet and read many articles, I still <<

Em> single_tables strategy and the VPD strategy of EclipseLink Firstly I thought "VPD" is the implementation of " different database strategy ", but then I found out that we used the same table for all the tenants in both strategies. Are there.

Can anyone explain the difference between two strategies?

The main difference is the level of filtering.

When using SINGLE_TABLE multitenancy, EclipseLink is responsible for adding tenant_id to all generated queries.

When using VPD , the filtering is performed at the database level. Therefore, eclipselink will generate SQL queries that do not include tenant_id , and will take care of database filtering.

Excerpt from VPD users themselves Allows to identify as a specific user, and will be able to 'see' specific data for that user.

To remove the need for sending special SQL, all results are limited at the level of the database.