[GitHub] zerodf opened a new issue #3447: 'twophase' is an invalid keyword errors connecting to Oracle

[gi...@git.apache.org]

zerodf opened a new issue #3447: 'twophase' is an invalid keyword errors connecting to Oracle
URL: https://github.com/apache/incubator-superset/issues/3447
 
 
   I had an error installing and configuring Superset.  
   
   The error was attributable to issues with [sqlalchemy](https://github.com/zzzeek/sqlalchemy) and cx_Oracle.  So, feel free to close this issue.  However, I felt it was worth documenting here, so that people could see the work around.  
   
   ### Superset version
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
   Superset 0.19.1
   -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
   
   ```
   sqlalchemy.__version__
   '1.1.9'
   ```
   
   ```
   cx_Oracle.version
   '6.0.2'
   ```
   
   ### Expected results
   When I entered an Oracle connection string with the following format: 
   oracle://**USER**:**PASSWORD**@**HOST**:**PORT**/**SID**
   I expected to be able to connect to Oracle
   
   ### Actual results
   Errors:
   ```
   'twophase' is an invalid keyword argument for this function
   ```
   
   ### Temporary Work around
   I was able to install cx_Oracle version 5.1.3 and these errors were resolved.  I believe you are refactoring for cx_Oracle 6+, so reverting to the older version of cx_Oracle is a temporary measure.  
   
   
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services