Hi Community,

Would it be possible to use multi tenant with Hibernate, but for each tenant I could choose which dialect to use?

I'm working on a project migration where each tenant is allowed to set up a database connection for different vendors (SQLServer, Oracle, PostgreSQL)

To implement multi tenant, I used MultiTenantConnectionProvider and CurrentTenantIdentifierResolver but, I did not see possibilities to inform the dialect by tenant.

I've also tried to implement a DialectResolver, but it has no relation to Multi Tenant.

Is there anything else I can do?


Thanks

I don't think so. The Dialect is related to the SessionFactory, and, when using multi-tenancy, there's only one SessionFactory, even if you use multiple tenants.

So, the only way to fix it is to create one SessionFactory for each Dialect, and link all tenants associated to a particular Dialect to its associated SessionFactory.

Okay, I'll evaluate the alternative.

Thank you !