JDBC Connection for SQLAlchemy.

The primary purpose of this dialect is to provide JDBC connection using provided driver(JAR).

Installation

Installing the dialect is straightforward:

python3 -m pip install sqlalchemy-jdbcapi

Usage

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")

GenericJDBCConnection:

Set an environment variable `JDBC_DRIVER_PATH`

Supported databases

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...

Contributing

Please submit bugs and patches. All contributors will be acknowledged. Thanks!

Changelog

• 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.