SQLGrinder and SQLite
.jpg)
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.
For additional information, see this post as well: Using SQLite with SQLGrinder 2
2 Comments:
For those of you who, like me, spent an hour trying to figure out how to get this driver to work, it looks like Michael already specified some additional settings that should be adjusted. See his comment here.
This worked. The directions in the User Guide (and on the "for additional information" page) do not work!
I almost didn't buy SQLGrinder because it didn't appear to support SQLite. I only found this page using a Google search. You guys really ought to bundle the SQLite driver or update the instructions in the User Guide. The Zentus driver is BSD licensed, so there's nothing stopping you from bundling it with SQLGrinder.
Post a Comment
<< Home