Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Update from old 'cx_Oracle' to 'oracledb' #9899

Open
cjbj opened this issue May 8, 2024 · 0 comments
Open

Update from old 'cx_Oracle' to 'oracledb' #9899

cjbj opened this issue May 8, 2024 · 0 comments

Comments

@cjbj
Copy link

cjbj commented May 8, 2024

SQLAlchemy 2 supports the latest Oracle Database driver which was renamed to python-oracledb from cx_Oracle a couple of years ago. The new version is a 'thin' driver so a simple 'pip install oracledb' installs all that is needed to connect to Oracle Database.

The test suite references to cx_Oracle should be updated to the new module name 'oracledb' as appropriate when SQLAlchemy 2 is in use. https://github.com/search?q=repo%3Agreat-expectations%2Fgreat_expectations%20oracle&type=code

The engine creation prefix for Oracle Database is 'oracle+oracledb://'

If you want an Oracle DB container for testing, use https://hub.docker.com/r/gvenzl/oracle-free

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants