.. _db_parameters:

Special parameters for database connections
-------------------------------------------

.. index:: Database parameters

This section describes some special parameters for the database connection.

Pool recyle
~~~~~~~~~~~

.. index:: Pool recycle

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
~~~~~~~~~~~~~~~~~~

.. index:: Implicit returning

PostgreSQL, Oracle and MS SQL support RETURNING [#oracle_returning]_.

``implicit_returning`` indicates that RETURNING can be used by default to fetch newly 
inserted primary key values. [#sqlalchemy]_
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

.. [#oracle_returning] http://docs.oracle.com/cd/B19306_01/appdev.102/b14261/returninginto_clause.htm
.. [#sqlalchemy] http://docs.sqlalchemy.org/en/latest/core/schema.html