Database Connection Settings

Add or change the following parameters for database connection settings in the system.yaml configuration file.

Parameter	Description
maxOpenConnections	The maximum number of pooled database connections. Default: 100.
maxIdleConnections	The maximum number of pooled idle database connections. This parameter is applicable only on Apache Tomcat environments. Default: 10.

📘
Default Home Directory
The default product home directory is defined according to the installation type. For additional details, see Product Directory Structure. In this guide, the placeholder $JFROG_HOME represents the product home directory.

📘
How is connection pool for database locking done in Artifactory?
From version 6.0.0, the new database locking mechanism adds its own connection pool (defaults to the value of the pool.max.active value).
You may need to adjust your database connection limit to accept more connections. For example, if your database accepts up to 100 connections per node, consider increasing the limit to 200 concurrent connections per node to accommodate the full utilization of the locking connection pool.
Your database must accept the number of configured connections per node multiplied by the number of nodes in the cluster.

Parameter