Skip to main content

Python SQLAlchemy Dialect for JDBCAPI.

Project description

https://img.shields.io/pypi/dm/sqlalchemy-jdbcapi.svg

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.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

sqlalchemy_jdbcapi-1.2.2.tar.gz (5.6 kB view details)

Uploaded Source

Built Distribution

sqlalchemy_jdbcapi-1.2.2-py3-none-any.whl (6.6 kB view details)

Uploaded Python 3

File details

Details for the file sqlalchemy_jdbcapi-1.2.2.tar.gz.

File metadata

  • Download URL: sqlalchemy_jdbcapi-1.2.2.tar.gz
  • Upload date:
  • Size: 5.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for sqlalchemy_jdbcapi-1.2.2.tar.gz
Algorithm Hash digest
SHA256 59a2c90ae34df67b74a0658d6350c0dc174bfd252513cb5022a515919d8fce9f
MD5 5402f1ce64692ee1c8a9dc0f06cc3ffb
BLAKE2b-256 4f076477cfb3b16c0abea0f2ecb815a40f29502a8302bd98f6f68321e4059efd

See more details on using hashes here.

File details

Details for the file sqlalchemy_jdbcapi-1.2.2-py3-none-any.whl.

File metadata

  • Download URL: sqlalchemy_jdbcapi-1.2.2-py3-none-any.whl
  • Upload date:
  • Size: 6.6 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: twine/1.15.0 pkginfo/1.5.0.1 requests/2.24.0 setuptools/49.2.1 requests-toolbelt/0.9.1 tqdm/4.48.2 CPython/3.8.5

File hashes

Hashes for sqlalchemy_jdbcapi-1.2.2-py3-none-any.whl
Algorithm Hash digest
SHA256 96fe112c2834727b771d6b013085669a70e8548f76b34b77918788a4610d1b44
MD5 a06a5a189b7215a10615ca3efc6063e8
BLAKE2b-256 a7d3265d8037adedad4999eca23ba3c83acc48c44a136457413759a9eb116fd8

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page