Skip to main content
Help improve PyPI by participating in a 5-minute user interface survey!

A bridge from JDBC database drivers to Python DB-API.

Project Description

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 has been tested with Hypersonic SQL (HSQLDB) and IBM DB2 for z/OS.

In contrast to zxJDBC from the Jython project JayDeBeApi let’s you access a database with Jython AND Python with only minor code modifications. JayDeBeApi’s future goal is to provide a unique and fast interface to different types of JDBC-Drivers through a flexible plug-in mechanism.


You can get and install JayDeBeApi with easy_install

$ easy_install JayDeBeApi

If you want to install JayDeBeApi in Jython make sure to have EasyInstall available for it.

Or you can get a copy of the source branch using bzr by running

$ bzr branch lp:jaydebeapi

and install it with

$ python install

or if you are using Jython use

$ jython install

It has been tested with Jython 2.5.2.

If you are using cPython ensure that you have installed JPype properly. It has been tested with JPype 0.5.4.


Basically you just import the jaydebeapi Python module and execute the connect method. This gives you a DB-API conform connection to the database.

The first argument to connect is the name of the Java driver class. The rest of the arguments are internally passed to the Java DriverManager.getConnection method. See the Javadoc of DriverManager class for details.

Here is an example:

>>> import jaydebeapi
>>> conn = jaydebeapi.connect('org.hsqldb.jdbcDriver',
...                           'jdbc:hsqldb:mem', 'SA', '')
>>> curs = conn.cursor()
>>> curs.execute('create table CUSTOMER'
...                '("CUST_ID" INTEGER not null,'
...                ' "NAME" VARCHAR not null,'
...                ' primary key ("CUST_ID"))'
...             )
>>> curs.execute("insert into CUSTOMER values (1, 'John')")
>>> curs.execute("select * from CUSTOMER")
>>> curs.fetchall()
[(1, u'John')]

You probably have to configure Jython or JPype to actually be able to access the database driver’s jar files. If I want to connect to a HSQL in memory database on my Ubuntu machine I’m starting Python by running

$ JAVA_HOME=/usr/lib/jvm/java-6-openjdk python

Now I have to configure JPype

>>> jar = '/path/to/my/driver/hsqldb.jar'
>>> args='-Djava.class.path=%s' % jar
>>> jpype.startJVM(jvm_path, args)

or in Jython I have to

>>> jar = '/path/to/my/driver/hsqldb.jar'
>>> import sys
>>> sys.path.append(jar)


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


JayDeBeApi is released under the GNU Lesser General Public license (LGPL). See the file COPYING and COPYING.LESSER in the distribution for details.


  • 0.1
    • Initial release

To do

  • Extract Java calls to seperate Java methods to increase performance.
  • Check if can help making JayDeBeApi more DB-API complient.
  • Test it on different databases and provide a flexible db specific pluign mechanism.
  • SQLAlchemy modules (seperate project)

Release history Release notifications

History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


History Node


This version
History Node


Download files

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

Filename, size & hash SHA256 hash help File type Python version Upload date
JayDeBeApi-0.1.tar.gz (6.0 kB) Copy SHA256 hash SHA256 Source None Aug 16, 2010

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging CloudAMQP CloudAMQP RabbitMQ AWS AWS Cloud computing Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page