Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 337323 - Multi-tenant with shared schema support
Summary: Multi-tenant with shared schema support
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 enhancement (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL: http://wiki.eclipse.org/EclipseLink/D...
Whiteboard:
Keywords:
Depends on:
Blocks: 337032 341940 343757
  Show dependency tree
 
Reported: 2011-02-16 10:38 EST by Guy Pelletier CLA
Modified: 2022-06-09 10:34 EDT (History)
4 users (show)

See Also:


Attachments
Part 1 - metadata changes (1.09 MB, patch)
2011-03-24 11:01 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 1 - metadata changes update (2.90 KB, patch)
2011-03-28 14:05 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 2 - core changes with jpa tests (76.64 KB, patch)
2011-04-01 13:51 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 3 - Validation exceptions, defaulting, logging and DDL support (29.62 KB, patch)
2011-04-05 11:48 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 4 - Property definition and public access (5.35 KB, patch)
2011-04-05 14:13 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 5 - More testing and validation (40.26 KB, patch)
2011-04-21 15:14 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 6 - DDL testing (44.99 KB, patch)
2011-04-27 15:38 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 7 - Added new query exception (when context property not set) (4.23 KB, patch)
2011-05-04 15:23 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 8 - Moved multitenant XML element out of table up to entity level. (20.22 KB, patch)
2011-05-18 08:59 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 9 - More testing and fixes for DeleteAll queries (63.93 KB, patch)
2011-05-30 16:14 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 9 - More testing and fixes for DeleteAll queries (66.43 KB, patch)
2011-05-31 09:26 EDT, Guy Pelletier CLA
no flags Details | Diff
Part 9 - More testing and fixes for DeleteAll queries (66.13 KB, patch)
2011-05-31 12:01 EDT, Guy Pelletier CLA
no flags Details | Diff

Note You need to log in before you can comment on or make changes to this bug.
Description Guy Pelletier CLA 2011-02-16 10:38:59 EST
Provide a way to allow multiple application tenants to share the same schema using tenant identifying column(s).
Comment 1 Guy Pelletier CLA 2011-02-16 10:40:01 EST
Documentation of this feature can be found here.

http://wiki.eclipse.org/EclipseLink/DesignDocs/Multi-Tenancy
Comment 2 Guy Pelletier CLA 2011-03-07 15:32:43 EST
Notice the new link:

http://wiki.eclipse.org/EclipseLink/Development/Indigo/Multi-Tenancy
Comment 3 Guy Pelletier CLA 2011-03-24 11:01:44 EDT
Created attachment 191830 [details]
Part 1 - metadata changes

Includes jpa metadata changes only (no core changes yet)

- New annotations
- New xml
- Processing support for both
- Schema version update
- Annotation test model
- XML test model
- Some refactoring
- Other minor clean up
Comment 4 Guy Pelletier CLA 2011-03-24 11:47:43 EDT
Part 1 has been submitted.

Reviewed by Chris Delahunt.
Comment 5 Guy Pelletier CLA 2011-03-28 14:05:17 EDT
Created attachment 192032 [details]
Part 1 - metadata changes update

removing javax.persistence dependency from the new tenant discriminator column annotation.
Comment 6 Guy Pelletier CLA 2011-04-01 13:51:30 EDT
Created attachment 192375 [details]
Part 2 - core changes with jpa tests

This is a milestone check in which allows front to back testing of this feature. 

Still some work to be done: validation, DDL generation and more testing and will come in a third patch.
Comment 7 Guy Pelletier CLA 2011-04-05 11:48:10 EDT
Created attachment 192571 [details]
Part 3 - Validation exceptions, defaulting, logging and DDL support
Comment 8 Guy Pelletier CLA 2011-04-05 14:13:59 EDT
Created attachment 192586 [details]
Part 4 - Property definition and public access
Comment 9 Guy Pelletier CLA 2011-04-06 09:10:39 EDT
Changes have been submitted.

Part 1 - reviewed by Chris Delahunt
Part 2 - reviewed by Gordon Yorke
Part 3 - reviewed by Tom Ware
Part 4 - reviewed by Tom Ware
Comment 10 Guy Pelletier CLA 2011-04-21 15:14:09 EDT
Created attachment 193872 [details]
Part 5 - More testing and validation
Comment 11 Guy Pelletier CLA 2011-04-27 15:38:53 EDT
Created attachment 194201 [details]
Part 6 - DDL testing
Comment 12 Guy Pelletier CLA 2011-04-27 15:49:49 EDT
All changes have been submitted. Marking this bug as resolved/fixed.
Comment 13 Guy Pelletier CLA 2011-05-04 15:23:56 EDT
Created attachment 194759 [details]
Part 7 - Added new query exception (when context property not set)

Was re-using additional criteria exception which was confusing.
Comment 14 Guy Pelletier CLA 2011-05-18 08:59:56 EDT
Created attachment 195968 [details]
Part 8 - Moved multitenant XML element out of table up to entity level.
Comment 15 Guy Pelletier CLA 2011-05-18 09:07:50 EDT
Part 8 submitted

Verified by: Chris Delahunt

Existing extended test xml updated and all extended tests continue to pass
Comment 16 Guy Pelletier CLA 2011-05-30 16:14:20 EDT
Created attachment 196925 [details]
Part 9 - More testing and fixes for DeleteAll queries
Comment 17 Guy Pelletier CLA 2011-05-31 09:26:29 EDT
Created attachment 196981 [details]
Part 9 - More testing and fixes for DeleteAll queries
Comment 18 Guy Pelletier CLA 2011-05-31 12:01:39 EDT
Created attachment 196996 [details]
Part 9 - More testing and fixes for DeleteAll queries
Comment 19 Eclipse Webmaster CLA 2022-06-09 10:34:27 EDT
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink