I'm attempting to make use of an Oracle wallet with proxy authentication passed as strings in URL.
The documentation states: "Changed in version 1.3: the cx_oracle dialect now accepts all argument names within the URL string itself, to be passed to the cx_Oracle DBAPI. As was the case earlier but not correctly documented, the create_engine.connect_args <https://docs.sqlalchemy.org/en/13/core/engines.html#sqlalchemy.create_engine.params.connect_args> parameter also accepts all cx_Oracle DBAPI connect arguments." The following works: db = sqlalchemy.create_engine('oracle+cx_oracle://my_wallet_credential', connect_args={"user":"[prox_to_user]"} ) However, I can't seem to get the strings/URL to work. I tried the following but always receive "ORA-12154: TNS:could not resolve the connect identifier specified". Is this possible? If so, what is the proper syntax? db = sqlalchemy.create_engine('oracle+cx_oracle://my_wallet_credential?user=proxy_to_user') db = sqlalchemy.create_engine('oracle+cx_oracle://my_wallet_credential?user=[proxy_to_user]') Thanks in advance for any help! -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAEFL0syDWBTjXKkRLViQSeTiOEphfsSdQG6KSwwSo7%3DEB1R3mQ%40mail.gmail.com.
