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

[1]

http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/returninginto_clause.htm

[2]

http://docs.sqlalchemy.org/en/latest/core/schema.html