Generic/Common JDBC connection for multiple datbases.

[daneshpatel]

create_engine("jdbcapi+basic://username:password@HOST:1521/Database?database=mysql")

[youmu1]

how to connection with mysql?

[singh-abhijeet]

@daneshpatel Trying the jdbc+basic gives following error:
sqlalchemy.exc.NoSuchModuleError: Can't load plugin: sqlalchemy.dialects:jdbcapi.basic

I also went through this project's codebase (v1.2.2) and I noticed only 2 dialects have been registered - OracleJDBC and PGJDBC in sqlalchemy_jdbcapi\__init__.py

How to invoke generic JDBC connection? Please provide a sample code snippet.

[AbdealiLoKo]

I'm looking for the same - to connect with MS SQL - any pointers appreciated

[maximilianodelbono]

@AbdealiLoKo did you ever find a way to connect MSSQL with JDBC using sqlalchemy? I had tried a few things here but had no luck. I would appreciate any updates on it.

[AbdealiLoKo]

@maximilianodelbono nope, I was never able to get it to work.
Eventually used the odbc and pymssql drivers