jpa mysql 表名 前缀,Spring Boot + JPA + Hibernate不同的表名前缀

I am working on a multi-tenanted application (with old database structure) where I have a common user table and set of tables based on the access permission.

For example if the user can work with invoice of different companies C1 and C2, the database contains a tables with name C1_invoice and C2_invoice.

I am able to achieve adding prefix with one company using org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

So I can access C1_invoice table. But how can I choose the prefix C1 or C2 dynamically?

解决方案

You could use a variation of this approach.

It is basically using hibernate's multitenancy features in Spring Data by providing a custom MultiTenantConnectionProvider. The connection provider reads connection details from a map of data sources. You could provide a different value for the hibernate.physical_naming_strategy in each of the data sources. I'm not sure if there's a way to specify the prefix for each data source as a property, though. You could end up with a separate subclass of the PhysicalNamingStrategy for each tenant. Could be gruesome.

What DB are you using? Alternatively, you could resolve the issue by providing a schema per each tenant, and aliasing their tables from the default schema using unprefixed names, something along the lines of:

CREATE SYNONYM C1.INVOICE FOR DEFAULT.C1_INVOICE;

This way, you could use Hibernate's standard MultitenancyStrategy.SCHEMA strategy.