I think multiple DataDomains might be what you want, but I'm not 100% certain everything you are trying to do. Also, if you are just starting out, it might be worthwhile to use Cayenne 3.0M6.
mrg On Sun, Jul 26, 2009 at 10:51 AM, Andreas Hartmann <[email protected]>wrote: > Andreas Hartmann schrieb: > >> Andreas Hartmann schrieb: >> >>> Hi Cayenne users & devs, >>> >>> I'm currently designing the DB + ORM layer for a multi-tenant >>> application, using PostgreSQL 8.3 and Cayenne 2.0.4. >>> >>> After some research it looks like PostgreSQL schemas are a pretty decent >>> way to achieve the separation of the tenant data on the DB level. >>> Unfortunately, it looks like multiple schemas are not supported by Cayenne. >>> >> >> I just noticed that the DbEntity class has a schema property. Would the >> following approach work? >> >> Create a DB entity for each table in each schema, e.g. users_schema1, >> users_schema2 etc. >> >> To run a query: >> >> DbEntity entity = dataMap.getDbEntity("users_" + schemaName); >> SelectQuery query = new SelectQuery(entity, expression); >> > > It seems like this won't work because for each DB entity an object entity > (i.e. class) would be required. > > But I found the section on multiple DataDomains in the documentation. I > guess this is the way to go? > > > -- Andreas > > > -- > Andreas Hartmann, CTO > BeCompany GmbH > http://www.becompany.ch > Tel.: +41 (0) 43 818 57 01 > >
