The primary purpose of this dialect is to provide JDBC connection using provided driver(JAR).
Installing the dialect is straightforward:
python3 -m pip install sqlalchemy-jdbcapi
Set an environment variable export CLASSPATH=<path>/ojdbc8.jar:<path>/postgresql-42.2.9.jre7.jar
PostgressSQL:
from sqlalchemy import create_engine
create_engine('jdbcapi+pgjdbc://{}:{}@{}/{}'.format(username, password, <ip:host>', <database name>))
Oracle:
create_engine("jdbcapi+oraclejdbc://username:password@HOST:1521/Database")
OceanBase:
from urllib.parse import quote
user = quote('username@tenant#cluster')
create_engine("jdbcapi+oceanbasejdbc://user:password@HOST:2881/Database")
GenericJDBCConnection:
Set an environment variable `JDBC_DRIVER_PATH`
In theory every database with a suitable JDBC driver should work.
- SQLite
- Hypersonic SQL (HSQLDB)
- IBM DB2
- IBM DB2 for mainframes
- Oracle
- Teradata DB
- Netezza
- Mimer DB
- Microsoft SQL Server
- MySQL
- PostgreSQL
- many more...
Please submit bugs and patches. All contributors will be acknowledged. Thanks!
- 1.3.0 - 2023-08-23 - add oceanbase's Oracle mode support.
- 1.2.2 - 2020-10-16 - SSL Support from URL.
- 1.2.1 - 2020-09-9 - Minor fix.
- 1.2.0 - 2020-09-1 - Issue: PGarray not iterable.
- 1.1.0 - 2020-08-4 - Initial release.