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
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
|
/*-
* See the file LICENSE for redistribution information.
*
* Copyright (c) 2002, 2015 Oracle and/or its affiliates. All rights reserved.
*
* $Id$
*/
package com.sleepycat.db;
import com.sleepycat.db.internal.DbConstants;
import com.sleepycat.db.internal.DbEnv;
import com.sleepycat.db.internal.DbTxn;
/**
Specifies the attributes of a database environment transaction.
*/
public class TransactionConfig implements Cloneable {
/*
* For internal use, to allow null as a valid value for
* the config parameter.
*/
/**
Default configuration used if null is passed to methods that create a
transaction.
*/
public static final TransactionConfig DEFAULT = new TransactionConfig();
/* package */
static TransactionConfig checkNull(TransactionConfig config) {
return (config == null) ? DEFAULT : config;
}
private boolean bulk = false;
private boolean readUncommitted = false;
private boolean readCommitted = false;
private boolean noSync = false;
private boolean noWait = false;
private boolean snapshot = false;
private boolean sync = false;
private boolean writeNoSync = false;
private boolean wait = false;
/**
An instance created using the default constructor is initialized
with the system's default settings.
*/
public TransactionConfig() {
}
/**
Configure the transaction for read committed isolation.
<p>
This ensures the stability of the current data item read by the
cursor but permits data read by this transaction to be modified or
deleted prior to the commit of the transaction.
<p>
@param readCommitted
If true, configure the transaction for read committed isolation.
*/
public void setReadCommitted(final boolean readCommitted) {
this.readCommitted = readCommitted;
}
/**
Return if the transaction is configured for read committed isolation.
<p>
@return
If the transaction is configured for read committed isolation.
*/
public boolean getReadCommitted() {
return readCommitted;
}
/**
Configure the transaction for read committed isolation.
<p>
This ensures the stability of the current data item read by the
cursor but permits data read by this transaction to be modified or
deleted prior to the commit of the transaction.
<p>
@param degree2
If true, configure the transaction for read committed isolation.
<p>
@deprecated This has been replaced by {@link #setReadCommitted} to conform to ANSI
database isolation terminology.
*/
public void setDegree2(final boolean degree2) {
setReadCommitted(degree2);
}
/**
Return if the transaction is configured for read committed isolation.
<p>
@return
If the transaction is configured for read committed isolation.
<p>
@deprecated This has been replaced by {@link #getReadCommitted} to conform to ANSI
database isolation terminology.
*/
public boolean getDegree2() {
return getReadCommitted();
}
/**
Configure read operations performed by the transaction to return modified
but not yet committed data.
<p>
@param readUncommitted
If true, configure read operations performed by the transaction to return
modified but not yet committed data.
*/
public void setReadUncommitted(final boolean readUncommitted) {
this.readUncommitted = readUncommitted;
}
/**
Return if read operations performed by the transaction are configured to
return modified but not yet committed data.
<p>
@return
If read operations performed by the transaction are configured to return
modified but not yet committed data.
*/
public boolean getReadUncommitted() {
return readUncommitted;
}
/**
Configure read operations performed by the transaction to return modified
but not yet committed data.
<p>
@param dirtyRead
If true, configure read operations performed by the transaction to return
modified but not yet committed data.
<p>
@deprecated This has been replaced by {@link #setReadUncommitted} to conform to ANSI
database isolation terminology.
*/
public void setDirtyRead(final boolean dirtyRead) {
setReadUncommitted(dirtyRead);
}
/**
Return if read operations performed by the transaction are configured to
return modified but not yet committed data.
<p>
@return
If read operations performed by the transaction are configured to return
modified but not yet committed data.
<p>
@deprecated This has been replaced by {@link #getReadUncommitted} to conform to ANSI
database isolation terminology.
*/
public boolean getDirtyRead() {
return getReadUncommitted();
}
/**
Configure the transaction to not write or synchronously flush the log
it when commits.
<p>
This behavior may be set for a database environment using the
Environment.setMutableConfig method. Any value specified to this method
overrides that setting.
<p>
The default is false for this class and the database environment.
<p>
@param noSync
If true, transactions exhibit the ACI (atomicity, consistency, and
isolation) properties, but not D (durability); that is, database
integrity will be maintained, but if the application or system
fails, it is possible some number of the most recently committed
transactions may be undone during recovery. The number of
transactions at risk is governed by how many log updates can fit
into the log buffer, how often the operating system flushes dirty
buffers to disk, and how often the log is checkpointed.
*/
public void setNoSync(final boolean noSync) {
this.noSync = noSync;
}
/**
Return if the transaction is configured to not write or synchronously
flush the log it when commits.
<p>
@return
If the transaction is configured to not write or synchronously flush
the log it when commits.
*/
public boolean getNoSync() {
return noSync;
}
/**
Configure the transaction to not wait if a lock request cannot be
immediately granted.
<p>
The default is false for this class and the database environment.
<p>
@param noWait
If true, transactions will not wait if a lock request cannot be
immediately granted, instead {@link com.sleepycat.db.DeadlockException DeadlockException} will be thrown.
*/
public void setNoWait(final boolean noWait) {
this.noWait = noWait;
}
/**
Return if the transaction is configured to not wait if a lock
request cannot be immediately granted.
<p>
@return
If the transaction is configured to not wait if a lock request
cannot be immediately granted.
*/
public boolean getNoWait() {
return noWait;
}
/**
This transaction will execute with snapshot isolation. For databases
configured with {@link DatabaseConfig#setMultiversion}, data values
will be read as they are when the transaction begins, without taking
read locks.
<p>
Updates operations performed in the transaction will cause a
{@link DeadlockException} to be thrown if data is modified
between reading and writing it.
*/
public void setSnapshot(final boolean snapshot) {
this.snapshot = snapshot;
}
/**
Return true if the transaction is configured for Snapshot Isolation.
<p>
This method may be called at any time during the life of the application.
<p>
@return
True if the transaction is configured for Snapshot Isolation.
*/
public boolean getSnapshot() {
return snapshot;
}
/**
Configure the transaction to write and synchronously flush the log
it when commits.
<p>
This behavior may be set for a database environment using the
Environment.setMutableConfig method. Any value specified to this
method overrides that setting.
<p>
The default is false for this class and true for the database
environment.
<p>
If true is passed to both setSync and setNoSync, setSync will take
precedence.
<p>
@param sync
If true, transactions exhibit all the ACID (atomicity, consistency,
isolation, and durability) properties.
*/
public void setSync(final boolean sync) {
this.sync = sync;
}
/**
Return if the transaction is configured to write and synchronously
flush the log it when commits.
<p>
@return
If the transaction is configured to write and synchronously flush
the log it when commits.
*/
public boolean getSync() {
return sync;
}
/**
Configure the transaction to wait if a lock request cannot be
immediately granted.
<p>
The default is true unless {@link EnvironmentConfig#setTxnNoWait} is called.
<p>
@param wait
If true, transactions will wait if a lock request cannot be
immediately granted, instead {@link com.sleepycat.db.DeadlockException DeadlockException} will be thrown.
*/
public void setWait(final boolean wait) {
this.wait = wait;
}
/**
Return if the transaction is configured to wait if a lock
request cannot be immediately granted.
<p>
@return
If the transaction is configured to wait if a lock request
cannot be immediately granted.
*/
public boolean getWait() {
return wait;
}
/**
Configure the transaction to write but not synchronously flush the log
it when commits.
<p>
This behavior may be set for a database environment using the
Environment.setMutableConfig method. Any value specified to this method
overrides that setting.
<p>
The default is false for this class and the database environment.
<p>
@param writeNoSync
If true, transactions exhibit the ACI (atomicity, consistency, and
isolation) properties, but not D (durability); that is, database
integrity will be maintained, but if the operating system
fails, it is possible some number of the most recently committed
transactions may be undone during recovery. The number of
transactions at risk is governed by how often the operating system
flushes dirty buffers to disk, and how often the log is
checkpointed.
*/
public void setWriteNoSync(final boolean writeNoSync) {
this.writeNoSync = writeNoSync;
}
/**
Return if the transaction is configured to write but not synchronously
flush the log it when commits.
<p>
@return
If the transaction is configured to not write or synchronously flush
the log it when commits.
*/
public boolean getWriteNoSync() {
return writeNoSync;
}
/**
Configures the transaction to enable the transactional bulk insert
optimization. When this attribute is set, the transaction will avoid
logging the contents of insertions on newly allocated database pages.
In a transaction that inserts a large number of new records, the I/O
savings of choosing this option can be significant. Users of this
option should be aware of several issues. When the optimization is in
effect, page allocations that extend the database file are logged as
usual; this allows transaction aborts to work correctly, both online
and during recovery. At commit time, the database's pages are flushed
to disk, eliminating the need to roll-forward the transaction during
normal recovery. However, there are other recovery operations that
depend on roll-forward, and care must be taken when Bulk-enabled
transactions interact with them. In particular, Bulk is
incompatible with replication, and is simply ignored when replication
is enabled. Also, hot backup procedures must follow a particular
protocol, introduced in 11gr2.5.1, to set a flag in the environment
before starting to copy files. It is especially important to note
that incremental hot backups can be invalidated by use of the bulk
insert optimization. Please see the hot backup description in the
<i>Getting Started with Transactions Guide</i>, and the description of the
HotbackupInProgress attribute in
{@link com.sleepycat.db.EnvironmentConfig EnvironmentConfig}
for further information.
<p>
The bulk insert optimization is effective only for
top-level transactions.
<p>
@param bulk
If true, configure the transaction to enable the bulk optimization.
*/
public void setBulk(final boolean bulk) {
this.bulk = bulk;
}
/**
Return true if the Bulk attribute is set.
<p>
@return
The current setting of the Bulk attribute.
*/
public boolean getBulk() {
return this.bulk;
}
DbTxn beginTransaction(final DbEnv dbenv, final DbTxn parent)
throws DatabaseException {
int flags = 0;
flags |= readCommitted ? DbConstants.DB_READ_COMMITTED : 0;
flags |= readUncommitted ? DbConstants.DB_READ_UNCOMMITTED : 0;
flags |= noSync ? DbConstants.DB_TXN_NOSYNC : 0;
flags |= noWait ? DbConstants.DB_TXN_NOWAIT : 0;
flags |= snapshot ? DbConstants.DB_TXN_SNAPSHOT : 0;
flags |= sync ? DbConstants.DB_TXN_SYNC : 0;
flags |= wait ? DbConstants.DB_TXN_WAIT : 0;
flags |= writeNoSync ? DbConstants.DB_TXN_WRITE_NOSYNC : 0;
flags |= bulk ? DbConstants.DB_TXN_BULK : 0;
return dbenv.txn_begin(parent, flags);
}
}
|