How to include SQLite database in executable Jar?

by

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.

More Related Contents:

  1. Most simple code to populate JTable from ResultSet
  2. “Could not find the main class” error when running jar exported by Eclipse
  3. How to populate JTable from ResultSet?
  4. JTextArea content is not printing in printer fully [closed]
  5. Providing white space in a Swing GUI
  6. Passing current Date
  7. Look and feel is not updating in Swing JTabbedPane
  8. Resizing issue with canvas within jscrollpane within jsplitpane
  9. WindowBuilder Design Tab incomplete in Eclipse
  10. How to close a Java Swing application from the code
  11. Sizes of frame icons used in Swing
  12. How to add checkboxes to JTABLE swing [closed]
  13. How to implement dynamic GUI in swing
  14. Progress Bar Java
  15. Adding image to Jbutton with foreground label
  16. “Comparison method violates its general contract!” – TimSort and GridLayout
  17. Which Android Data Storage Technique to use?
  18. Why does JPasswordField.getPassword() create a String with the password in it?
  19. SwingWorker, done() is executed before process() calls are finished
  20. Sorting rows by columns in JTable
  21. Why is Swing threading model considered wrong and how should it be? [closed]
  22. What is the correct way to do inserts/updates/deletes in Android SQLiteDatabase using a query string?
  23. JOptionPane Passing Custom Buttons
  24. JTable Right Align Header
  25. How to disable or highlight the dates in JCalendar
  26. Java Swing – Using JScrollPane and Having it scroll back to top
  27. Obtaining focus on a JPanel
  28. Setting divider location on a JSplitPane doesn’t work
  29. Clicking on a drawn object
  30. What is the purpose of using Java Layout Managers?

Leave a Comment