The SQLite JDBC drivers included with ADS works with SQLite3. SQLite server releases are frequent, and may sometimes require updating the JDBC driver.
Contents
Driver Location
You may locate the latest SQLite JDBC drivers at the following location ...
Vendor: Xerial
Driver URL: http://www.xerial.org/maven/repository/artifact/org/xerial/sqlite-jdbc
Updating Driver Contents for use SQLite
To update the Aqua Data Studio JDBC drivers for SQLite you need to overwrite the Aqua Data Studio sqlite-jdbc.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...
WINDOWS
[ADS_INSTALL]\lib\drivers\sqlite-jdbc.jar
C:\Program Files\Aqua Data Studio 20.0 - 64bit\lib\drivers>dir Volume in drive C has no label. Volume Serial Number is 70B3-F581 Directory of C:\Program Files\Aqua Data Studio 20.0 - 64bit\lib\drivers 04/04/2019 11:21 AM <DIR> . 04/04/2019 11:21 AM <DIR> .. 04/02/2019 08:23 AM 15,364 cassandra-clientutil-extras.jar 04/02/2019 08:23 AM 36,549 cassandra-clientutil.jar 04/02/2019 08:23 AM 228,286 cassandra-jackson-core-asl.jar 04/02/2019 08:23 AM 765,648 cassandra-jackson-mapper-asl.jar 04/02/2019 08:23 AM 1,073,177 cassandra-thrift.jar 04/02/2019 08:23 AM 4,234,170 db2jcc4.jar 04/02/2019 08:23 AM 1,015 db2jcc_license_cu.jar 04/02/2019 08:23 AM 3,232,770 derby.jar 04/02/2019 08:23 AM 588,394 derbyclient.jar 04/02/2019 08:23 AM 272,626 derbynet.jar 04/02/2019 08:23 AM 199,010 google-api-client.jar 04/02/2019 08:23 AM 107,293 google-api-services-bigquery-v2.jar 04/02/2019 08:23 AM 6,672 google-http-client-jackson2.jar 04/02/2019 08:23 AM 356,261 google-http-client.jar 04/02/2019 08:23 AM 10,776 google-oauth-client-java6.jar 04/02/2019 08:23 AM 5,799 google-oauth-client-jetty.jar 04/02/2019 08:23 AM 61,116 google-oauth-client.jar 04/02/2019 08:23 AM 18,438,062 hive-exec.jar 04/02/2019 08:23 AM 93,137 hive-jdbc.jar 04/02/2019 08:23 AM 5,273,347 hive-metastore.jar 04/02/2019 08:23 AM 1,860,639 hive-service.jar 04/02/2019 08:23 AM 963,515 ifxjdbc.jar 04/02/2019 08:23 AM 259,809 interclient.jar 04/02/2019 08:23 AM 1,873,815 jconnect16.jar 04/02/2019 08:23 AM 539,912 jetty-6.jar 04/02/2019 08:23 AM 177,131 jetty-util.jar 04/02/2019 08:23 AM 4,739,226 jt400.jar 04/02/2019 08:23 AM 549,861 jtds-src.jar 04/02/2019 08:23 AM 373,875 jtds.jar 04/02/2019 08:23 AM 585,828 mariadb.jar 04/02/2019 08:23 AM 2,223,387 mongo.jar 04/02/2019 08:23 AM 2,718,518 mysql-src.jar 04/02/2019 08:23 AM 1,004,838 mysql.jar 04/02/2019 08:23 AM 4,036,257 ojdbc8.jar 04/02/2019 08:23 AM 1,661,088 orai18n.jar 04/02/2019 08:23 AM 415,357 paraccel-jdbc.jar 04/02/2019 08:23 AM 38,354,188 phoenix.jar 04/02/2019 08:23 AM 790,405 postgresql.jar 04/02/2019 08:23 AM 6,573,928 redshift.jar 04/02/2019 08:23 AM 15,818,611 snowflake.jar 04/02/2019 08:23 AM 6,672,489 sqlite-jdbc.jar 04/02/2019 08:23 AM 1,111,548 sqljdbc42.jar 04/02/2019 08:23 AM 287,555 util400.jar 04/02/2019 08:23 AM 9,038,592 voltdb.jar 04/02/2019 08:23 AM 259,806 xdb6.jar 04/02/2019 08:23 AM 1,420,339 xmlparserv2.jar 04/02/2019 08:23 AM 779,974 zookeeper.jar 47 File(s) 140,089,963 bytes 2 Dir(s) 25,725,767,680 bytes free C:\Program Files\Aqua Data Studio 20.0 - 64bit\lib\drivers>
LINUX
[ADS_INSTALL]/lib/drivers/sqlite-jdbc.jar
OSX
Aqua Data Studio.app/Contents/Java/drivers/sqlite-jdbc.jar
The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.