"oracle://[proxy_to_user]@my_wallet" worked! Thanks again.
On Thu, Nov 14, 2019 at 2:14 PM Mike Bayer <[email protected]> wrote: > > > On Thu, Nov 14, 2019, at 2:52 PM, Chris Stephens wrote: > > 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]') > > > "user" is the first argument after the //. oracle://proxy_to_user@ > /my_wallet > > > > > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/CAEFL0syDWBTjXKkRLViQSeTiOEphfsSdQG6KSwwSo7%3DEB1R3mQ%40mail.gmail.com > <https://groups.google.com/d/msgid/sqlalchemy/CAEFL0syDWBTjXKkRLViQSeTiOEphfsSdQG6KSwwSo7%3DEB1R3mQ%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/sqlalchemy/0ead4a70-1a28-42ce-be86-4cd4dbd338d1%40www.fastmail.com > <https://groups.google.com/d/msgid/sqlalchemy/0ead4a70-1a28-42ce-be86-4cd4dbd338d1%40www.fastmail.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/CAEFL0szX_fVrsRXWd3%2BYbkGVoHsVa88PfYGL-8JUZx8Tvob0qg%40mail.gmail.com.
