IBM E02HMLL-I Implementation Guide - Page 165

Deleting, database, connection, objects, Using, pools, collaborations, Configuring, transaction,

Page 165 highlights

2. In the "New Connection Pool" pane, right-click the connection object for which you want to change the minimum number of connections and select Edit from the context menu. 3. Type the new value in the Minimum connections field. 4. Click OK. Deleting database connection objects Do the following to delete a database connection object: 1. Access the properties of the database connection pool as described in "Modifying database connection pools" on page 151. 2. In the "New Connection Pool" pane, right-click the connection object you want to delete and select Delete from the context menu. 3. Click OK. Using database connection pools in collaborations and maps To use database connection pools in maps and collaboration templates, you use the getDBConnection() method in the BaseCollaboration class: CwDBConnection getDBConnection(String ConnectionPoolName); The string ConnectionPoolName must match exactly a pool name that you have created or will create in System Manager. If the name does not match exactly, or if you set connection pool name values in a collaboration template or map but do not create the database connection pool in System Manager, the collaboration object or map will fail. For collaborations, you can set pool names in a template either before or after you have created the collaboration objects from that template; you do not need to reconfigure new collaboration objects to match a new connection pool name. For more information on developing collaboration templates to use database connection pools, see the Collaboration Development Guide. For more information on developing maps to use database connection pools, see the Map Development Guide. Configuring transaction bracketing You can configure a collaboration or a map to use database connection pools in either Implicit Database Transaction mode (in which the transaction begins as soon as the connection is made and ends when the process is finished) or Explicit Database Transaction mode (in which you begin and end the transaction programmatically). To configure transaction bracketing for collaboration objects, see "Implicit database transaction" on page 168. To configure transaction bracketing for maps, see the Map Development Guide. Chapter 8. Configuring database connection pools 153

  • 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

2.
In
the
“New
Connection
Pool”
pane,
right-click
the
connection
object
for
which
you
want
to
change
the
minimum
number
of
connections
and
select
Edit
from
the
context
menu.
3.
Type
the
new
value
in
the
Minimum
connections
field.
4.
Click
OK
.
Deleting
database
connection
objects
Do
the
following
to
delete
a
database
connection
object:
1.
Access
the
properties
of
the
database
connection
pool
as
described
in
“Modifying
database
connection
pools”
on
page
151.
2.
In
the
“New
Connection
Pool”
pane,
right-click
the
connection
object
you
want
to
delete
and
select
Delete
from
the
context
menu.
3.
Click
OK
.
Using
database
connection
pools
in
collaborations
and
maps
To
use
database
connection
pools
in
maps
and
collaboration
templates,
you
use
the
getDBConnection()
method
in
the
BaseCollaboration
class:
CwDBConnection
getDBConnection(String
ConnectionPoolName
);
The
string
ConnectionPoolName
must
match
exactly
a
pool
name
that
you
have
created
or
will
create
in
System
Manager.
If
the
name
does
not
match
exactly,
or
if
you
set
connection
pool
name
values
in
a
collaboration
template
or
map
but
do
not
create
the
database
connection
pool
in
System
Manager,
the
collaboration
object
or
map
will
fail.
For
collaborations,
you
can
set
pool
names
in
a
template
either
before
or
after
you
have
created
the
collaboration
objects
from
that
template;
you
do
not
need
to
reconfigure
new
collaboration
objects
to
match
a
new
connection
pool
name.
For
more
information
on
developing
collaboration
templates
to
use
database
connection
pools,
see
the
Collaboration
Development
Guide
.
For
more
information
on
developing
maps
to
use
database
connection
pools,
see
the
Map
Development
Guide
.
Configuring
transaction
bracketing
You
can
configure
a
collaboration
or
a
map
to
use
database
connection
pools
in
either
Implicit
Database
Transaction
mode
(in
which
the
transaction
begins
as
soon
as
the
connection
is
made
and
ends
when
the
process
is
finished)
or
Explicit
Database
Transaction
mode
(in
which
you
begin
and
end
the
transaction
programmatically).
To
configure
transaction
bracketing
for
collaboration
objects,
see
“Implicit
database
transaction”
on
page
168.
To
configure
transaction
bracketing
for
maps,
see
the
Map
Development
Guide
.
Chapter
8.
Configuring
database
connection
pools
153