Musings from The Software Underground

I just downloaded the latest version of the Zentus SQLite JDBC driver, and I can say that once again, SQLGrinder has a good driver that can be used for your SQLite work.

Earlier versions of this driver allowed the use of the SQL editor, but now the schema browser works well too.

To use this driver, you just need to download the Mac OS X version, extract the archive, put the files sqlitejdbc-native.jar and libsqlitejdbc.jnilib in Library/Java/Extensions, and start up SQLGrinder. Finally, you just need to set the compatibility setting to JDBC 1 in Connection > Settings and set Autocommit to true. That should be it. Many thanks to David Crawshaw for his work on this.

[Update] SQLGrinder doesn't yet come with the configuration information for this driver built in. Here are the values I'm currently using -- Name: SQLite 3, Base class: org.sqlite.JDBC, URL prefix: jdbc:sqlite. Just add a JDBC driver configuration in Preferences and use these values and the driver should load.[/Update]

For additional information, see this post as well: Using SQLite with SQLGrinder 2