Skip to content

Recommend using oracledb library versus cx_Oracle #8

Description

@patrickjlong1

cx_oracle isn't compatible with python3.11 or more recent. On the homepage of their documentation they advise to switch to oracledb. For standalone connections in sqlalchemy substituting cx_Oracle with oracledb should get the job done (see sqlAlchemy doc page on this).

The only file that likely needs changing is engine.py at line 131 changing sqlstr = f"oracle+cx_Oracle://{db_user}:{db_pass}@{db_host}:{db_port}/{db_name}" to sqlstr = f"oracle+oracledb://{db_user}:{db_pass}@{db_host}:{db_port}/{db_name}"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions