6.4. Special parameters for database connections¶
This section describes some special parameters for the database connection.
6.4.1. 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
6.4.2. 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