SQLJet is an open source software library that provides API that enables Java applications to access and modify mostly any of SQLite-created and managed databases.

Here are some key features of "SQLJet":

· Fine-grained API to create, access and modify SQLite databases.
· Database format is fully compatible with SQLite 3.6.
· No native binaries are needed.
· Runs on JVM 1.5 or newer.
· Current version only supports SQL in schema.

Requirements:

· Java 1.5 or later

What's New in This Release: [ read full changelog ]

New features:
· Busy handlers support added (-r768).
· Support of temporary and in memory databases added (-r842).
· Support of virtual tables in schema added (-r847).
· SqlJet OSGi bundle and source tarball available from the web site (-r876).

API changes:
· New runtime prerequisite added: all cursors must be opened within active transaction (-r709).
· New method SqlJetDb.refreshSchema() added to the public API (-r698).
· SqlJetTransaction mode enum and ISqlJetMutex interface moved to the public API (-r858, -r852, -r845).

Bugfixes:
· Database is locked only when it is actually needed, not on opening (-r773).
· Performance improvements (-r846).
· Schema: Quoted identifiers are properly processed now (-r819, -r848).
· Schema: NULL column constraint supported (-r818).
· Calling SqlJetDb.open(...) after SqlJetDb.close() didn't work, fixed (-r842).
· Javadoc updates (-r839, -r845).
· Better error message on schema parsing failure (-r844).
· Exception is thrown now on lexer error when parsing schema (-r854).