Connect to multiple Oracle DBs via LDAP

[Syrrius78]

hi,

i'm using sqlalchemy 1.3.12.

For a project, I try to connect to multiple oracle databases via LDAP (different LDAP url & context) .

it's working fine for 1 database : cx_Oracle dialect + sqlnet.ora & ldap.ora files.

Problem with this method : it seems we can declare only 1 database (impossible to declare multiple LDAP context)

Does someone have an idea how to do that ?

OR

maybe there is a way to do JDBC connection with SQLAlchemy ?

thanks in advance for your help.

[Mike Bayer]

sounds like a cx_Oracle issue ?   I don't really understand what this means.    A particular Engine can only connect to one database at a time in any case.     Contact cx_Oracle devs at https://github.com/oracle/python-cx_Oracle/issues

Python doesn't support JDBC unless you're using Jython which SQLAlchemy isn't supporting right now.

--

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+...@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/sqlalchemy/d37e6923-be55-49ad-9cda-864823373ecfo%40googlegroups.com.

[Syrrius78]

oki thanks a lot. I'll send a message to the cx_Oracle devs.