JDBC Driver for SQLite 006 review

JDBC Driver for SQLite is a thin layer on top of the SQLite 3.3.x C API

License: BSD License File size: 0K Developer: David Crawshaw

0

JDBC Driver for SQLite is a thin layer on top of the SQLite 3.3.x C API. The native JNI library has SQLite compiled into it so all you need to do is include the two files packaged above in your project.

Usage:

Download the binary for the platform you are developing on. Open the tarball and copy the two files into your application directory:

sqlitejdbc.jar
[lib]sqlitejdbc.[dll, so, jnilib]

Reference the driver in your code:

Class.forName("org.sqlite.JDBC");
Connection conn = DriverManager.getConnection("jdbc:sqlite:filename");
// ... use the database ...
conn.close();

And call your program with the driver's JAR file in the classpath and the C library in the librarypath. E.g.

java -cp lib/yourprog.jar:lib/sqlitejdbc.jar
-Djava.library.path=lib
yourprog.Main

What's New in This Release:
The driver is now thread-safe and fully supports UTF-16.
There are binaries for Mac OS, Linux, and Windows, and instructions for compiling with MSVC.