JDBI is a jpython module that can connect to any database that supports jdbc. I'm trying to make it DB-API spec v2.0 compatible.
OK. I hate dates, and I'm sure it don't throw correct exceptions. Feel free to send me corrections.
To test for compatibility with other 2.0 database modules, I've created dbtest.py, and found a lot of bug's. The result of a run can be viewed here (afet bug's fixed :-)
cPython is allot faster, jdbi should probably be re-written in java or...?
2000-06-21 jdbi-0.4.tar.gz
Un tar, and copy jdbi.py to jpython/Lib, or keep it in your working directory
>>> import jdbi
>>> c = jdbi
>>> con = c.connect("postgresql.Driver","jdbc:postgresql://127.0.0.1/database?user=rorschach&password=secret")
>>> cursor = con.cursor()
>>> cursor.execute("select * from table where id = ?", [4711])
>>> print cursor.fetchone()
(4711, "demo", 2000-06-16)
timing - port of timing from cPython, used in dbtest.py. Included in the jdbi tarball
Sverre Stoltenberg -- <sverres1@start.no>
$Id: index.html,v 1.5 2000/06/21 19:31:50 sverrest Exp $