Skip to content

db.conf key reference

How to read these tables:

  • Key: HOCON path used in application.conf and override.conf
  • Default value: shipped default
  • Description: runtime meaning and impact
Key Default value Description
db.poolName "sae" Connection pool name.
db.schema "sae" Default database schema used by the application.
db.catalog "" Optional JDBC catalog. Empty means unset.
db.autoCommit false Default auto-commit mode for pooled connections.
db.connectionTimeout 30000 Max wait time (ms) to obtain a connection from the pool.
db.idleTimeout 600000 Idle connection timeout (ms).
db.keepaliveTime 120000 Keepalive interval (ms) for pooled connections.
db.validationTimeout 4000 Validation timeout (ms) for connection checks.
db.leakDetectionThreshold 0 Leak detection threshold (ms). 0 disables leak detection.
db.maxLifetime 1800000 Maximum connection lifetime (ms).
db.maximumPoolSize 15 Maximum number of connections in the pool.
db.minimumIdle 8 Minimum number of idle connections maintained by the pool.
db.isolateInternalQueries false Whether internal pool queries are isolated in their own transaction context.
db.allowPoolSuspension false Whether pool suspension/resume is enabled.
db.initializationFailTimeout 1 Pool initialization failure timeout (ms); low value means fail fast at startup.
db.dataSourceClassName "org.postgresql.ds.PGSimpleDataSource" JDBC data source implementation class.
db.connectionInitSql "" Optional SQL run when a new connection is created.
db.transactionIsolation "" Optional explicit transaction isolation level. Empty means driver/default behavior.
db.dataSource.readOnly false Default read-only flag on datasource connections.
db.dataSource.user "pki" Database username.
db.dataSource.password "Password1." Database password (override in deployment; do not keep defaults in production).
db.dataSource.databaseName "postgres" PostgreSQL database name.
db.dataSource.portNumber 5432 PostgreSQL server port.
db.dataSource.serverName "localhost" PostgreSQL host name or IP.
db.dataSource.currentSchema ${db.schema} Current schema bound to datasource; defaults to db.schema.
db.dataSource.ssl false Enables JDBC SSL.
db.dataSource.sslmode "prefer" PostgreSQL SSL mode (disable, allow, prefer, require, verify-ca, verify-full).
db.dataSource.sslrootcert "" Path to CA root certificate file for SSL validation.
db.dataSource.sslcert "" Path to client certificate file.
db.dataSource.sslkey "" Path to client private key file.
db.dataSource.sslpassword "" Password for encrypted client private key.