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`
   ![image](https://github.com/apache/superset/assets/17175994/742de882-d856-4200-83f9-9084283f0329)
   


-- 
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