Dec 27, 2021 · Oct 7, 2021
diff --git a/components/cache/adapters/pdo_doctrine_dbal_adapter.rst b/components/cache/adapters/pdo_doctrine_dbal_adapter.rst
 PDO & Doctrine DBAL Cache Adapter
 =================================

 This adapter stores the cache items in an SQL database. It requires a :phpclass:`PDO`,
 `Doctrine DBAL Connection`_, or `Data Source Name (DSN)`_ as its first parameter, and
 optionally a namespace, default cache lifetime, and options array as its second,
 third, and forth parameters::
 The PDO and Doctrine DBAL adapters store the cache items in a table of an SQL database.

 .. note::

    Adapters implement :class:`Symfony\\Component\\Cache\\PruneableInterface`,
    allowing for manual :ref:`pruning of expired cache entries <component-cache-cache-pool-prune>` by
    calling the ``prune()`` method.

 Using :phpclass:`PDO`
 ---------------------

 The :class:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter` requires a :phpclass:`PDO`,
 or `Data Source Name (DSN)`_ as its first parameter, and optionally a namespace,
 default cache lifetime, and options array as its second, third, and forth parameters::

    use Symfony\Component\Cache\Adapter\PdoAdapter;

    $cache = new PdoAdapter(

        // a PDO, a Doctrine DBAL connection or DSN for lazy connecting through PDO
        // a PDO connection or DSN for lazy connecting through PDO
        $databaseConnectionOrDSN,

        // the string prefixed to the keys of the items stored in this cache
 :method:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter::createTable` method in
 your code.

 .. deprecated:: 5.4

    Using :class:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter` with a
    :class:`Doctrine\\DBAL\\Connection` or a DBAL URL is deprecated since Symfony 5.4
    and will be removed in Symfony 6.0.
    Use :class:`Symfony\\Component\\Cache\\Adapter\\DoctrineDbalAdapter` instead.

 .. tip::

    When passed a `Data Source Name (DSN)`_ string (instead of a database connection
    class instance), the connection will be lazy-loaded when needed.
    class instance), the connection will be lazy-loaded when needed. DBAL Connection
    are lazy-loaded by default; some additional options may be necessary to detect
    the database engine and version without opening the connection.


 Using Doctrine DBAL
 -------------------

 The :class:`Symfony\\Component\\Cache\\Adapter\\DoctrineDbalAdapter` requires a
 `Doctrine DBAL Connection`_, or `Doctrine DBAL URL`_ as its first parameter, and
 optionally a namespace, default cache lifetime, and options array as its second,
 third, and forth parameters::

    use Symfony\Component\Cache\Adapter\DoctrineDbalAdapter;

    $cache = new DoctrineDbalAdapter(

        // a Doctrine DBAL connection or DBAL URL
        $databaseConnectionOrURL,

        // the string prefixed to the keys of the items stored in this cache
        $namespace = '',

        // the default lifetime (in seconds) for cache items that do not define their
        // own lifetime, with a value 0 causing items to be stored indefinitely (i.e.
        // until the database table is truncated or its rows are otherwise deleted)
        $defaultLifetime = 0,

        // an array of options for configuring the database table and connection
        $options = []
    );

 .. note::

 This adapter implements :class:`Symfony\\Component\\Cache\\PruneableInterface`,
 allowing for manual :ref:`pruning of expired cache entries <component-cache-cache-pool-prune>` by
 calling its ``prune()`` method.
 DBAL Connection are lazy-loaded by default; some additional options may be
 necessary to detect the database engine and version without opening the
 connection.

 .. _`Doctrine DBAL Connection`: https://github.com/doctrine/dbal/blob/master/src/Connection.php
 .. _`Doctrine DBAL URL`: https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
 .. _`Data Source Name (DSN)`: https://en.wikipedia.org/wiki/Data_source_name
Original file line number	Diff line number	Diff line change
Expand Up		@@ -7,16 +7,26 @@
		PDO & Doctrine DBAL Cache Adapter
		=================================

		This adapter stores the cache items in an SQL database. It requires a :phpclass:`PDO`,
		`Doctrine DBAL Connection`_, or `Data Source Name (DSN)`_ as its first parameter, and
		optionally a namespace, default cache lifetime, and options array as its second,
		third, and forth parameters::
		The PDO and Doctrine DBAL adapters store the cache items in a table of an SQL database.

		.. note::

		Adapters implement :class:`Symfony\\Component\\Cache\\PruneableInterface`,
		allowing for manual :ref:`pruning of expired cache entries <component-cache-cache-pool-prune>` by
		calling the ``prune()`` method.

		Using :phpclass:`PDO`
		---------------------

		The :class:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter` requires a :phpclass:`PDO`,
		or `Data Source Name (DSN)`_ as its first parameter, and optionally a namespace,
		default cache lifetime, and options array as its second, third, and forth parameters::

		use Symfony\Component\Cache\Adapter\PdoAdapter;

		$cache = new PdoAdapter(

		// a PDO, a Doctrine DBAL connection or DSN for lazy connecting through PDO
		// a PDO connection or DSN for lazy connecting through PDO
		$databaseConnectionOrDSN,

		// the string prefixed to the keys of the items stored in this cache
Expand All		@@ -37,16 +47,54 @@ You can also create this table explicitly by calling the
		:method:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter::createTable` method in
		your code.

		.. deprecated:: 5.4

		Using :class:`Symfony\\Component\\Cache\\Adapter\\PdoAdapter` with a
		:class:`Doctrine\\DBAL\\Connection` or a DBAL URL is deprecated since Symfony 5.4
		and will be removed in Symfony 6.0.
		Use :class:`Symfony\\Component\\Cache\\Adapter\\DoctrineDbalAdapter` instead.

		.. tip::

		When passed a `Data Source Name (DSN)`_ string (instead of a database connection
		class instance), the connection will be lazy-loaded when needed.
		class instance), the connection will be lazy-loaded when needed. DBAL Connection
		are lazy-loaded by default; some additional options may be necessary to detect
		the database engine and version without opening the connection.


		Using Doctrine DBAL
		-------------------

		The :class:`Symfony\\Component\\Cache\\Adapter\\DoctrineDbalAdapter` requires a
		`Doctrine DBAL Connection`_, or `Doctrine DBAL URL`_ as its first parameter, and
		optionally a namespace, default cache lifetime, and options array as its second,
		third, and forth parameters::

		use Symfony\Component\Cache\Adapter\DoctrineDbalAdapter;

		$cache = new DoctrineDbalAdapter(

		// a Doctrine DBAL connection or DBAL URL
		$databaseConnectionOrURL,

		// the string prefixed to the keys of the items stored in this cache
		$namespace = '',

		// the default lifetime (in seconds) for cache items that do not define their
		// own lifetime, with a value 0 causing items to be stored indefinitely (i.e.
		// until the database table is truncated or its rows are otherwise deleted)
		$defaultLifetime = 0,

		// an array of options for configuring the database table and connection
		$options = []
		);

		.. note::

		This adapter implements :class:`Symfony\\Component\\Cache\\PruneableInterface`,
		allowing for manual :ref:`pruning of expired cache entries <component-cache-cache-pool-prune>` by
		calling its ``prune()`` method.
		DBAL Connection are lazy-loaded by default; some additional options may be
		necessary to detect the database engine and version without opening the
		connection.

		.. _`Doctrine DBAL Connection`: https://github.com/doctrine/dbal/blob/master/src/Connection.php
		.. _`Doctrine DBAL URL`: https://www.doctrine-project.org/projects/doctrine-dbal/en/latest/reference/configuration.html#connecting-using-a-url
		.. _`Data Source Name (DSN)`: https://en.wikipedia.org/wiki/Data_source_name