Hi all,

Currently our company has ask us to implement a tenant per table strategy (f.i. eclipse link has that option). Looking through the options Hibernate provided are tenant per database and tenant per schema. De discriminator is not implemented but we have done that with a filter and that works as expected.

But now we must go to a situation that there is a set of tables with the tenant in the table name. We have looked to the naming strategy but that one is only called on startup. After that the table names are stored somewhere and can not be dynamic changed by a naming strategy.

A other possibility is to use StatementInspector (hibernate 5) but that is more of a workaround or a hack to change the query that goes to the database.

So is there a other possibility to having a table per tenant, so dynamically change the table name and add the tenant name into the tablename. (of cause this table must be created before it can be used.)

I guess it requires changes in the Hibernate core to accommodate a Table-based multi-tenancy strategy.
Since you already know the context, I think it's a good idea to create this new issue on the Hibernate Jira.

I've created https://hibernate.atlassian.net/browse/HHH-10665

Ok, thanks