Remove Abandoned Connections

Key: qie.dbConnection.removeAbandoned

Env Var: QIE_DBCONNECTION_REMOVEABANDONED

Default: false

Scope: Global

Description: This option tells the JDBC connection pool manager to remove connections that are in use if they are not returned in the given timeout (qie.dbConnection.removeAbandonedTimeoutSeconds). This option is dangerous as it will remove connections that are running a long running query, so if you enable this option, make sure to set qie.dbConnection.removeAbandonedTimeoutSeconds to some value much greater than the longest expected query.

Examples

Env Var

QIE_DBCONNECTION_REMOVEABANDONED=true

Java Option

-Dqie.dbConnection.removeAbandoned=true

YAML

QIE_DBCONNECTION_REMOVEABANDONED: true