Configuring a Database Pool
To configure a database pool
1. Navigate to the Databases configuration type and click . 2. In Connection Basics, complete the fields that are described in the following table.
Field | Description |
Alias | Name of the connection pool. Use only characters that are valid for a file name in your operating system. |
Description | Description of the connection pool. You can describe the purpose of the database connection pool and the location of the database schema. |
3. In Connection Details, complete the fields that are described in the following table.
Option | Description |
RDBMS | Database type. SQL Server Oracle DB2 (for Linux, UNIX, and Windows) MySQL MySQL Community Edition PostgreSQL |
URL | URL to the database schema that contains one or more database component sets. |
Username | Name of the database user. |
Password | Password of the database user. |
4. Optional. Change the default Connection Pool Configuration settings.
The settings under Connection Pool Configuration are identical to the settings in the Pool Settings panel in the Database Pool Configuration page in My webMethods.
5. Click Save.
The connection pool is listed in the Databases table. The JDBC URL is displayed in the middle column of table.