Field | Description |
Package | Namespace node package in which to create the connection. For more information about creating packages, see
Package Management. |
Folder Name | Folder name in which to create the connection. If the folder does not already exist in the package, the Integration Server creates it. |
Connection Name | Connection name. |
Field | Description |
Enable Connection Pooling | Enables or disables the use of connection pooling for the connection. The default value is true (enabled). |
Minimum Pool Size | Number of connections to create when the connection is enabled. The default value is 1. |
Maximum Pool Size | Maximum number of connections that can exist at one time in the connection pool. The default value is 10. |
Pool Increment Size | Number of connections by which the pool will be incremented if connections are needed, up to the maximum pool size. The default value is 1. |
Block Timeout | If connection pooling is enabled, this field specifies the number of milliseconds that Integration Server waits to obtain a connection with the adapter resource before it times out and returns an error. For example, you have a pool with Maximum Pool Size of 20. If you receive 30 simultaneous requests for a connection, 10 requests wait for a connection from the pool. If you set the Block Timeout to 5000, the 10 requests wait for a connection for 5 seconds before they time out and return an error. If the services using the connections require 10 seconds to complete and return connections to the pool, the pending requests fail and return an error message stating that no connections are available. If you set the Block Timeout value too high, you may encounter problems during error conditions. If a request contains errors that delay the response, other requests are not sent. This setting must be tuned in conjunction with the Maximum Pool Size to accommodate such bursts in processing. The default value is 1000. |
Expire Timeout | If connection pooling is enabled, this field specifies the number of milliseconds that an inactive connection can remain in the pool before it is closed and removed from the pool. The connection pool removes inactive connections until the number of connections in the pool is equal to the Minimum Pool Size. The inactivity timer for a connection is reset when the connection is used by the adapter. If you set the Expire Timeout value too high, you may have a number of unused inactive connections in the pool. This consumes local memory and a connection on your backend resource. This could have an adverse effect if your resource has a limited number of connections. If you set the Expire Timeout value too low, performance could degrade because of the increased activity of creating and closing connections. This setting should be tuned in conjunction with the Minimum Pool Size to avoid excessive opening/closing of connections during normal processing. The default value is 1000. Enter -1 to specify no timeout. |
Startup Retry Count | Number of times that the system should attempt to initialize the connection pool at startup if the initial attempt fails. The default value is 0 (a single attempt). |
Startup Backoff Timeout | Number of seconds that the system should wait between attempts to initialize the connection pool. This field is irrelevant if the value of Startup Retry Count is 0. The default value is 10. |