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:
- 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.
- 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.
- Press Alt+Enter.
The following sections document the properties of database connection
pools and database connection objects that you can change:
Modifying login information
Many companies follow a practice of changing passwords
at a regular interval to guard against old accounts being used to
violate security. If this is the case at the site then you may need
to change the login information for the database connection pool.
To change the login name used to access the database resource,
type the new value into the Login field in the "Database
Connection" screen.
To change the password for the specified login, click Change in
the "Database Connection" screen, then do the
following at the "Password Change" prompt:
- Type the current password in the Old Password field.
- Type the new password in the New Password field.
- Type the new password again in the Confirm Password field.
You can modify the maximum number of connections for a
database connection pool, and the minimum number of connections
for a database connection object. The sum of all the minimum connections
of all the database connection objects defined in a database connection
pool may not exceed the maximum number of connections specified
for the pool itself.
Modifying the maximum connections for a database connection pool
Do the following to modify the maximum number of connections
for a database connection pool:
- Access the properties of the database connection pool you want
to edit, as described in Modifying database connection pools.
- Do one of the following to modify the maximum number of connections
that can be established by the total number of connection objects
in the pool:
- Type the maximum number of connections that should be established
by the pool in the Maximum connections field.
- Enable the Unlimited checkbox to allow
as many connections to be established as are permitted by the database
server configuration and licensing.
- Click OK.
Modifying the minimum connections for a database connection object
Do the following to modify the maximum number of connections
for a connection object:
- Access the properties of the database connection pool you want
to edit, as described in Modifying database connection pools.
- 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.
- Type the new value in the Minimum connections field.
- Click OK.
Modifying database connection resilience settings
Do the following to modify the database connection resilience
settings for a database connection pool:
- Access the properties of the database connection pool you want
to edit, as described in Modifying database connection pools.
- Type in the number of times you would like the InterChange Server
Express to try to regain a database connection when the connection
is broken or cannot be established in the Maximum connect retries field.
In the Connect retry interval field, enter
the amount of time (in seconds) that you would like InterChange
Server Express to wait between two attempts to regain the database
connection.
- Click OK.
Deleting database connection objects
Do the following to delete a database connection object:
- Access the properties of the database connection pool as described
in Modifying database connection pools.
- In the "New Connection Pool" pane, right-click
the connection object you want to delete and select Delete from
the context menu.
- Click OK.
