We are using hibernate 4.3 multiTenancy, hikaricp connection provider:
<property name="hibernate.multiTenancy" value="DATABASE"/>
<property name="hibernate.multi_tenant_connection_provider" value="multitenancy.HikariTenantConnectionProvider"/>
<property name="hibernate.tenant_identifier_resolver" value="multitenancy.ThreadLocalIdentifierResolver"/>
In all cases we want that container is managing our transactions using java ee ejb standard.
PROBLEMS: