Special parameters for database connections

This section describes some special parameters for the database connection.

Pool recyle

This is a special parameter for the SQL Audit module.

After this certain amount of time (in seconds) connections from the database connection pool will not be used anymore:

linotpAudit.sql.pool_recyle = 3600

Implicit returning

PostgreSQL, Oracle and MS SQL support RETURNING [1].

implicit_returning indicates that RETURNING can be used by default to fetch newly inserted primary key values. [2] In certain scenarios like redundant MS SQL servers it is reported that this causes problems. In the linotp.ini this can be turned off by adding the config:

linotpSQL.implicit_returning = False