[Biopython-dev] zxJDBC support for BioSQL

[Peter]

On Thu, Dec 17, 2009 at 10:46 AM, Peter <biopython at maubp.freeserve.co.uk> wrote:
> On Thu, Dec 17, 2009 at 1:39 AM, Kyle Ellrott <kellrott at gmail.com> wrote:
>>
>> I've push pushed a patch to the BioSQL code that enables zxJDBC support.
>> This means that Jython can now run BioSQL through mysql.  (SQLite hasn't
>> been ported to Java yet)
>> zxJDBC is a Jython module included in the standard distribution that
>> provides a PythonDB interface through the java sql interfaces.  I've only
>> ran the unit tests using the mysql-connector, but it should theoretically
>> work with Oracle as well.
>
> Sounds good, and ought to work on PostgreSQL too in theory.
>
> I should be able to test it on MySQL.

I worked out I needed to install MySQL Connector/J  so that
org.gjt.mm.mysql.Driver works in Jython, get it from here:
http://dev.mysql.com/downloads/connector/j/

Installation seems to be just unzipping this and updating your
CLASSPATH environment variable to point at the jar file.

Peter