Creating database connection pools and database connections
To create a database connection pool, you must first define the values
necessary for establishing the database connection. For each pool, you
will specify a number of connections that are then allocated, used, and freed
back to the pool.
- Note:
- The following task requires that you know the user name and password you
specified for the database when you configured your InterChange Server Express.
For details, see the Implementation Guide for WebSphere InterChange
Server.
To create a database pool:
- Right-click the Database Connection Pools folder in your
integration component library in System Manager and choose Create New
Database Connection from the context menu.
The Database Connection dialog of the Create New Database Connection wizard
appears.
- Note:
- Although the name of the dialog would suggest that at this point you are
creating a database connection, you are really creating a database connection
pool. In later steps you will define database connections within the
pool.
- Depending on the database vendor, select one of the following values from
the Database Driver drop-down menu:
- DB2 (Type 2)
- MQ SQL Server(Type 4)
- Data Direct Oracle(Type 4)
- If you chose MQ SQL Server(Type 4) or Data Direct
Oracle(Type 4) from the Database Driver drop-down menu, then
type the name of the computer on which the database server resides in the
Host name field.
- In the Database field, type the name of the database.
- If you chose MQ SQL Server(Type 4) or Data Direct
Oracle(Type 4) from the Database Driver drop-down menu, then
type the port number through which clients communicate with the database
server in the Port number field.
- In the DBConnection Name field, type a name for the
pool. You specify this database connection pool name when writing Java
code to establish the connection in maps or collaboration templates.
- In the Login field, type the user
name that should be used by InterChange Server Express to log in to the specified
database.
- In the Password field, type the password for the user name you
just specified in Step 7. This is the password you set in the database
properties when you configured InterChange Server Express. For details, see the
Implementation Guide for WebSphere InterChange Server Express.
- Do one of the following:
- In the Maximum connections field, 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.
- Warning:
- Be careful when entering data 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, 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.
- Enable the Unlimited checkbox to allow as many connections to
be established as are permitted by the database server configuration and
licensing.
- To create a new database connection object in the pool, right-click a row
in the New Connection Pool table at the bottom of the wizard and
choose New Connection Pool from the context menu.
- Note:
- Although the interface would suggest that at this point you are creating
another database connection pool, you are really creating a database
connection object within the pool you just created.
The Connection Pool dialog appears.
- In the Name field, type a name for the database connection
object.
- In the Minimum connections field, enter the minimum number of
connections that the database connection object should establish. Note
that the sum of the minimum connections that you create in the pool cannot
exceed the maximum number that you specify for the database connection pool
object itself. System Manager does not allow you to attempt to add a
connection object or modify an existing connection object so that the maximum
number of connections for the pool would be exceeded.
- 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.
- Use the wizard to create another database connection pool at this time or
click Cancel to close the wizard.
See also
[ Top of Page | Previous Page | Next Page | Table of Contents ]
