Multiple clients in single DB
Multiple clients in single DB
- Subject: Multiple clients in single DB
- From: Dave Elsner <email@hidden>
- Date: Thu, 26 Apr 2007 11:33:09 +1000
Hi,
I have an WO5.3 application I want to deploy to five different
clients, all have the same DB (Oracle) schema but different data. I
would like to use a shared database with a new column in each table
"client" that has the client ID. Then override awakeFromInsertion for
all EOEntities to set the client ID and also add to the Application
constructor a loop that sets an EOQualifier on each entity in the
model limiting objects to the current client.
Questions:
* Is this the correct approach to solve this problem? (i.e not
wanting to update X number of identical DB schemas every-time a
change is made, keeping the data in the one location for reporting)
* I tried EOEntity.setRestrictingQualifier but that overrides any
single table inheritance setup in the model. Is there away to merge
two EOQualifiers?
Cheers
Dave
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden