Home » IBM Manuals » Computer Software » IBM E02HMLL-I » Manual Viewer

IBM E02HMLL-I Implementation Guide - Page 161

Database, Driver, number, Connected, Servers, DBConnection, Login, Maximum, connections, Unlimited,

Add to My Manuals
Save this manual to your list of manuals

Page 161 highlights

The "Database Connection" dialog appears. Note: Although the name of the dialog would suggest that what you are creating at this point is a database connection, it is really a database connection pool. In later steps you will define database connections within the pool. 2. Select the appropriate value in the Database Driver drop-down menu-either DB2 (Type 2),or MQ SQL Server(Type 4)-depending on the database vendor. 3. If you chose MQ SQL Server(Type 4)in the Database Driver drop-down menu, then you must type the name of the computer on which the database server resides in the Host name field. 4. Type the name of the database in the Database field. 5. If you chose MQ SQL Server(Type 4)in the Database Driver drop-down menu, then you must type the port number through which clients communicate with the database server in the Port number field. 6. If you are connected to the InterChange Server Express instance that will use the pool, select that instance from the Connected Servers drop-down menu. 7. Type a name for the pool in the DBConnection Name field. You specify this database connection pool name when writing Java code to establish the connection in maps or collaboration templates. 8. Type the user name that should be used by InterChange Server Express to log in to the specified database in the Login field. 9. Type the password for the user name. 10. Type the maximum number of connections that should be established by the pool for all the individual database connection objects you plan to create within it in the Maximum connections field, or enable the Unlimited checkbox to allow as many connections to be established as are permitted by the database server configuration and licensing. Warning: Be careful when working in this field. It is not a single-line text field, even though it should be, so you can accidentally press Enter. You will not see the value you entered then, and will justifiably try to re-type the value. Then when you try to finish creating the database connection pool you receive an error that a valid value must be entered for the field. Do not press Enter in this field. Figure 34 on page 150 shows the "New Database Connection Pool" wizard. Chapter 8. Configuring database connection pools 149

Section	Page
Contents	5
New in this release	9
New in release 4.3	9
About this document	11
Audience	11
Related documents	11
Typographic conventions	11
Using this guide	12
Chapter 1. Overview of IBM WebSphere Business Integration Server Express	13
The InterChange Server Express model	13
Collaborations, business objects, and connectivity	13
Example implementation solutions	14
Data flow in an InterChange Server Express implementation	16
Publish-and-subscribe interactions	17
Access requests	17
Request/response interactions	17
Connectors	19
Connector communication with applications	19
Collaborations	19
Business objects	20
Roles of a business object	21
Structure of a business object	21
Application-specific and generic business objects	23
Binding between elements	25
Binding a trigger	25
Binding destinations	26
Data mapping	26
Types of data transformations	27
Communication transport infrastructure	28
CORBA	28
Messaging technologies	29
InterChange Server Express	29
Event management service	30
Connector controllers	30
Repository	30
Database connectivity service	30
Database connection pools	30
Transactional collaborations	30
Recovery features	31
Toolset Express	32
Development tools for specific components	32
Administrative and monitoring tools	32
Chapter 2. The development model and process	33
Concepts for the business integration system	33
Integration components	33
Interfaces	33
Solutions	33
Integration component libraries	34
User projects	34
InterChange Server Express instances	34
Stages in developing an implementation	34
Discovery and assessment of requirements	34
Preparation of environments	36
Design	36
Development and configuration	37
Validation	38
Deployment	39
Migration	39
Chapter 3. Developing business process interfaces	41
Sequence of development tasks	41
Obtain connectors	41
Develop or modify application-specific business objects	42
Configure connectors	42
Test connectivity and application-specific business objects	43
Develop or modify generic business objects	44
Configure database connection pools	45
Develop and test maps and relationships	45
Develop and test collaboration templates	45
Configure connectors for business object support and associated maps	47
Create and configure collaboration objects	47
Deploy the interface	47
Test the interface	47
Chapter 4. Using System Manager	49
About System Manager, Integrated Test Environment, and Collaboration Debugger	49
About the Eclipse Platform	49
About WSWB	51
About System Manager	51
About Integrated Test Environment	51
About Collaboration Debugger	51
Using System Manager	52
Starting System Manager	52
System Manager interface	52
Working with InterChange Server Express instances	55
Registering an InterChange Server Express instance	55
Connecting to InterChange Server Express	56
InterChange Server modes	57
Changing the InterChange Server Express password	58
Refreshing InterChange Server Express	59
Disconnecting from InterChange Server Express	59
Shutting down InterChange Server Express	59
Deleting an InterChange Server Express instance from the view	59
Other System Manager commands for InterChange Server Express	60
Working with integration component libraries	60
Creating integration component libraries	61
Working with user projects	62
Creating user projects	62
Adding shortcuts to a user project	63
Working with components in integration component libraries	65
Naming component guidelines	66
Launching designer tools	66
Creating new components	68
Designating web services as integration components	69
Modifying existing components	71
Importing components into a library from a server using the import wizard	72
Importing components into a library from the server using drag-and-drop	73
Importing components into a library from a package	74
Modifying map and collaboration object properties in integration component libraries	75
Creating synonyms for map automation	75
Validating database connection pools	78
Compiling maps and collaboration templates	78
Working with solutions	78
Exporting a solution	79
Importing a solution	79
Exporting components to a package using System Manager	80
Deploying components to a server	82
Deciding to use System Manager or repos_copy for deployment	82
Setting deployment configuration properties	83
Setting the initial states of components for deployment	87
Validating a package using System Manager	88
Deploying components using System Manager	90
Working with components in an InterChange Server Express repository	95
Validating the components in the repository	95
Validating database connection pools	96
Managing component states in the repository	96
Modifying component properties in the repository	98
Compiling components in the repository	101
Deleting components from the repository	102
Dependencies and references	104
Showing dependencies and references	105
Dependencies that cannot be detected by the system	106
Standard operations available for multiple workbench resources	106
Cutting, copying, and pasting resources	106
Refreshing resources	107
Deleting resources	107
Using Eclipse-based workbenches	107
Opening and closing perspectives	107
Showing and closing views	108
Customizing perspectives	108
Saving perspectives	109
Setting the default perspective	109
Configuring System Manager preferences	109
Troubleshooting problems connecting to InterChange Server Express in System Manager	113
Chapter 5. Configuring InterChange Server Express	115
Using System Manager to configure InterChange Server Express	115
Viewing general properties using System Manager	115
Configuring database properties using System Manager	116
Configuring tracing levels using System Manager	117
Configuring logging and tracing properties using System Manager	117
Configuring e-mail notification properties using System Manager	118
Configuring miscellaneous properties using System Manager	118
Configuring environment variables using System Manager	119
Configuring WebSphere MQ properties using System Manager	119
Chapter 6. Using repos_copy	121
Repos_copy syntax	121
Repos_copy usage scenarios	125
Printing the repos_copy command	126
Validating a package	126
Deploying a package to the repository	126
Validating the repository	128
Compiling components in the repository	128
Deleting components from the repository	129
Exporting components to a package	130
Printing a list of components in the repository	131
Locale for repos_copy files	131
Chapter 7. Configuring connectors	133
Using Connector Configurator	133
Overview of Connector Configurator Express	133
Starting Connector Configurator Express	134
Running Configurator Express from System Manager	134
Creating a connector-specific property template	134
Creating a new configuration file	137
Using an existing file	137
Completing a configuration file	138
Setting the configuration file properties	139
Saving your configuration file	143
Completing the configuration	144
Using Connector Configurator Express in a globalized environment	144
Connector standard properties	145
Configuring standard connector properties	145
Summary of standard properties	146
Standard configuration properties	149
Chapter 8. Configuring database connection pools	157
When to use database connection pools	157
Performing routing	157
Performing lookups in database tables	158
Persisting information	159
When not to use database connection pools	159
Creating database connection pools and database connections	160
Validating database connection pools	163
Modifying database connection pools	163
Modifying login information	164
Modifying the number of connections	164
Deleting database connection objects	165
Using database connection pools in collaborations and maps	165
Configuring transaction bracketing	165
Chapter 9. Configuring collaboration objects	167
Collaboration objects and groups	167
Collaboration-object groups	167
Creating a collaboration object	168
Modifying collaboration objects	170
Collaboration object views	171
Binding collaboration object ports	173
Configuring collaboration object general properties	176
Configuring collaboration-specific properties	181
Chapter 10. Using Relationship Manager	183
Starting Relationship Manager	184
Connecting to and disconnecting from a server	185
Connecting to InterChange Server Express	185
Disconnecting from InterChange Server Express	186
Working with relationships	186
Opening a relationship	186
Retrieving relationship instances	187
Creating relationship instances	189
Deleting relationship instances	191
Deactivating and activating participants	191
Copying participants	192
Loading and unloading business object files	192
Working with relationship data	193
Searching for participants	193
Filtering the displayed participants	194
Cleaning up participants	195
Printing relationship data	196
Chapter 11. Using Test Connector	201
Recommended testing procedure	201
Starting Test Connector	202
Shutting down Test Connector	203
Creating and editing connector profiles	203
Saving the connector definition to a file	203
Creating a new profile	203
Editing a profile	204
Deleting a profile	204
Emulating a connector	204
Working with business objects	204
Working with request business objects	205
Setting values for business object attributes	208
Saving a business object	209
Loading a business object	210
Deleting a business object	210
Accepting a request business object	210
Working with response business objects	210
Comparing business object instances	211
Chapter 12. Using Integrated Test Environment	213
Registering InterChange Server Express as a test server	213
Starting Integrated Test Environment	214
Integrated Test Environment interface	214
Integrated Test Environment Navigator view	215
Outline view	215
Test Unit editor	215
Task Manager view	215
Properties view	215
BO Inspector view	216
Integrated Test Environment Console view	216
Selecting a server configuration	216
Configuring RMI settings	217
Determining which ports to use	217
Setting the RMI port in the Integrated Test Environment preferences	218
Setting the RMI port in start_server.bat	220
Configuring InterChange Server Express to start in design mode	220
Manually editing the start_server.bat file	220
Enabling Integrated Test Environment to create a custom batch file	221
Working with test projects and units	221
Configuring test project preferences	222
Creating a test project	223
Creating test units	224
Opening a test unit	226
Using the Outline view	227
Working with dependents using the Outline view	227
Managing the repository using the Outline view	229
Managing component states using the Outline view	229
Executing tasks using the Outline view	230
Verifying test readiness using the Outline view	230
Showing and closing Client Simulator views using the Outline view	231
Showing and closing BO Inspector views using the Outline view	231
Refreshing BO Markers using the Outline view	232
Using the Task Manager view	232
Making task selections	235
Executing tasks using the Task Manager view	236
Stopping tasks	237
Killing tasks	237
Pausing tasks	238
Configuring your preferred task selections	238
Configuring the default task selections	239
Using the Integrated Test Environment Console and InterChange Server Express Console views	240
Finding text	240
Copying text	240
Maximizing the view window	240
Clearing the view window	241
Configuring Integrated Test Environment Console preferences	241
Using the Test Unit view	241
Using the Server Context Overlay	241
Managing the repository using the Test Unit view	243
Managing component states using the Test Unit view	243
Using, showing, and closing Client Simulator views using the Test Unit view	243
Showing BO Inspector views	244
Refreshing BO Markers	244
Debugging maps using the Test Unit view	244
Changing the Test Unit view scale	245
Configuring Test Unit view preferences	245
Using the Client Simulator view	246
Showing and closing Client Simulator views	246
Connecting a Client Simulator view to the server	247
Confirming that a client has connected to the server	248
Disconnecting from the server	248
Client Simulator view panes and pane arrangements	249
Working with business object requests in the Client Simulator view	253
Setting values for business object attributes	255
Working with response business objects	257
Saving business objects	258
Deleting business objects	258
Exporting business objects	258
Importing business objects	259
Comparing business object instances	259
Using the BO Inspector view	259
Business object trace behavior	260
Showing and closing BO Inspector views	261
Refreshing business object data	262
Refreshing business object markers	262
BO Inspector view styles	262
Saving test data from a BO Inspector view	266
Configuring business object tracing preferences	266
Performing a test using Integrated Test Environment	267
Chapter 13. Using Collaboration Debugger	271
Starting Collaboration Debugger	271
Configuring Collaboration Debugger view preferences	272
Collaboration Debugger interface	273
Events view	273
Collaboration template editor	274
Breakpoints view	275
Variables view	276
Attaching and detaching Collaboration Debugger	278
Attaching Collaboration Debugger	278
Detaching Collaboration Debugger	279
Removing detached collaboration objects from Collaboration Debugger	280
Using the collaboration template editor	280
Opening and closing diagrams	280
Showing and hiding node IDs and labels	280
Configuring Collaboration template editor preferences	281
Working with events	282
Displaying an event	282
Suspending an event	283
Running an event	283
Working with breakpoints	283
Setting breakpoints	284
Displaying breakpoints	284
Removing breakpoints	284
Disabling breakpoints	285
Enabling breakpoints	285
Filtering breakpoints	285
Performing debugging operations	286
Stepping over	286
Stepping into	287
Stepping out	287
Running	287
Running to a specific node	288
Running an event	288
Working with variables	288
Debugging a collaboration	289
Chapter 14. Performance tuning	291
Implementing concurrent processing of event-triggered flows	291
Concurrent event-triggered flow processing in Collaborations	291
Concurrent event-triggered flow processing in collaboration-object groups	291
Concurrent event-triggered flow processing in connector controllers	292
Distributing connector agents	292
Caching static relationships	293
Using database connection pools	293
Using the memory checker thread	293
Setting the CW_MEMORY_MAX parameter	294
Configuring the memory checker thread properties	294
Further considerations	296
Notices	297
Programming interface information	298

Match case Limit results 1 per page

The

“Database

Connection”

dialog

appears.

Note:

Although

the

name

the

dialog

would

suggest

that

what

you

are

creating

this

point

database

connection,

really

database

connection

pool.

later

steps

you

will

define

database

connections

within

the

pool.

Select

the

appropriate

value

the

Database

Driver

drop-down

menu—either

DB2

(Type

,or

SQL

Server(Type

—depending

the

database

vendor.

you

chose

SQL

Server(Type

the

Database

Driver

drop-down

menu,

then

you

must

type

the

name

the

computer

which

the

database

server

resides

the

Host

name

field.

Type

the

name

the

database

the

Database

field.

you

chose

SQL

Server(Type

the

Database

Driver

drop-down

menu,

then

you

must

type

the

port

number

through

which

clients

communicate

with

the

database

server

the

Port

number

field.

you

are

connected

the

InterChange

Server

Express

instance

that

will

use

the

pool,

select

that

instance

from

the

Connected

Servers

drop-down

menu.

Type

name

for

the

pool

the

DBConnection

Name

field.

You

specify

this

database

connection

pool

name

when

writing

Java

code

establish

the

connection

maps

collaboration

templates.

Type

the

user

name

that

should

used

InterChange

Server

Express

log

the

specified

database

the

field.

Type

the

password

for

the

user

name.

10.

Type

the

maximum

number

connections

that

should

established

the

pool

for

all

the

individual

database

connection

objects

you

plan

create

within

the

Maximum

connections

field,

enable

the

Unlimited

checkbox

allow

many

connections

established

are

permitted

the

database

server

configuration

and

licensing.

Warning:

careful

when

working

this

field.

not

single-line

text

field,

even

though

should

be,

you

can

accidentally

press

Enter

You

will

not

see

the

value

you

entered

then,

and

will

justifiably

try

re-type

the

value.

Then

when

you

try

finish

creating

the

database

connection

pool

you

receive

error

that

valid

value

must

entered

for

the

field.

not

press

Enter

this

field.

Figure

page

150

shows

the

“New

Database

Connection

Pool”

wizard.

Chapter

Configuring

database

connection

pools

149