Optimize 10.11 | webMethods Optimize Documentation | Configuring BAM | Database Pool Configuration
 
Database Pool Configuration
 
Configuring a Database Pool
Installing a JDBC Driver for MySQL
You configure the webMethods components in an environment to point to a database component by completing the following steps:
*Configure a JDBC connection pool for the database component.
*Associate the database component with the JDBC connection pool that you configured.
webMethods components also use JDBC connection pools to recycle database connections and reduce connection overhead.
A JDBC connection pool identifies a database and specifies pool parameters, such as minimum and maximum connections. After you define a connection pool, you link the appropriate function to that connection pool. For example, you would define a connection pool that identifies the database that contains the Process Audit database component, and then you would link the Process Audit function to that connection pool. Multiple functions can use the same connection pool. If you installed more than one database component in the same database, you could link both functions to the same connection pool.
Once the JDBC connection pools are configured, you can associate the appropriate functions or logical servers to connection pools from the Map DB Pools configuration tab in webMethods Central Configurator.
Note:
You cannot complete the definition of an environment until you have defined database (DB) connection pools and mapped those DB pools to database activities.