Page 1 of 1

How to create a SQLite database resource?

Posted: Fri Oct 05, 2018 11:19 am
by Support_Alisa
Question:

How do I create a SQLite database resource when SQLite does not connect through a IP address or port number?

Answer:

Unlike typical server/client databases, SQLite directly reads and writes its data to a single, ordinary disk file. In order to make a "connection" to a SQLite database, download the JDBC driver. I chose to use the one found on BitBucket (https://bitbucket.org/xerial/sqlite-jdbc).

In the JDBC driver section of the Database resource, please input org.sqlite.JDBC.

Due to the fact SQLite is a ordinary file, the JDBC URL points to the database file location. The database URL will always take on the following format jdbc:sqlite:database_file_location. On Windows, the default location of the database file is not in the SQLite install directory, but instead the user's AppData directory.

You will not need to input a User and Password.

See the screen shot below of a working SQLite resource.
sqlitedb.png
sqlitedb.png (20.51 KiB) Viewed 18931 times
From here, you can use your SQLite database resource in a project and query the SQLite Database just as you could any normal database.