<p>I'm attracted to the neatness that a single file database provides. What driver/connector library is out there to connect and use SQLite with Java.</p>

<p>I've discovered a wrapper library, <a href="http://www.ch-werner.de/javasqlite/" rel="noreferrer">http://www.ch-werner.de/javasqlite</a>, but are there other more prominent projects available?</p>

The
wiki
lists some more wrappers:
Java wrapper (around a SWIG interface):
http://tk-software.home.comcast.net/
A good tutorial to use JDBC driver for SQLite. (it works at least !)
http://www.ci.uchicago.edu/wiki/bin/view/VDS/VDSDevelopment/UsingSQLite
Cross-platform JDBC driver which uses embedded native SQLite libraries on Windows, Linux, OS X, and falls back to pure Java implementation on other OSes:
https://github.com/xerial/sqlite-jdbc
(formerly
zentus
)
Another Java - SWIG wrapper. It only works on Win32.
http://rodolfo_3.tripod.com/index.html
sqlite-java-shell: 100% pure Java port of the sqlite3 commandline shell built with NestedVM. (This is not a JDBC driver).
SQLite JDBC Driver for Mysaifu JVM: SQLite JDBC Driver for Mysaifu JVM and SQLite JNI Library for Windows (x86) and Linux (i386/PowerPC).