How to create a SQLite database resource?

View some of the Frequently Asked Questions to our support staff. Included are some tips and tricks making this forum ideal for users getting started with GoAnywhere MFT. Note: Users can reply to existing topics but only our support staff can add new topics to this forum.
1 post Page 1 of 1

Support_Alisa

User avatar
Posts: 12
Joined: Thu Jul 26, 2018 2:03 pm

Post by Support_Alisa » Fri Oct 05, 2018 11:19 am
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 506 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.
Alisa Bohac
Support Analyst
e. goanywhere.support@helpsystems.com
p. 1.800.949.4696
w. HelpSystems.com
1 post Page 1 of 1