I've been using xerial solely because I can't get a hold of anyone at zentus through their mailing list - the mailing list seems to be broken and has been that way for a long time. I don't trust that anyone is active on their end, and cannot confirm whether or not zentus is reliable or still supported.
Xerial supports transactions, despite what you may read on other sites like the H2 database performance page. The creator or xerial posted a transaction test, and claims it works. I have had no problems using xerial and am quite pleased with sqlite and the jdbc driver. My requirements recently changed and we may need to use SEE, the security extension for sqlite. After having spoken with Dr. Hipp (creator of SQLite), he recommended that I use Christian Werner's JDBC driver compiled for the SEE extension. I have not asked zentus or xerial about their JDBC driver for the SEE extension. Dr. Hipp seems to trust Christian, but he (Dr. Hipp) has not used or heard of zentus or xerial. Christian's website seems to be very minimal, so I'm not quite sure how stable or well supported his driver is. In the end we'll probably be using Christian's driver FOR THE REQUIREMENT of using SEE. But without SEE, xerial is working perfectly for us, and I trust it. Julian On Mon, Nov 24, 2008 at 3:18 PM, Ribeiro, Glauber < [EMAIL PROTECTED]> wrote: > What is the current wisdom about the best JDBC driver to use for SQLite > in Linux? > > Thanks, > > glauber > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users