[DB-SIG] jdbc proxy + python driver

Randall Smith randall at tnr.cc
Thu Jul 14 17:34:39 CEST 2005


Since I ran across type 4 JDBC drivers, I've liked the idea of their 
portability and lack of dependencies.  I even started work on one for 
Python and am so far pleased with it.  But what about databases for 
which a pure Python driver can't be built?  Say Oracle, who's protocol 
is proprietary and undocumented (I can't find any documentation.). 
Unless Oracle makes the protocol public or some protocol guru reverse 
engineers it (which I think is against their license agreement), we'll 
never have one.

It's been suggested to use the JDBC drivers from Jython or Jython + 
XMLRPC to use in CPython.  I've never liked that idea much. What about 
using a Java JDBC Proxy + Python Driver for the API.  Something like SQL 
Relay, but more simple and written in Java.  It would use the type 4 
JDBC drivers and expose an API.  Then a Python driver would exist to use 
the service.  What I like about this is that the only non-Python 
dependencies are a JVM and the proxy server.  Many systems already have 
a JVM installed.  They entire process including the proxy startup and 
shutdown could be controlled from inside of the Python application 
making it easy to package.

Does this exist?  I did some googling, but didn't turn up anything close 
enough.

Randall


More information about the DB-SIG mailing list