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
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
|
<!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>Connection</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:56Z" />
<meta name="robots" content="noarchive" />
<meta name="doctitle" content="Connection" />
<meta name="relnum" content="Release 3.3" />
<meta name="partnum" content="Release 3.3" />
<meta name="topic-id" content="ref_persistence_connection" />
<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="CIAFFJIE" name="CIAFFJIE"></a><a id="ref_persistence_connection" name="ref_persistence_connection"></a></p>
<div class="sect3"><!-- infolevel="all" infotype="General" -->
<h1>Connection</h1>
<p><a id="sthref631" name="sthref631"></a>The following table lists the properties available in the Connection page of the <a href="ref_persistence_xmll_editor.htm#CIACCHID">persistence.xml Editor</a>.</p>
<div class="inftblhruleinformal">
<table class="HRuleInformal" summary="The following table lists the properties available in the Connection page of the persistence.xml Editor." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0">
<col width="25%" />
<col width="*" />
<col width="24%" />
<thead>
<tr align="left" valign="top">
<th align="left" valign="bottom" id="r1c1-t53">Property</th>
<th align="left" valign="bottom" id="r1c2-t53">Description</th>
<th align="left" valign="bottom" id="r1c3-t53">Default</th>
</tr>
</thead>
<tbody>
<tr align="left" valign="top">
<td align="left" id="r2c1-t53" headers="r1c1-t53">
<p>Transaction type<a id="sthref632" name="sthref632"></a></p>
</td>
<td align="left" headers="r2c1-t53 r1c2-t53">
<p>Specify if the connection for this persistence unit uses one of the following transaction types:</p>
<ul>
<li>
<p><span class="bold">Default</span> -- Select to use the container used by the container.</p>
</li>
<li>
<p><span class="bold">JTA</span> (Java Transaction API) -- Transactions of the Java EE server.</p>
</li>
<li>
<p><span class="bold">Resource Local</span> -- Native actions of a JDBC driver that are referenced by a persistence unit.</p>
</li>
</ul>
</td>
<td align="left" headers="r2c1-t53 r1c3-t53">
<p>JTA</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r3c1-t53" headers="r1c1-t53">
<p>Batch writing<a id="sthref633" name="sthref633"></a></p>
</td>
<td align="left" headers="r3c1-t53 r1c2-t53">
<p>Specify the use of batch writing to optimize transactions with multiple write operations.</p>
<p>Set the value of this property into the session at deployment time.</p>
<p><span class="bold">Note</span>: This property applies when used both in a Java SE and Java EE environment.</p>
<p>The following are the valid values for oracle.toplink.config.BatchWriting:</p>
<ul>
<li>
<p><span class="bold">JDBC</span>–Use JDBC batch writing.</p>
</li>
<li>
<p><span class="bold">Buffered</span>–Do not use either JDBC batch writing nor native platform batch writing.</p>
</li>
<li>
<p><span class="bold">OracleJDBC</span>–Use both JDBC batch writing and Oracle native platform batch writing.</p>
</li>
<li>
<p><span class="bold">None</span>–Do not use batch writing (turn it off).</p>
</li>
</ul>
</td>
<td align="left" headers="r3c1-t53 r1c3-t53">
<p>None</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r4c1-t53" headers="r1c1-t53">
<p>Statement caching</p>
</td>
<td align="left" headers="r4c1-t53 r1c2-t53">
<p>Specify if the query caches its JDBC statement. If enabled, you can also set the number of statements to cache.</p>
</td>
<td align="left" headers="r4c1-t53 r1c3-t53">
<p>50</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r5c1-t53" headers="r1c1-t53">
<p>Native SQL</p>
</td>
<td align="left" headers="r5c1-t53 r1c2-t53">
<p>Specify if Dali includes platform-specific (that is, "native") SQL statements. If false, Dali uses generic SLQ.</p>
</td>
<td align="left" headers="r5c1-t53 r1c3-t53">
<p>False</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r6c1-t53" headers="r1c1-t53">
<p><span class="bold">Database</span></p>
</td>
<td align="left" headers="r6c1-t53 r1c2-t53"><br /></td>
<td align="left" headers="r6c1-t53 r1c3-t53"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r7c1-t53" headers="r1c1-t53">
<p>JTA Data Source Name</p>
</td>
<td align="left" headers="r7c1-t53 r1c2-t53">
<p>If you selected <span class="bold">JTA</span> as the transaction type, then enter the name of the default JTA data source for the persistence unit.</p>
</td>
<td align="left" headers="r7c1-t53 r1c3-t53"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r8c1-t53" headers="r1c1-t53">
<p>Non-JTA Data Source Name</p>
</td>
<td align="left" headers="r8c1-t53 r1c2-t53">
<p>If you selected <span class="bold">Resource Local</span> as the transaction type, then enter the name of the non-JTA data source.</p>
<p>This property is not available for projects using the <span class="bold">Generic</span> platform.</p>
</td>
<td align="left" headers="r8c1-t53 r1c3-t53"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r9c1-t53" headers="r1c1-t53">
<p><span class="bold">EclipseLink connection pool</span></p>
</td>
<td align="left" headers="r9c1-t53 r1c2-t53">
<p>Define the connection pool driver, URL, user name and password.</p>
<p>These properties are note available for projects using the Generic platform.</p>
</td>
<td align="left" headers="r9c1-t53 r1c3-t53"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r10c1-t53" headers="r1c1-t53">
<p>Bind parameters</p>
</td>
<td align="left" headers="r10c1-t53 r1c2-t53">
<p>Control whether or not the query uses parameter binding.</p>
<p>Note: This property applies when used in a Java SE environment.</p>
<p>This property is not available for projects using the Generic platform.</p>
</td>
<td align="left" headers="r10c1-t53 r1c3-t53">
<p>True</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r11c1-t53" headers="r1c1-t53">
<p>Read Connection</p>
</td>
<td align="left" headers="r11c1-t53 r1c2-t53">
<p>The maximum and minimum number of connections allowed in the JDBC read connection pool.</p>
<p><span class="bold">Note</span>: These property apply when used in a Java SE environment.</p>
<p>These properties are not available for projects using the Generic platform</p>
</td>
<td align="left" headers="r11c1-t53 r1c3-t53">
<p>Minimum: 2</p>
<p>Maximum 2</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r12c1-t53" headers="r1c1-t53">
<p>Write Connection</p>
</td>
<td align="left" headers="r12c1-t53 r1c2-t53">
<p>The maximum and minimum number of connections allowed in the JDBC read connection pool.</p>
<p><span class="bold">Note</span>: These property apply when used in a Java SE environment.</p>
<p>These properties are not available for projects using the Generic platform</p>
</td>
<td align="left" headers="r12c1-t53 r1c3-t53">
<p>Minimum: 5</p>
<p>Maximum 10</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r13c1-t53" headers="r1c1-t53">
<p><span class="bold">Exclusive connections</span></p>
</td>
<td align="left" headers="r13c1-t53 r1c2-t53">
<p>These fields are available only when <span class="bold">Transaction Type</span> is <span class="bold">Local Resource</span>.</p>
</td>
<td align="left" headers="r13c1-t53 r1c3-t53"><br /></td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r14c1-t53" headers="r1c1-t53">
<p>Exclusive connection mode</p>
</td>
<td align="left" headers="r14c1-t53 r1c2-t53">
<p>Specify when Dali performs reads through the write connection.</p>
<ul>
<li>
<p>Always – Create an exclusive isolated client session if reading an isolated entity, otherwise create an exclusive client session.</p>
</li>
<li>
<p>Isolated – Create an exclusive isolated client session if reading an isolated entity, otherwise raise an error.</p>
</li>
<li>
<p>Transactional – Create an isolated client session if some or all entities require isolated cache, otherwise create a client session.</p>
</li>
</ul>
</td>
<td align="left" headers="r14c1-t53 r1c3-t53">
<p>Transactional</p>
</td>
</tr>
<tr align="left" valign="top">
<td align="left" id="r15c1-t53" headers="r1c1-t53">
<p>Lazy connection acquisition</p>
</td>
<td align="left" headers="r15c1-t53 r1c2-t53">
<p>Specify if Dali acquires write connections lazily.</p>
</td>
<td align="left" headers="r15c1-t53 r1c3-t53">
<p>True</p>
</td>
</tr>
</tbody>
</table>
<br /></div>
<!-- class="inftblhruleinformal" -->
<a id="sthref634" name="sthref634"></a>
<p class="subhead2">Related references</p>
<ul>
<li>
<p><span class="italic">Java Persistence API (JPA) Extensions Reference for EclipseLink</span><br />
<code><a href="http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/toc.htm">http://www.eclipse.org/eclipselink/documentation/2.4/jpa/extensions/toc.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 © 2011, 2013, Oracle and/or its affiliates. All rights reserved.</span><br />
<a href="dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td>
</tr>
</table>
</div>
<!-- class="footer" -->
</body>
</html>
|
