I use Hibernate (with JPA) on a database strategy multitenancy. Each tenant has his own data in a separate datasource, which could be just amother schema on the same database or a schema located on a separate database.
Is it possible to use a particular dialect per datasource? This would enable the use of an Oracle datasource and a PostgreSQL datasource at the same time? This could be an interesting commercial option if possible.
Of course, native queries should not use any database specific functions if we want this setup.
Thanks for your tip.