SQLite Java wrapper/JDBC Driver (Collection)

This is a Java wrapper including a basic JDBC driver for the SQLite 2/3 database engine. it is designed using JNI to interface to the SQLite API. that API is wrapped by methods in the SQLite. database Class. since June, 2002, it has des a small JDBC driver, which allows the most basic things to be carried out usingJava. SQLPackage. Since September, 2004, sqlite3 (minimum 3.0.7) is supported. The JNI part can be generated to include support for both SQLite 2.x and 3.x and detects at runtime the type of the database.

The current source tarball can be downloaded from javasqlite-20120209.tar.gz. it has been tested on Linux, using SQLite 2.8.17 and 3.7.9, and JDK 1.4/1.5/1.6 from sun. the change log starting from August 2007 is here.

For rebuilding the following requirements must be met:

• SQLite 2.4.12 or higher
• JDK 1.1 or higher
• C compiler and make

to override the directory where configure looks for SQLite and JDK the configure options -- With-SQLite = dir , -- with-sqlite3 = dir , and -- With-JDK = dir can be used. to specify the place where the native Library (the libsqlite_jni.so file) shall be installed, use the -- prefix = dir option. the default place is /usr/local/lib , I. e. the prefix defaults to /usr/local . to specify where the SQLite. jar file containing the High-level part and the JDBC driver shall be installed, use the -- With-jardir = dir option. the default is /usr/local/share/Java . at runtime, it is necessary to tell the JVM both places with the -classpath and -djava. library. path = .. command line options. optionally, the native part is searched using the path prefix specified in the -dsqlite. library. path = .. property, which has precedence over -djava. library. path = .. .

For Win32 (NT4 or above) the makefilesJavasqlite. Mak,Javasqlite23.mak, AndJavasqlite3.makAre provided in the source archive. These makefiles contain some build instructions and use the j2se 1.4.2 from sun and ms visual c ++ 6.0.

A dll with the native JNI part (including SQLite 3.7.7.1) and the JAR file with the Java part can be downloaded from javasqlite-20110827-win32.zip.

Reprinted:

Http://www.ch-werner.de/javasqlite/