On 2012-10-19, at 7:21 AM, Dov Rosenberg wrote: > Thanks everyone. With the emphasis on moving everything to the cloud this > type of capability is very desirable. Hibernate supports it. Jpa is making > progress toward it. > > I wish we could move to cayenne but I think we are going to get pushed to top > link eventually.
Isn't TopLink very much like WO? I recall looking at it some time before Oracle bought it and it seems like a near carbon copy. I could not understand why Apple did not sue them. Chuck > > Dov > > Sent from my iPhone > > On Oct 19, 2012, at 9:51 AM, Andrus Adamchik <[email protected]> wrote: > >> Or use Cayenne 3.1 ;) >> >> On Oct 19, 2012, at 4:16 PM, Pascal Robert <[email protected]> wrote: >> >>> Check: >>> >>> https://github.com/hprange/multi-tenant-prototype >>> >>> I think Michael Gargano is using it with good success. Check the "model >>> connections to multiple DBs" thread from April 2011 and "Different Database >>> Connection per session for the same model" from June 2012. >>> >>>> We are looking into converting our existing EOF based apps to support >>>> multi-tenancy. Today we can support multiple customers in a single schema >>>> using relationships to separate the data. EOF works fine in this model. We >>>> even implemented the multiple EOObjectStore coordinators for additional >>>> scalability. >>>> >>>> Has anyone figured out how to support separate schema based multi-tenancy >>>> with EOF? i.e. each customer gets a separate schema and requests for that >>>> customer load data from that schema only? I know we can deploy our app >>>> multiple times - each time pointing to a different schema. Ideally though >>>> we would be able to share binaries and swap schemas on a per request basis. >>>> >>>> I am thinking some mojo would have to occur along the lines of the >>>> following: >>>> >>>> • Load the EOModel once - this assumes that all customers would share >>>> the same DB structure >>>> • DO NOT pre-load any data at start up unless it is stored in per >>>> customer caches >>>> • As each request comes in - >>>> • identify the customer >>>> • either create a new connection or grab one from a pool. In the >>>> case of EOF I think that implies that there would be separate object store >>>> coordinators per customer >>>> • Hook the object store up with the model >>>> • execute the request >>>> • break everything back down >>>> >>>> Is this even possible with EOF/Project Wonder? >>>> >>>> Thanks >>>> >>>> Dov Rosenberg >>>> _______________________________________________ >>>> Do not post admin requests to the list. They will be ignored. >>>> Webobjects-dev mailing list ([email protected]) >>>> Help/Unsubscribe/Update your Subscription: >>>> https://lists.apple.com/mailman/options/webobjects-dev/probert%40macti.ca >>>> >>>> This email sent to [email protected] >>> >>> >>> _______________________________________________ >>> Do not post admin requests to the list. They will be ignored. >>> Webobjects-dev mailing list ([email protected]) >>> Help/Unsubscribe/Update your Subscription: >>> https://lists.apple.com/mailman/options/webobjects-dev/andrus%40objectstyle.org >>> >>> This email sent to [email protected] >> >> >> _______________________________________________ >> Do not post admin requests to the list. They will be ignored. >> Webobjects-dev mailing list ([email protected]) >> Help/Unsubscribe/Update your Subscription: >> https://lists.apple.com/mailman/options/webobjects-dev/dov%40cfl.rr.com >> >> This email sent to [email protected] > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/chill%40global-village.net > > This email sent to [email protected] -- Chuck Hill Senior Consultant / VP Development Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems. http://www.global-village.net/gvc/practical_webobjects Global Village Consulting ranks 13th in 2012 in BIV's Top 100 Fastest Growing Companies in B.C! Global Village Consulting ranks 76th in 24th annual PROFIT 200 ranking of Canada’s Fastest-Growing Companies by PROFIT Magazine! _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
