Menu
How do you connect to a database using a JDBC driver from within Python 3? JayDeBeApi seems to do the job for Python 2, but at the moment it isn't Python 3-compatible.
This question is similar to this one, but I am asking specifically about Python 3.
669
The JayDeBeApi module allows you to connect from Python code to databases using Java JDBC. It provides a Python DB-API v2. 0 to that database. It works on ordinary Python (cPython) using the JPype Java integration or on Jython to make use of the Java JDBC driver.
It is surprised to know SQLAlchemy does not have direct JDBC support and JayDeBeAPI does not have a dialect after 3 years. Not mean to complain.
ODBC is an SQL-based Application Programming Interface (API) created by Microsoft that is used by Windows software applications to access databases via SQL. JDBC is an SQL-based API created by Sun Microsystems to enable Java applications to use SQL for database access.
As I can not delete this answer, I will edit it:
Way back when, I created a Python3-port of JayDeBeApi. But as the other answer points out, the official JayDeBeApi now supports Python3 as well.
132
Starting from version 0.2 the official JayDeBeApi now supports Python 3 as well. It is still backwards compatible with Python 2 and Jython.
33
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
