Software AG Products 10.11 | Administering Integration Server | Connecting Integration Server to Database Components in an External RDBMS | Pointing Functions at Connection Pools
 
Pointing Functions at Connection Pools
You can refer to the following steps to point a function to a connection pool.
*To point a function at a connection pool
1. Open the Integration Server Administrator if it is not already open.
2. Go to Settings > JDBC pools.
3. In the Functional Alias Definitions area, click Edit for the function.
4. In the Associated Pool Alias field, identify the connection pool at which to point the function.
5. If the Fail-Fast Mode Enabled option is available, choose whether to enable or disable.
Transient errors caused by an unavailable database can prevent a connection pool from connecting to its database. You can configure a function to enter fail-fast mode to handle this situation. In fail fast mode, all attempts by the function to get a database connection immediately return a SQLException; this saves time by preventing retry attempts. When database connectivity is restored, the function exits fail-fast mode and returns to normal operation. Fail-fast mode can improve performance when you are using synchronous audit logging (see the webMethods Audit Logging Guide).
Note:
Fail-fast cannot be used with the CentralUsers functional alias definition. Consequently, the Fail-Fast Mode Enabled and Currently In Fail-Fast options do not appear when editing the CentralUsers functional alias.
6. Click Save Settings.
7. In the Functional Alias Definitions area, initialize the pool by clicking Restart for the function.
8. Make sure Integration Server can connect to the database by clicking test icon for the function.
9. Restart Integration Server.