RE: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-17 Thread Martin Gainty
ffet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Sun, 17 Oct 2010 12:46:22 + > Subject: Re: Struts, Spring, Hibernate and multiple Sessionfactories &g

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-17 Thread Raymond He
1) In this multi-tenant app, it is OK. Every operation just need to access one tenant datasource in the thread .2) Thread local is not appropriate in distributed architecture. sometimes we should access 2 or more datasourses at the same time in ONE thread. 2010/10/16, Dave Newton

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-17 Thread Eduard Neuwirt
Raymond, I found a possible solution here: http://blog.springsource.com/2007/01/23/dynamic-datasource-routing TenantId is hold in the Struts UserSession and shall be shared with spring layer. The described solution uses ThreadLocal for this purpose. Is it possible to provide this tenantId to th

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-16 Thread Dave Newton
2010/10/16 Raymond He : > To Li Ying and Dave New ton, multiple datasources is a common > requirement in large scale e-commerce  and telecom application. I know; that's what I said. Dave - To unsubscribe, e-mail: user-unsubscr..

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-16 Thread Raymond He
To Li Ying and Dave New ton, multiple datasources is a common requirement in large scale e-commerce and telecom application. I used a data object to table mapping to do DB routing vertically, pk hashing to route horizontally. The r

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Brian Thompson
On Fri, Oct 15, 2010 at 11:43 AM, Dave Newton wrote: > On Fri, Oct 15, 2010 at 12:39 PM, Brian Thompson > wrote: >>> Ever had a client that wanted/required their data segregated from >>> everybody else's (this is not uncommon at all)? Ever wanted to >> Apparently, it is uncommon.  I've never enc

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Dave Newton
On Fri, Oct 15, 2010 at 12:39 PM, Brian Thompson wrote: >> Ever had a client that wanted/required their data segregated from >> everybody else's (this is not uncommon at all)? Ever wanted to > Apparently, it is uncommon.  I've never encountered such a demand. That... makes it uncommon?! >> restr

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Brian Thompson
On Fri, Oct 15, 2010 at 10:22 AM, Dave Newton wrote: >> I'm not sure what reasons there would be to have it make sense >> to store each entity in its own identically-structured DB. > > Ever had a client that wanted/required their data segregated from > everybody else's (this is not uncommon at all

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Dave Newton
> I'm not sure what reasons there would be to have it make sense > to store each entity in its own identically-structured DB. Ever had a client that wanted/required their data segregated from everybody else's (this is not uncommon at all)? Ever wanted to restrict tool access to data without jumpin

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Brian Thompson
On Fri, Oct 15, 2010 at 9:45 AM, Dave Newton wrote: > That's really difficult to read. Agreed. More whitespace would be nice, Martin. > > On Fri, Oct 15, 2010 at 10:38 AM, Martin Gainty wrote: >> a database schema represents the entire structure (tables and relationships >> of >> those table

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Dave Newton
That's really difficult to read. On Fri, Oct 15, 2010 at 10:38 AM, Martin Gainty wrote: > a database schema represents the entire structure (tables and relationships of > those tables) of the there is no need for multiple databases when your > database > schema contains the persisted entities (ta

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Frans Thamura
Every extend mapp to different injection to what lli ying said /m/ -Original Message- From: Eduard Neuwirt Date: Fri, 15 Oct 2010 16:37:56 To: Struts Users Mailing List; Subject: Re: Struts, Spring, Hibernate and multiple Sessionfactories Hi Frans, would you mind to explain it

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Li Ying
I think i don't understand what you want exactly. Can you tell me what you want to achieve? And what your code looks like? 2010/10/15 Eduard Neuwirt : > Hi Li, > > thanks for the answer. I didn't get how does it work within the > ? In this case ist the the question is how to access > to the app

RE: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Martin Gainty
> Date: Fri, 15 Oct 2010 14:50:17 +0200 > Subject: Struts, Spring, Hibernate and multiple Sessionfactories > From: eduard.neuw...@googlemail.com > To: user@struts.apache.org > > Hello, > > I am looking for an elegant solution for the following situation. > &g

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Eduard Neuwirt
- > From: Eduard Neuwirt > Date: Fri, 15 Oct 2010 16:16:35 > To: Struts Users Mailing List > Reply-To: "Struts Users Mailing List" > Subject: Re: Struts, Spring, Hibernate and multiple Sessionfactories > > Hi Li, > > thanks for the answer. I didn't get

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Frans Thamura
How about make different implementation So Tenant1 extends tenanta Tenant2 extends tenantb /m/ -Original Message- From: Eduard Neuwirt Date: Fri, 15 Oct 2010 16:16:35 To: Struts Users Mailing List Reply-To: "Struts Users Mailing List" Subject: Re: Struts, Spring, Hib

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Eduard Neuwirt
Hi Li, thanks for the answer. I didn't get how does it work within the struts-spring plugins ? In this case ist the the question is how to access to the application context directly from struts session. I could not find any information in the docu. Regards Eduard 2010/10/15 Li Ying > If you

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Li Ying
If you want to use multi-DB for multi-tenant (let's say tenant01 and tenant02) I think you can create config file should likes: and then, in your java code, you can get different bean instance for different tenant via [ID], code looks like: BeanFactory.getBean("sessionFactory_" + te

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Marshall Gunter
I have seen a horizontal partitioning of data using Hibernate that hides the SessionFactories, etc in a ConfigUtil class. The idea goes something like this. The ConfigUtil establishes all SessionFactories and stores them in a map with their associated identifier (ID, class, whatever you choose) as

Re: Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Li Ying
We developed a multi-tenant app last year. But we didn't separate their data into different DB. Instead, we stored all data in one DB, and add a [tenant_id] column to all tables to distinguish which tenant it belong. I think this is a simpler solution. When you need to add new tenant, you can s

Struts, Spring, Hibernate and multiple Sessionfactories

2010-10-15 Thread Eduard Neuwirt
Hello, I am looking for an elegant solution for the following situation. I have a multitenant struts/spring/hibernate application. Every tenant is stored in own database within the same RDBMS. All databases has the same schema. At the spring layer every tenant is represented as a datasource. Beca