Monday, July 5, 2010

Help me test my BSD licensed JDBC driver for Drizzle and MySQL

I'm developing Drizzle-JDBC which is a BSD licensed JDBC driver for both MySQL and Drizzle. The goal is to build a maintainable, "light weight" JDBC driver with a permissive license (it is hard to be truly light weight when implementing the massive JDBC interfaces).

Now what I really need is beta testers. I don't expect anyone to use it in production, but it would be great if you could try it with any existing application by just placing the .jar on the class path, changing the connection string, and running your test suites/load tests etc. Report any issues to me at launchpad.

Also, I need some inspiration, are there any features you have wanted to see in a JDBC driver? Cloud aware (if anyone wants this, please define it for me :) )? Plug-in system for query optimization etc?

How to help:

  • Download Drizzle-JDBC 0.7 and place it on your classpath, or, if you use maven, add this dependency to your pom.xml:
    <dependency>
      <groupId>org.drizzle.jdbc</groupId>
      <artifactId>drizzle-jdbc</artifactId>
      <version>0.7</version>
    </dependency>
  • Change the connection string to the form:
    jdbc:mysql:thin://<username>:<password>@<hostname>:<port>/<schema>
    (if your tooling needs to do a Class.forName, the driver classname is org.drizzle.jdbc.DrizzleDriver)
  • Run your test suite
  • When anything unexpected happens, post a bug report at launchpad, preferably with a stack trace and the test case that triggered the error (or send me an email at krummas@gmail.com if you don't have a launchpad account and don't want one).

Or...

Tell me about a feature you would really like to see in a JDBC driver! (well, better performance and bug free would of course be nice features, but that is what I want to achieve from the previous section)

Sunday, July 4, 2010

Drizzle JDBC 0.7

Just pushed Drizzle JDBC 0.7 to the maven repository, it contains bug fixes and features both for the MySQL and Drizzle support;
  • Support user name and password in Properties when connecting.
  • A lot of datatype fixes thanks to the guys at Continuent and their Connector test suite.
  • Initial implementation of ParameterMetadata.
  • Fix umlaut bug reported by Christian Peter.
  • Fix getTables to work properly after bug report from Christian Peter.
  • Allow zero-length passwords, bug reported by Christian Peter.
  • Throw proper exception when connection to server times out.
  • Implementation of setObject with type conversions.
The binaries are in the central maven repository, http://repo1.maven.org/maven2/org/drizzle/jdbc/drizzle-jdbc/0.7/. Or, if you use maven, add the following to your pom.xml:
<dependency>
<groupId>org.drizzle.jdbc</groupId>
<artifactId>drizzle-jdbc</artifactId>
<version>0.7</version>
</dependency>

The code is in launchpad.