Record - sql : ConnectionPool

Represents the properties which are used to configure DB connection pool. Default values of the fields can be set through the configuration API.

Fields

  • maxOpenConnections int (default config:getAsInt(b7a.sql.pool.maxOpenConnections, 15))
  • The maximum number of open connections that the pool is allowed to have, including both idle and in-use connections. Default value is 15 and it can be changed through the configuration API with the key b7a.sql.pool.maxOpenConnections.

  • maxConnectionLifeTimeInSeconds decimal (default config:getAsFloat(b7a.sql.pool.maxConnectionLifeTimeInSeconds, 1800.0))
  • The maximum lifetime of a connection in the pool. Default value is 1800 seconds (30 minutes) and it can be changed through the configuration API with the key b7a.sql.pool.maxConnectionLifeTimeInSeconds. A value of 0 indicates unlimited maximum lifetime (infinite lifetime).

  • minIdleConnections int (default config:getAsInt(b7a.sql.pool.minIdleConnections, 15))
  • The minimum number of idle connections that pool tries to maintain in the pool. Default is the same as maxOpenConnections and it can be changed through the configuration API with the key b7a.sql.pool.minIdleConnections.