Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 337323

Summary: Multi-tenant with shared schema support
Product: z_Archived Reporter: Guy Pelletier <guy.pelletier>
Component: EclipselinkAssignee: Nobody - feel free to take it <nobody>
Status: RESOLVED FIXED QA Contact:
Severity: enhancement    
Priority: P3 CC: douglas.clarke, eclipselink.orm-inbox, karenfbutzke, neil.hauge
Version: unspecified   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
URL: http://wiki.eclipse.org/EclipseLink/Development/Indigo/Multi-Tenancy
Whiteboard:
Bug Depends on:    
Bug Blocks: 337032, 341940, 343757    
Attachments:
Description Flags
Part 1 - metadata changes
none
Part 1 - metadata changes update
none
Part 2 - core changes with jpa tests
none
Part 3 - Validation exceptions, defaulting, logging and DDL support
none
Part 4 - Property definition and public access
none
Part 5 - More testing and validation
none
Part 6 - DDL testing
none
Part 7 - Added new query exception (when context property not set)
none
Part 8 - Moved multitenant XML element out of table up to entity level.
none
Part 9 - More testing and fixes for DeleteAll queries
none
Part 9 - More testing and fixes for DeleteAll queries
none
Part 9 - More testing and fixes for DeleteAll queries none

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