Repository navigation
Error connecting to python-oracledb #215
Description
Hello ,
I opened a Issue at sqlalchemy regarding a connection to oracle wiyh new driver oracle+oracledb, and they tell me that this issue was related to ipython-sql.
The trhread
sqlalchemy/sqlalchemy#8676 (reply in thread)
Code
import oracledb
import pandas as pd
import sqlalchemy
%reload_ext sql
#%sql oracle+oracledb://user:pass@host-scan.domain.net:1521/?service_name=XPTO.domain.net
sqlalchemy.version
Error
init() got an unexpected keyword argument 'bind'
Connection info needed in SQLAlchemy format, example:
postgresql://username:password@hostname/dbname
or an existing connection: dict_keys([])
'2.0.0b1'
Please coul you help
Regards
Activity
ellipticview commentedon Nov 27, 2022
Until sqlalchemy supports python-oracledb, a workaround is documented here:
https://python-oracledb.readthedocs.io/en/latest/user_guide/appendix_c.html#python-frameworks-sql-generators-and-orms.
So you can use python-oracledb like this, which is very useful for running on MacOS M1 as no Oracle instant client is required:
Fix - Issue better detect the user uses sqlalchemy variable expansion (…