How to include SQLite database in executable Jar?

Question

I have created a Swing application that uses SQLite as a local database. The database file is located in project's root directory.

Project/DatabaseFile

The application runs fine on Eclipse, but when I run the packaged executable Jar, I get the following error:

No such table : table1

This means that the database is not reachable. When I examined the contents of the resulting JAR file, the database file was not there anymore.

In the code, I've linked the database as follows:

jdbc:sqlite:DatabaseFile

My question is, how to include the SQLite database in the executable Jar?

EDIT

When I placed the DB file in the source Folder Project/src/DatabaseFile and changed the path to jdbc:sqlite:src/DatabaseFile, it worked on Eclipse but again when running the Jar file as java -jar Project.jar. It said:

path to 'src/DatabaseFile': 'C:\Users\name\src' does not exist

I think I need to specify a relative path for the database.

EDIT

This is how I connect to the database:

public Connection getConnection(){      
    try{
        Class.forName("org.sqlite.JDBC").newInstance();             
        con = DriverManager.getConnection("jdbc:sqlite:src/DatabaseFile");              

    } catch (Exception e) {
        Log.fatal("Méthode: getConnection() | Class  : SQLiteConnection | msg system : " + e.getMessage());
    }
    return con;
}

Had you added this jar file to the Source Folder inside the Project ? I guess that might can help. I hope this answer might can help you a bit. — nIcE cOw
– nIcE cOw, Commented Aug 18, 2012 at 16:01
I added the database in the src folder (see update). Is there any way to connect to the database as a file instead of using con = DriverManager.getConnection("jdbc:sqlite:src/DatabaseFile"); ? — Momo
– Momo, Commented Aug 18, 2012 at 17:35
Source Folder doesn't mean arc Folder, instead right click your project -> New -> Source Folder. I am not near my PC, else might have looked at it myself, to at least provide you with working example. — nIcE cOw
– nIcE cOw, Commented Aug 18, 2012 at 18:12
I had tried to do this with my SQL Server Drivers on Eclipse, I found out how to add the .jar to your project. Shall I describe the steps to you as an answer, since it will be in detail then all steps one by one. You can change the connection code and .jar file with your respective stuff. — nIcE cOw
– nIcE cOw, Commented Aug 19, 2012 at 8:49

dsh · Accepted Answer · 2012-08-19 15:40:32Z

46

What library are you using for SQLite?

I did a search based on the connection URI you indicated and found this one. In the documentation it says:

2009 May 19th: sqlite-jdbc-3.6.14.1 released. This version supports "jdbc:sqlite::resource:" syntax to access read-only DB files contained in JAR archives, or external resources specified via URL, local files address etc. (see also the detailes)

If that is the driver you are using, then I would suggest the following connection URI:

"jdbc:sqlite::resource:DatabaseFile"

The key is that since your database is in a jar file, it can not be access as a file with FileInputStream. Instead it must be accessed through the JVM's support for it (namely with Class.getResource() or Class.getResourceAsStream()). Do note that resources contained within jar files are read-only. You won't be able to save any changes to your database.

answered Aug 19, 2012 at 15:40

dsh

12.3k3 gold badges37 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Momo Over a year ago

I was using sqlitejdbc-v056. So I changed it to sqlite-jdbc-3.6.14.1 and I connected to the database with this path "jdbc:sqlite::resource:DatabaseFile" (the database file is under src folder). It worked fine in Eclipse AND in the exporter Jar. Thanks

tricknology · Accepted Answer · 2013-03-07 06:29:22Z

3

I have found two different ways to name the filepath depending on how you are trying to access it. Assuming you are accessing the db is located in /yourproject/resource/ or /yourproject/bin/resource ( havent narrowed it down, mine is in both and I'm happy with it) you should use this as your path:

//Eclipse test path
String url = "jdbc:sqlite:resource/mydb.db";

or

//runnable jar path
String url = "jdbc:sqlite::resource:mydb.db";

then

mysqlitedatasource.setUrl(url);

Your way also works... by putting the db in /src

edited Mar 7, 2013 at 6:29

answered Mar 7, 2013 at 6:19

tricknology

1,1481 gold badge15 silver badges27 bronze badges

Collectives™ on Stack Overflow

How to include SQLite database in executable Jar?

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related