You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@superset.apache.org by "sae13 (via GitHub)" <gi...@apache.org> on 2023/08/28 08:46:44 UTC
[GitHub] [superset] sae13 opened a new issue, #25100: can not connect oracle using oracledb package
sae13 opened a new issue, #25100:
URL: https://github.com/apache/superset/issues/25100
hey hi sqlalchemy supports python-oracledb which does not need oracle client oackage
https://docs.sqlalchemy.org/en/20/dialects/oracle.html#module-sqlalchemy.dialects.oracle.oracledb
https://pypi.org/project/oracledb/
its connection string is like
`'oracle+oracledb://user:password@host:port/pdb'`
I installed it with this dockerfile
```
❯ cat Documents/Docker/superset/Dockerfile
FROM apache/superset
USER root
RUN pip install -U pip
RUN pip install elasticsearch-dbapi
RUN pip install shillelagh[gsheetsapi]
RUN pip install mysqlclient
RUN pip install oracledb
RUN pip install psycopg2
RUN pip install pymssql
USER superset
```
but im getting `ERROR: Could not load database driver: OracleEngineSpec`

--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas closed issue #25100: can not connect oracle using oracledb package
URL: https://github.com/apache/superset/issues/25100
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "alex-c (via GitHub)" <gi...@apache.org>.
alex-c commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2018285076
Bump - cx_oracle will not get any new major releases, as development continues under the [python-oracledb](https://oracle.github.io/python-oracledb/) package. Support for this would be nice, in order to not be stuck with an old version.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "thinkh (via GitHub)" <gi...@apache.org>.
thinkh commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-1931985673
@sae13 Did you find a solution to use the oracledb library?
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2033488729
Just made a similar comment on this issue: https://github.com/apache/superset/issues/20371
Perhaps we should close one or the other as a duplicate :)
In any case, has anyone tested [python-oracledb](https://oracle.github.io/python-oracledb/) to see if it works? It sounded like `cx_oracle` was working for some, and `python-oracledb` is supposed to be a drop-in replacement.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "tokas (via GitHub)" <gi...@apache.org>.
tokas commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2061300235
oracledb support was added in SQLAlchemy 2.0. Superset is using SQLAlchemy 1.4
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "alex-c (via GitHub)" <gi...@apache.org>.
alex-c commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2033970871
I tried it recently on my work computer (cannot look up the exact error right now), and it did not work. Oracle did not show up as an option and using "Other" and using the connection string as specified in the python-oracledb docs did not work.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "rusackas (via GitHub)" <gi...@apache.org>.
rusackas commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2738382948
Assuming the last comment solved this for most, as the issue has been silent for nearly a year :) Closing, but happy to revisit/reopen if warranted.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
Re: [I] can not connect oracle using oracledb package [superset]
Posted by "cjbj (via GitHub)" <gi...@apache.org>.
cjbj commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-2111438415
With SQLAlchemy 1.4 you can use python-oracledb in place of cx_Oracle by inserting this code snippet before anything loads cx_Oracle:
```
import sys
import oracledb
oracledb.version = "8.3.0"
sys.modules["cx_Oracle"] = oracledb
import cx_Oracle
```
See the python-oracledb doc: https://python-oracledb.readthedocs.io/en/latest/user_guide/appendix_c.html#python-frameworks-sql-generators-and-orms and https://levelup.gitconnected.com/using-python-oracledb-1-0-with-sqlalchemy-pandas-django-and-flask-5d84e910cb19
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] BipinVeefin commented on issue #25100: can not connect oracle using oracledb package
Posted by "BipinVeefin (via GitHub)" <gi...@apache.org>.
BipinVeefin commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-1700450737
use : pip install cx_oracle
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org
[GitHub] [superset] sae13 commented on issue #25100: can not connect oracle using oracledb package
Posted by "sae13 (via GitHub)" <gi...@apache.org>.
sae13 commented on issue #25100:
URL: https://github.com/apache/superset/issues/25100#issuecomment-1700970827
> use : pip install cx_oracle
I dont want. I want use python-oracle db which does not need oracle client
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org