Sqlite-jdbc; Downloads Downloads; Tags; Branches. SQLite JDBC Driver. SQLite JDBC, developed by Taro L. Saito, is a library for accessing and creating SQLite database files in Java. Our SQLiteJDBC library requires no configuration since native libraries for major OSs, including Windows, Mac OS X, Linux etc., are assembled into a single JAR (Java Archive) file. The SQLite JDBC driver can load a SQLite database from file system or creates one in memory. Here is the syntax of database connection URL for file system database.
SQLDroid is a JDBC driver for Android's sqlite database (android.database.sqlite.SQLiteDatabase) originally conceived by Kristian Lein-Mathisen. See http://sqldroid.org/.
SQLDroid lets you access your app's database through JDBC. Android ships with the necessary interfaces needed to use JDBC drivers, but it does not officially ship with a driver for its built-in SQLite database engine. When porting code from other projects, you can conveniently replace the JDBC url to jdbc:sqlite to access an SQLite database on Android.
Java Connect To Sqlite Database
The SQLDroid JAR with the JDBC driver for Android is 33KB. We also offer a RubyGem 'sqldroid' for use with Ruboto.
Community
Sqlite Jdbc Driver Name
- Project site: https://github.com/SQLDroid/SQLDroid
- Mailing list: http://groups.google.com/group/sqldroid
- Wiki: https://github.com/SQLDroid/SQLDroid/wiki
- Old project site: http://code.google.com/p/sqldroid
Download
You can use SQLDroid in you maven project by declaring this dependency:
Or if you're using gradle:
Binary distributions are available for download from the Maven Central Repository: http://search.maven.org/#search%7Cga%7C1%7Csqldroid
Usage
Here is a minimal example of an Android Activity implemented in Java with SQLDroid.
You can find an example of how to use SQLDroid with ActiveRecord on Ruboto here:
Debug output
Sqlite Jdbc Driver Download
You can set the SQLDroid log output level like this
You can turn on resultset dumps like this
Building
The SQLDroid JAR file is a straight collection of the compiled classes. If you have Ruby installed,you can generate the JAR using
rake jar
To make a gem for use with Ruboto run
rake gem
To release the gem to rubygems.org (requires permissions on rubygems.org) run
rake release
Java Sqlite Tutorial
Building with mvn
SQLDroid is a normal Maven project. If you have Android 21 installed (sdkmanager --install platforms;android-21), you can generate the JAR using
mvn install
To release the jar to Maven Central (requires permissions and a PGP key) first tag the release version
mvn -Prelease release:prepare
Then deploy the artifact to Maven Central
mvn -Prelease release:perform