Do I need to install SQLite for SQLiteJDBC to work?

Question

I think I'm just not "getting it." If I don't have SQLite that is already installed on my computer, and I want to write a Java application that uses the built-in database, and I load / import the SQLiteJDBC JAR into my project, is that all I need? Or do I need to install SQLite first and create a database file for my SQLiteJDBC code to connect and execute queries?

If this is the case, and it is not enough to load / import SQLiteJDBC, does this not mean that I will need to make sure that SQLite is installed on every system on which I want to run a Java application? And doesn't that destroy the purpose of the portable / embedded database?

Basically, they pull me into SQLiteJDBC tutorials because:

• They do not tell you how HelloWorld.sqlite is created (does SQLiteJDBC create it for you, you need to first create it in SQLite from the command line, etc.); and
• They never specify whether SQLiteJDBC depends on SQLite for API calls to work.

Any help here is much appreciated!

Answer 1

You must put the SQLLite JAR in the CLASSPATH of your application. There is no "installation".

Perhaps this tutorial can help you.

Here's another one that shows how to create a database and tables.