Connection pools
Connection pools contain a cached set of database connections that can be used for incoming database connection requests. You configure a connection pool to accommodate the number of concurrent users and transaction load expected, Depending on your environment, the connection pool settings in one or more files must be configured for correct connectivity to the database. Connection pool names are case-sensitive.
The recommended setting for minimum connections is 10. The
recommended setting for maximum connections is 100. A setting of 100
maximum connections is common for a JVM that is not expected to exceed
500 concurrent users. You can modify the connection pool setting on
the data source defined for IBM® TRIRIGA®.
| Connection pool settings | File location |
|---|---|
| Oracle WebLogic Server pools | [tririga_root]\config\TRIRIGAWEBLOGICPOOL.properties For example, C:\Tririga\config\TRIRIGAWEBLOGICPOOL.properties |
| Oracle Database trace levels | [tririga_root]\config\TRIRIGAMIDDLEWARE.properties For example, C:\Tririga\config\TRIRIGAMIDDLEWARE.properties |