Associating a function with database pool alias

Associating a function with a database connection pool alias ensures efficient, reliable access to reusable connections, enhancing performance and reducing connection overhead.

Before you begin

You have the database connection pool that must be associated with a function. If not create a database connection pool. For more information about how to create a database connection pool, see Creating a database connection pool alias.

About this task

Associating a function with a database connection pool alias, makes sure that the function can efficiently and consistently access database connections when needed. You get the benefits of connection pooling, such as connection reuse, connection validation, and automatic connection recovery. This helps improve the overall performance of your application by reducing the overhead of establishing new database connections for each function call, as well as more reliable and responsive database interactions.

The system provides built-in functions that use these connections to write specific types of data to the correct database areas. The direct functions use these pools to send data to the correct database. For example:

  • The ISInternal function connects to the pool for the ISInternal and DistributedLocking database components.
  • The Xref function connects to the pool for the CrossReference component.

The following table provides the built-in functions and their database components that are supported.

Function Name Database Component
ISInternal ISInternal and DistributedLocking
ISCoreAudit ISCoreAuditLog
ISDashboardStats ISInternal
Xref CrossReference
DocumentHistory DocumentHistory
ProcessAudit ProcessAudit
Process Engine ProcessEngine
Note:
  • You cannot add or delete functions.
  • You can create and delete a connection pool and point a function to the new pool.

Procedure

  1. From the runtime dashboard page, click Connections.
    The Connections page is displayed.
  2. In webMethods database connections, click Configure database.
    The Configure webMethods database connection dialog is displayed.
  3. In Function name, select a predefined function.
    The function description is displayed.
  4. In Associated pool alias, specify the connection pool that must be used by the function to write data to the database component.
  5. Optional: Click Edit pool alias to update the connection pool alias.
  6. Optional: Click Test pool alias to test the connection pool alias.
  7. Select Fail-Fast mode-enabled, to manage transient errors due to unavailable resources. In fail-fast mode, all attempts by the function to get a database connection immediately return an SQL exception; 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.
  8. Click Save to save the changes.

Results

You associated a predefined function with a database connection pool.

What to do next

You can use this connection for performing database operations.