Re: [hibernate-dev] multi-tenancy and ConnectionProvider

reference http://opensource.atlassian.com/projects/hibernate/browse/HHH-5697 For multi-tenancy implemented by sepaerate schema we need the ability to tell the ConnectionProvider about the tenant for the given getConnection() request. I really see 3 approaches to this: 1) Have 2 hierarchies here. The current ConnectionProvider contract remains the same. Add a new MultiTenantConnectionProvider with methods accounting for tenant 2) Just alter the ConnectionProvider contract to pass information in. If we go this route I prefer the "parameter object" pattern where we pass in ConnectionOptions interface (see issue). 3) Use contextual lookup. ConnentionProviders interested in (or capable of understanding) mulit-tenancy would perform some kind of "contextual" (ThreadLocal, etc) lookup for the needed information. Thoughts? Discussions? --- Steve Ebersole <steve(a)hibernate.org&gt; http://hibernate.org _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev