3.21 SQLite JDBC Drivers

JDBC Drivers - SQLite JDBC Drivers

Aqua Data Studio (ADS) supports SQLite Database Schema. SQLite is a very popular free embedded SQL database engine.

You can get more information about SQLite Database and SQLite Driver here

Vendor: SQLite
Download Page: http://www.sqlite.org/download.html
Driver URL: http://www.zentus.com/sqlitejdbc

SQLite tutorial for Aqua Data Studio to Connect SQLite Database

The entire database is stored as a single cross-platform file on a host machine. SQLite locks the database file at the beginning of a transaction. SQLite uses SQL DBMS. 

Create Server Group	Register a SQLite Server	Enter Properties	Locate SQLite Driver

SQLite Driver Properties	SQLite Server in ADS	SQLite Schema	Creating tables in SQLite

 To connect to SQLite Database using Aqua Data Studio 7.0 :

• Download SQLite JDBC driver from the url given above to your local machine. There is a Windows, MacOS X and Linux x86/amd64 SQLite JDBC driver version
• Create a new server Group and name it as SQLite
• Right Click on server group and click on the the Item which displays Register Server
• Provide a new name for the SQLite Server
  
• In the General tab, pick Generic - JDBC
• Specify a URL. Enter "jdbc:sqlite:C:\SQLite\SampleDB.db" where SampleDB is the SQLite database you want to Connect to
• Provide "org.sqlite.JDBC" in the Driver field
• Locate the the downloaded driver by clicking on Browse

The SQLite Database server is registered successfully in Aqua Data Studio and You can now connect to the newly registered Server and perform Data Manipulations.