How to transfer and run Java applications with a SQLite database on another computer?

Looking for details:

  • How and where to prescribe the path (relative, absolute)?
  • What folders should be in? etc.

    1 answer 1

    When building a project in the lib folder, the necessary libraries will be added. Ways to you in the code itself, when connecting to the database you need to specify. Relative more correctly. To transfer to another computer, it will be enough to copy the jar-file, databases and the lib folder into one directory. The SQLite databases themselves are usually stored in files with the extension "s3db".

    • instead of this path: String url = "jdbc: sqlite: C: \\ db2 \\ testDB"; it's better to specify: String url = "jdbc: sqlite: \\ db2 \\ testDB"; ??? if (conn == null) {conn = DriverManager.getConnection (url); } - Lujok