title: Query tables across multiple tenants (same table name)
body: <p>I have a system where there is an unknown number of tenants (different database instances on same database server). I have working code where a user logs in and the correct tenant is selected, and I can read the configuration table for that tenant.</p>
  
  <p>I want the application at start time to loop through all tenants, read the configuration and act upon it. Prior to moving to Spring Data JPA (backed by hibernate) this was easy as I was connecting to each database instance separately.</p>
  
  <p>I don't think I can use Spring's <code>@Transactional</code> as it only sets up a single connection.</p>
  
  <p>I hope to use the same repository interface with the same bean, as this works when i only need to hit one tenant at a time.</p>
  
  <p>I do have a <code>class MultiTenantConnectionProviderImpl extends AbstractDataSourceBasedMultiTenantConnectionProviderImpl</code> that will give me a dataSource for a given tenant, but I'm not sure how to use that in a <code>@Service</code> class's method?</p>