3.20 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.
|
