IBM E02HMLL-I Implementation Guide - Page 163

Validating, database, connection, pools, Modifying

Get IBM E02HMLL-I - WebSphere Business Integration Server Express PDF manuals and user guides View all IBM E02HMLL-I manuals
Add to My Manuals
Save this manual to your list of manuals

Page 163 highlights

Figure 35. "Connection Pool" dialog 14. Click Finish. System Manager saves the database connection pool object and an icon appears under the Database Connection Pools folder in the integration component library. 15. Use the wizard to create another database connection pool at this time or click Cancel to close the wizard. Validating database connection pools After creating a database connection pool you should validate it to make sure it can be used by maps and collaborations at runtime. Do the following to validate a database connection pool: 1. Start the InterChange Server Express instance. 2. Connect System Manager to the InterChange Server Express instance. 3. Do one of the following: v Right-click either the database connection pool object in an integration component library or a shortcut to it in a user project, then select Validate Connection from the context menu, then select the InterChange Server Express instance name from the submenu. v Right-click either the database connection pool object in the server repository in the InterChange Server Express Component Management view, then select Validate Connection from the context menu. 4. If the database connection pool is valid then System Manager displays a prompt indicating that the validation was successful. If System Manager displays an error that validation was not successful, resolve the problem by verifying the availability of the database, the privileges of the user account specified, and the accuracy of the configuration information. Modifying database connection pools You can modify some properties of both database connection pools and database connection objects. To modify a database connection pool, do one of the following: v Right-click either the database connection pool component in an integration component library, or the shortcut to it a user project and select Properties from the context menu. v Select the database connection pool component in an integration component library, or the shortcut to it a user project and do one of the following: - Select Component > Properties from the menu bar. Chapter 8. Configuring database connection pools 151

  • 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
14.
Click
Finish
.
System
Manager
saves
the
database
connection
pool
object
and
an
icon
appears
under
the
Database
Connection
Pools
folder
in
the
integration
component
library.
15.
Use
the
wizard
to
create
another
database
connection
pool
at
this
time
or
click
Cancel
to
close
the
wizard.
Validating
database
connection
pools
After
creating
a
database
connection
pool
you
should
validate
it
to
make
sure
it
can
be
used
by
maps
and
collaborations
at
runtime.
Do
the
following
to
validate
a
database
connection
pool:
1.
Start
the
InterChange
Server
Express
instance.
2.
Connect
System
Manager
to
the
InterChange
Server
Express
instance.
3.
Do
one
of
the
following:
v
Right-click
either
the
database
connection
pool
object
in
an
integration
component
library
or
a
shortcut
to
it
in
a
user
project,
then
select
Validate
Connection
from
the
context
menu,
then
select
the
InterChange
Server
Express
instance
name
from
the
submenu.
v
Right-click
either
the
database
connection
pool
object
in
the
server
repository
in
the
InterChange
Server
Express
Component
Management
view,
then
select
Validate
Connection
from
the
context
menu.
4.
If
the
database
connection
pool
is
valid
then
System
Manager
displays
a
prompt
indicating
that
the
validation
was
successful.
If
System
Manager
displays
an
error
that
validation
was
not
successful,
resolve
the
problem
by
verifying
the
availability
of
the
database,
the
privileges
of
the
user
account
specified,
and
the
accuracy
of
the
configuration
information.
Modifying
database
connection
pools
You
can
modify
some
properties
of
both
database
connection
pools
and
database
connection
objects.
To
modify
a
database
connection
pool,
do
one
of
the
following:
v
Right-click
either
the
database
connection
pool
component
in
an
integration
component
library,
or
the
shortcut
to
it
a
user
project
and
select
Properties
from
the
context
menu.
v
Select
the
database
connection
pool
component
in
an
integration
component
library,
or
the
shortcut
to
it
a
user
project
and
do
one
of
the
following:
–
Select
Component
>
Properties
from
the
menu
bar.
Figure
35.
“Connection
Pool”
dialog
Chapter
8.
Configuring
database
connection
pools
151