Airflow Oracle

Latest version

Released:

Provider package apache-airflow-providers-oracle for Apache Airflow

Airflow Oracle Operator

Module Contents¶ class airflow.hooks.oraclehook.OracleHook source ¶. Bases: airflow.hooks.dbapihook.DbApiHook Interact with Oracle SQL. Connnameattr = oracleconnid source ¶ defaultconnname = oracledefault source ¶ supportsautocommit = False source ¶ getconn (self) source ¶. Returns a oracle connection object Optional parameters for using a custom. Oracle ® MiniCluster S7-2. Follow these guidelines to ensure unrestricted airflow in the storage array: Adhere to the minimum airflow clearance specifications. See Physical Specifications (Storage Array). Install the storage array so the front faces the cool aisle and the rear faces the warm aisle. Do not direct warm air into the storage.

Project description

Package apache-airflow-providers-oracle

Release: 1.1.0

Provider package

This is a provider package for oracle provider. All classes for this provider packageare in airflow.providers.oracle python package.

You can find package information and changelog for the providerin the documentation.

Installation

NOTE!

On November 2020, new version of PIP (20.3) has been released with a new, 2020 resolver. This resolverdoes not yet work with Apache Airflow and might lead to errors in installation - depends on your choiceof extras. In order to install Airflow you need to either downgrade pip to version 20.2.4pip install --upgradepip20.2.4 or, in case you use Pip 20.3, you need to add option--use-deprecatedlegacy-resolver to your pip install command.

You can install this package on top of an existing airflow 2.* installation viapip install apache-airflow-providers-oracle

PIP requirements

PIP packageVersion required
cx_Oracle>=5.1.2

Release historyRelease notifications RSS feed

1.1.0

1.1.0rc1 pre-release

1.0.1

1.0.1rc1 pre-release

1.0.0

1.0.0rc1 pre-release

Airflow Oracle

1.0.0b2 pre-release

1.0.0b1 pre-release

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for apache-airflow-providers-oracle, version 1.1.0
Filename, sizeFile typePython versionUpload dateHashes
Filename, size apache_airflow_providers_oracle-1.1.0-py3-none-any.whl (17.1 kB) File type Wheel Python version py3 Upload dateHashes
Close

Hashes for apache_airflow_providers_oracle-1.1.0-py3-none-any.whl

Hashes for apache_airflow_providers_oracle-1.1.0-py3-none-any.whl
AlgorithmHash digest
SHA256a41fb2605b53afc4d1f2fc3434b25a657684316a3e4240566db169dca7db5d98
MD5e8c22bfc3d6a1933a5da0310cffc9138
BLAKE2-25645412964b50175ab7af0c55e4d47ddb37aaaa913ef1eba182ee4ea625a6d9982
[2016-10-26 14:51:07,574] {base.py:719} INFO - COMMIT
[2016-10-26 14:51:07,631] {log.py:109} INFO - SELECT USER FROM DUAL
[2016-10-26 14:51:07,633] {log.py:109} INFO - SELECT CAST('test plain returns' AS VARCHAR(60 CHAR)) AS anon_1 FROM DUAL
[2016-10-26 14:51:07,634] {log.py:109} INFO - SELECT CAST('test unicode returns' AS NVARCHAR2(60)) AS anon_1 FROM DUAL
[2016-10-26 14:51:07,638] {log.py:109} INFO - Disconnection detected on checkout:
[2016-10-26 14:51:07,638] {log.py:109} INFO - Invalidate connection <cx_Oracle.Connection to [MyDataBaseName]@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[MyOracleServerIP])(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=I2B2)))> (reason: DisconnectionError:)
[2016-10-26 14:51:07,678] {log.py:109} INFO - Disconnection detected on checkout:
[2016-10-26 14:51:07,678] {log.py:109} INFO - Invalidate connection <cx_Oracle.Connection to [MyDataBaseName]@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[MyOracleServerIP])(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=I2B2)))> (reason: DisconnectionError:)
[2016-10-26 14:51:07,714] {log.py:109} INFO - Reconnection attempts exhausted on checkout
[2016-10-26 14:51:07,715] {log.py:109} INFO - Invalidate connection <cx_Oracle.Connection to [MyDataBaseName]@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=[MyOracleServerIP])(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=I2B2)))>

Airflow Oracle Database

[2016-10-26 14:51:07,716] {models.py:1286} ERROR - This connection is closed
File '/usr/local/lib/python2.7/dist-packages/airflow/models.py', line 1245, in run
File '/usr/local/lib/python2.7/dist-packages/airflow/operators/python_operator.py', line 66, in execute
return_value = self.python_callable(*self.op_args, **self.op_kwargs)
File '/root/airflow/dags/debug_py2b2_connect.py', line 41, in test_connect
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py', line 2085, in connect
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py', line 90, in __init__
if connection is not None else engine.raw_connection()
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py', line 2171, in raw_connection
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py', line 2141, in _wrap_pool_connect
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py', line 328, in unique_connection
File '/usr/local/lib/python2.7/dist-packages/sqlalchemy/pool.py', line 804, in _checkout

Airflow Oracle Backend

raise exc.InvalidRequestError('This connection is closed')

Airflow Oracle Download

[2016-10-26 14:51:07,718] {models.py:1306} INFO - Marking task as FAILED.