DataNucleus JIRA is now in read-only mode. Raise any new issues in GitHub against the plugin that it applies to. DataNucleus JIRA will remain for the foreseeable future but will eventually be discontinued
Issue Details (XML | Word | Printable)

Type: New Feature New Feature
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Unassigned
Reporter: Andy Jefferson
Votes: 0
Watchers: 0

If you were logged in you would be able to see more operations.
DataNucleus Store RDBMS

Support "multi-tenancy"/"multi-user" via discriminator

Created: 31/Aug/11 05:47 PM   Updated: 03/Oct/11 07:38 AM   Resolved: 06/Sep/11 11:13 AM
Component/s: Schema
Affects Version/s: None
Fix Version/s: 3.0.2

 Description  « Hide
JDO (and JPA) allows multi-tenancy using separate schema for each "tenant". We could alternately support it via a discriminator column on all tables, so any INSERTs/UPDATEs/DELETEs will pass in the tenant id, and any SELECTs will add the tenant restriction in the WHERE clause

Sort Order: Ascending order - Click to sort in descending order
Andy Jefferson added a comment - 06/Sep/11 11:13 AM
SVN trunk now has initial support for multi-tenancy for RDBMS. Specify persistence property
to the name of the tenant for this application instance and a discriminator column "TENANT_ID" will be added to all persistable class tables (not join tables).

Can't currently configure the column name ("TENANT_ID"), or type of tenant id (always String) - raise separate JIRA for those