Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "EclipseLink/Examples/JPA/Multitenant/Tutorial"
(→EclipseLInk Multi-Tenant Tutorial) |
(→@Multitenant(VPD)) |
||
Line 39: | Line 39: | ||
=== @Multitenant(VPD) === | === @Multitenant(VPD) === | ||
+ | |||
+ | In this stage of the tutorial you are going to switch from using EclipseLink's additional criteria being added to all queries to | ||
+ | |||
+ | ==== Setup Database ==== | ||
+ | |||
+ | In order to use Oracle VPD the user '''mttorial'' will need to have permission. This requires the user to have specific permissions or to have the DBA role. For simplicity in this tutorial you will simply grant the user the DBA role. |
Revision as of 11:26, 13 September 2011
EclipseLInk Multi-Tenant Tutorial
This tutorial will walk a developer through the steps necessary to take a simple domain model mapped with JPA and make it multitenant enabled with both EclipseLInk managed additional criteria as well as Oracle Virtual Private Database (VPD) usage.
Overview
- Setup and configure environment
- Run basic tests
- Configure for multi-tenancy using EclipseLink to apply additional tenant criteria
- Run multi-tenant tests
- Configure for multi-tenancy using EclipseLink and Oracle VPD
- Run multi-tenant VPD tests
Software Requirements
- EclipseLink 2.3.1 - build 20110910 or later
- Example application (SVN)
- Oracle Database
- Must support Oracle VPD
- Database user must have proper priviledges
Example Application
TO DO: Describe domain model and example usage
TO DO: Describe intented challenge of making app multi-tenant
Tutorial Steps
NOTE: Please follow the steps carefully.
This tutorial provides a sample application that is ready to run and includes JUnit tests which create the schema, populate the sample data, and run example persistence operations to verify proper functionality. At each stage of the tutorial a different set of tests will be run.
Setup
@Multitenant
@Multitenant(VPD)
In this stage of the tutorial you are going to switch from using EclipseLink's additional criteria being added to all queries to
Setup Database
In order to use Oracle VPD the user 'mttorial will need to have permission. This requires the user to have specific permissions or to have the DBA role. For simplicity in this tutorial you will simply grant the user the DBA role.