I would start two different Hibernate instances? This way you can control and tune each one individually, and also this ensures that each instance manages a different group of entities.

In terms of user code, I also believe it makes sense so that you don’t have to specify the tenant ID on the shared data - but it’s enforced on the shared data.

Unless I’m misunderstanding?