Skip to main content
summaryrefslogblamecommitdiffstats
blob: 494a975e9cb2aff7a7081bc6a765e63419a96298 (plain) (tree)
1
2
3
4
5
6
7
8
9
10



                                                                   
                                                                        

                                                                   
                           

                                                                                                                                                                                                                                                                                                                                                                      
                                                   
                                          
                                               

                                             

                                                                                               

       
                                            
                                                              
                     
                                                                                                                                                                                                                                                              
                                     
                                                                                                                                                                                                                       





                              



                                                                                  



                              

                                                  
     












                                               
     

                                             
     

                                                                                                           


                              

                                                  
     

                                                                                                                                                         
     
                                             

           

                                                                                                           


                              




































                                                                                                           
     


















                                                                                    

    
                

     
              

     
             


     




















                                                                                          
     











                                                                                               
     
                                                         




                                        
                                       





                                                                                           

                                                                                                                                                                                                          

     

                      


                                                                                          

                   
    
                                                                                                                                                                                      
                                                                                         


        
                       
       
      
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
    "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=us-ascii" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="Content-Script-Type" content="text/javascript" />
<title>Multitenancy</title>
<meta name="copyright" content="Copyright (c) 2000, 2009 oracle . All rights reserved. This program and the accompanying materials are made available under the terms of the Eclipse Public License v1.0 which accompanies this distribution, and is available at http://www.eclipse.org/legal/epl-v10.html. Contributors: Oracle - initial API and implementation" />
<meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 1.0.11" />
<meta name="date" content="2013-04-05T12:21:40Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Multitenancy" />
<meta name="relnum" content="Release 3.3" />
<meta name="partnum" content="Release 3.3" />
<link rel="copyright" href="dcommon/html/cpyr.htm" title="Copyright" type="text/html" />
<link rel="stylesheet" href="dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" />
</head>
<body>
<p><a id="CACDIJEE" name="CACDIJEE"></a></p>
<div class="sect3"><!-- infolevel="all" infotype="General" -->
<h1>Multitenancy</h1>
<p><a id="sthref500" name="sthref500"></a>Use the <span class="gui-object-title">Multitenancy</span> area in the <span class="gui-object-title">JPA Details</span> view to specify that a given entity is shared among multiple tenants of an application.</p>
<div class="inftblhruleinformalwide">
<table class="HRuleInformalWide" title="JPA Details view, Multienancy page" summary="JPA Details view, Multienancy page" dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
<col width="16%" />
<col width="*" />
<col width="17%" />
<col width="25%" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t30">Property</th>
<th align="left" valign="bottom" id="r1c2-t30">Description</th>
<th align="left" valign="bottom" id="r1c3-t30">Default</th>
<th align="left" valign="bottom" id="r1c4-t30">Available for Entity&nbsp;Type</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t30" headers="r1c1-t30">
<p>Multitenancy strategy</p>
</td>
<td align="left" headers="r2c1-t30 r1c2-t30">
<p>Specify the multitenant strategy to use:</p>
<ul>
<li>
<p>Single table</p>
</li>
<li>
<p>Table per tenant</p>
</li>
<li>
<p>VPD</p>
</li>
</ul>
</td>
<td align="left" headers="r2c1-t30 r1c3-t30">
<p>Single table</p>
</td>
<td align="left" headers="r2c1-t30 r1c4-t30">
<p><a href="tasks004.htm#BABGBIEE">Entity</a> and <a href="tasks006.htm#BABDAGCI">Mapped superclass</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t30" headers="r1c1-t30">
<p>Include criteria</p>
</td>
<td align="left" headers="r3c1-t30 r1c2-t30">
<p>Specify if the database requires the tenant criteria to be added to the <code>SELECT</code>, <code>UPDATE</code>, and <code>DELETE</code> queries.</p>
</td>
<td align="left" headers="r3c1-t30 r1c3-t30">
<p>True</p>
</td>
<td align="left" headers="r3c1-t30 r1c4-t30">
<p><a href="tasks004.htm#BABGBIEE">Entity</a> and <a href="tasks006.htm#BABDAGCI">Mapped superclass</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t30" headers="r1c1-t30">
<p><span class="bold">Tenant descriptor columns</span></p>
</td>
<td align="left" headers="r4c1-t30 r1c2-t30">
<p>Use to limit what a persistence context can access in single-table mulitenancy</p>
</td>
<td align="left" headers="r4c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r4c1-t30 r1c4-t30">
<p><a href="tasks004.htm#BABGBIEE">Entity</a> and <a href="tasks006.htm#BABDAGCI">Mapped superclass</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t30" headers="r1c1-t30">
<p>Override default</p>
</td>
<td align="left" headers="r5c1-t30 r1c2-t30"><br /></td>
<td align="left" headers="r5c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r5c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t30" headers="r1c1-t30">
<p>Name</p>
</td>
<td align="left" headers="r6c1-t30 r1c2-t30">
<p>The name of column to be used for the tenant discriminator.</p>
</td>
<td align="left" headers="r6c1-t30 r1c3-t30">
<p>eclipselink.tenant-id</p>
</td>
<td align="left" headers="r6c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t30" headers="r1c1-t30">
<p>Table</p>
</td>
<td align="left" headers="r7c1-t30 r1c2-t30">
<p>The name of the table that contains the column.</p>
</td>
<td align="left" headers="r7c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r7c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t30" headers="r1c1-t30">
<p>Context property</p>
</td>
<td align="left" headers="r8c1-t30 r1c2-t30">
<p>The name of the context property to apply to the tenant discriminator column.</p>
</td>
<td align="left" headers="r8c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r8c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t30" headers="r1c1-t30">
<p>Discriminator type</p>
</td>
<td align="left" headers="r9c1-t30 r1c2-t30">
<p>The type of object/column to use as a class discriminator:</p>
<ul>
<li>
<p>Character</p>
</li>
<li>
<p>Integer</p>
</li>
<li>
<p>String</p>
</li>
</ul>
</td>
<td align="left" headers="r9c1-t30 r1c3-t30">
<p>String</p>
</td>
<td align="left" headers="r9c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r10c1-t30" headers="r1c1-t30">
<p>Length</p>
</td>
<td align="left" headers="r10c1-t30 r1c2-t30">
<p>The column length for String-based discriminator types.</p>
</td>
<td align="left" headers="r10c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r10c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r11c1-t30" headers="r1c1-t30">
<p>Column definition</p>
</td>
<td align="left" headers="r11c1-t30 r1c2-t30">
<p>The SQL fragment that is used when generating the DDL for the discriminator column.</p>
</td>
<td align="left" headers="r11c1-t30 r1c3-t30"><br /></td>
<td align="left" headers="r11c1-t30 r1c4-t30"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r12c1-t30" headers="r1c1-t30">
<p>Primary key</p>
</td>
<td align="left" headers="r12c1-t30 r1c2-t30">
<p>Specifies that the tenant discriminator column is part of the primary key of the tables.</p>
</td>
<td align="left" headers="r12c1-t30 r1c3-t30">
<p>False</p>
</td>
<td align="left" headers="r12c1-t30 r1c4-t30"><br /></td>
</tr>
</tbody>
</table>
<br /></div>
<!-- class="inftblhruleinformalwide" -->
<a id="sthref501" name="sthref501"></a>
<p class="subhead2">Related reference</p>
<ul>
<li>
<p><a href="ref_persistence_prop_view.htm#BABFAEBB">JPA Details view (for entities)</a></p>
</li>
<li>
<p>"Multitenant" in <span class="italic">Java Persistence API (JPA) Extensions Reference for EclipseLink</span>&nbsp;<br />
<code><a href="http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_multitenant.htm">http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/a_multitenant.htm</a></code></p>
</li>
</ul>
</div>
<!-- class="sect3" -->
<!-- Start Footer -->
<div class="footer">
<table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%">
<col width="86%" />
<col width="*" />
<tr>
<td align="left"><span class="copyrightlogo">Copyright&nbsp;&copy;&nbsp;2011, 2013,&nbsp;Oracle&nbsp;and/or&nbsp;its&nbsp;affiliates.&nbsp;All&nbsp;rights&nbsp;reserved.</span><br />
<a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td>
</tr>
</table>
</div>
<!-- class="footer" -->
</body>
</html>

Back to the top