diff options
| author | suraj <suraj.shaw@oracle.com> | 2024-09-10 20:56:16 +0530 |
|---|---|---|
| committer | Sarah Boyce <42296566+sarahboyce@users.noreply.github.com> | 2024-12-17 11:26:32 +0100 |
| commit | 0d9872fc9a70ef6966930c68c68febea7eb60ede (patch) | |
| tree | eb61a0623f7c0bceb5eeb05c36839cfa98cb2d64 /docs/ref/databases.txt | |
| parent | 2249370c8611d97f8bdb6003fb7b4d8fd3646202 (diff) | |
Fixed #7732 -- Added support for connection pools on Oracle.
Diffstat (limited to 'docs/ref/databases.txt')
| -rw-r--r-- | docs/ref/databases.txt | 42 |
1 files changed, 41 insertions, 1 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index 57e94140c2..d19c78b9ec 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -994,7 +994,7 @@ Oracle notes ============ Django supports `Oracle Database Server`_ versions 19c and higher. Version -1.3.2 or higher of the `oracledb`_ Python driver is required. +2.3.0 or higher of the `oracledb`_ Python driver is required. .. deprecated:: 5.0 @@ -1105,6 +1105,46 @@ Example of a full DSN string:: "(CONNECT_DATA=(SERVICE_NAME=orclpdb1)))" ) +.. _oracle-pool: + +Connection pool +--------------- + +.. versionadded:: 5.2 + +To use a connection pool with `oracledb`_, set ``"pool"`` to ``True`` in the +:setting:`OPTIONS` part of your database configuration. This uses the driver's +`create_pool()`_ default values:: + + DATABASES = { + "default": { + "ENGINE": "django.db.backends.oracle", + # ... + "OPTIONS": { + "pool": True, + }, + }, + } + +To pass custom parameters to the driver's `create_pool()`_ function, you can +alternatively set ``"pool"`` to be a dict:: + + DATABASES = { + "default": { + "ENGINE": "django.db.backends.oracle", + # ... + "OPTIONS": { + "pool": { + "min": 1, + "max": 10, + # ... + } + }, + }, + } + +.. _`create_pool()`: https://python-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#connection-pooling + Threaded option --------------- |
