Skip to main content
summaryrefslogtreecommitdiffstats
blob: 443a642fcc8002c51a1691580932f5c3f3b8f706 (plain) (blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
<!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>Joining Strategy</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-01-03T9:24:55Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Joining Strategy" />
<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 class="betadraftsubtitle">Beta Draft: 2013-01-03</p>
<p><a id="CACIJEGI" name="CACIJEGI"></a></p>
<div class="sect3"><!-- infolevel="all" infotype="General" -->
<h1><a id="sthref586" name="sthref586"></a><a id="sthref587" name="sthref587"></a>Joining Strategy</h1>
<p>Use this area to specify a mapped column for joining an entity association. By default, the mapping is assumed to have a single join.</p>
<div class="inftblhruleinformal">
<table class="HRuleInformal" summary="JPA Details view, Type page" dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
<col width="29%" />
<col width="*" />
<col width="24%" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t45">Property</th>
<th align="left" valign="bottom" id="r1c2-t45">Description</th>
<th align="left" valign="bottom" id="r1c3-t45">Available for Mapping Type</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t45" headers="r1c1-t45">
<p><span class="bold">Mapped by</span></p>
</td>
<td align="left" headers="r2c1-t45 r1c2-t45">
<p>The field in the database table that "owns" the relationship. This field is required only on the non-owning side of the relationship.</p>
</td>
<td align="left" headers="r2c1-t45 r1c3-t45">
<p><a href="tasks016.htm#BABEIEGD">Many-to-many mapping</a>, <a href="tasks018.htm#BABHGEBD">One-to-many mapping</a>, and <a href="tasks019.htm#BABFHBCJ">One-to-one mapping</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t45" headers="r1c1-t45">
<p>Attribute</p>
</td>
<td align="left" headers="r3c1-t45 r1c2-t45"><br /></td>
<td align="left" headers="r3c1-t45 r1c3-t45"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t45" headers="r1c1-t45">
<p><span class="bold">Primary key join columns</span></p>
</td>
<td align="left" headers="r4c1-t45 r1c2-t45"><br /></td>
<td align="left" headers="r4c1-t45 r1c3-t45">
<p><a href="tasks019.htm#BABFHBCJ">One-to-one mapping</a></p>
<br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t45" headers="r1c1-t45">
<p><span class="bold">Join columns</span></p>
</td>
<td align="left" headers="r5c1-t45 r1c2-t45">
<p><a id="sthref588" name="sthref588"></a><a id="sthref589" name="sthref589"></a>By default, the name is assumed to be the primary tables associated with the entities concatenated with an underscore.</p>
<p>Select <span class="bold">Override Default</span>, then Add, Edit, or Remove the join columns.</p>
</td>
<td align="left" headers="r5c1-t45 r1c3-t45">
<p><a href="tasks017.htm#BABHFAFJ">Many-to-one mapping</a>, <a href="tasks018.htm#BABHGEBD">One-to-many mapping</a>, and <a href="tasks019.htm#BABFHBCJ">One-to-one mapping</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t45" headers="r1c1-t45">
<p><span class="bold">Join table</span></p>
</td>
<td align="left" headers="r6c1-t45 r1c2-t45"><br /></td>
<td align="left" headers="r6c1-t45 r1c3-t45">
<p><a href="tasks016.htm#BABEIEGD">Many-to-many mapping</a>, <a href="tasks017.htm#BABHFAFJ">Many-to-one mapping</a>, <a href="tasks018.htm#BABHGEBD">One-to-many mapping</a>, and <a href="tasks019.htm#BABFHBCJ">One-to-one mapping</a></p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t45" headers="r1c1-t45">
<p>Name</p>
</td>
<td align="left" headers="r7c1-t45 r1c2-t45">
<p>Name of the join table that contains the foreign key column.You must specify the join table on the owning side.</p>
<p>By default, the name is assumed to be the primary tables associated with the entities concatenated with an underscore.</p>
</td>
<td align="left" headers="r7c1-t45 r1c3-t45"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t45" headers="r1c1-t45">
<p>Schema</p>
</td>
<td align="left" headers="r8c1-t45 r1c2-t45">
<p>Schema of the table</p>
</td>
<td align="left" headers="r8c1-t45 r1c3-t45"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t45" headers="r1c1-t45">
<p>Catalog</p>
</td>
<td align="left" headers="r9c1-t45 r1c2-t45">
<p>Catalog of the table</p>
</td>
<td align="left" headers="r9c1-t45 r1c3-t45"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r10c1-t45" headers="r1c1-t45">
<p>Join columns</p>
</td>
<td align="left" headers="r10c1-t45 r1c2-t45">
<p>The foreign key columns of the join table which reference the primary table of the entity <span class="italic">owning</span> the association. (that is, the <span class="italic">owning</span> side of the association).</p>
</td>
<td align="left" headers="r10c1-t45 r1c3-t45"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r11c1-t45" headers="r1c1-t45">
<p>Inverse join columns</p>
</td>
<td align="left" headers="r11c1-t45 r1c2-t45">
<p>The foreign key columns of the join table which reference the primary table of the entity that <span class="italic">does not</span> own the association. (that is, the <span class="italic">inverse</span> side of the association).</p>
</td>
<td align="left" headers="r11c1-t45 r1c3-t45"><br /></td>
</tr>
</tbody>
</table>
<br /></div>
<!-- class="inftblhruleinformal" --></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