Set relative path using jdbc, on a sqlite DB on user computer

Question

I'm trying to build a simple java application for my school project, and I want to be able to use a simple DB, in order to insert, update, delete and ask queries on my DB.

I need my application to run everywhere on installation, so I want to use a local DB that ships with my application, and will be accessible from inside the project, without different DB dependencies

so I've read a little and found this SQLite tutorial -http://www.sqlitetutorial.net/sqlite-java/sqlite-jdbc-driver/

, now I want to set a relative path to the user who download my application, and set the connection on the user computer. I've noticed it's written :

connect to an in-memory database, you use the following connection string:
jdbc:sqLite::memory

here is my code:

public class Main {

    public static void main(String[] args) {
        try{
            Connection conn = DriverManager.getConnection("jdbc:sqlite:C:\\Users\\Desktop\\School Project\\Software-Engineering---Java-Project\\data.db");
            Statement statement = conn.createStatement();

            //CREATE TABLES
            statement.execute("CREATE TABLE IF NOT EXISTS CUSTOMERS (name TEXT,phone INTEGER,email TEXT)");

            //INSERT TO TABLES
            statement.execute("INSERT INTO CUSTOMERS (name,phone,email)" +
                    "VALUES ('NETANEL', 05555555,'SADF@GMAIL')");

notice how my JDBC is the path to my local computer, how can I change this?

EDIT:

I'm able to set the path with only referring the DB name:

final static String DB_URI = "jdbc:sqlite" + ":data.db";

    public static void main(String[] args) {
        try{
            Connection conn = DriverManager.getConnection(DB_URI);
            Statement statement = conn.createStatement();

the question is, will it be cross platform if i will deploy my application with this DB?

This might help.

Andrew S
– Andrew S

2019-05-21 15:30:46 +00:00
Commented May 21, 2019 at 15:30 — Andrew S
– Andrew S, Commented May 21, 2019 at 15:30

Benoit · Accepted Answer · 2019-05-21 15:47:51Z

1

You can use the user home directory. You are sure it's always defined whatever platform you deploy your program on, and your program will have read/write access to it.

Something like this:

String dbUri = "jdbc:sqlite:" + System.getProperty("user.home") + "/data.db";
Connection conn = DriverManager.getConnection(dbUri);

edited May 21, 2019 at 15:47

answered May 21, 2019 at 15:30

Benoit

5,4242 gold badges29 silver badges48 bronze badges

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

Collectives™ on Stack Overflow

Set relative path using jdbc, on a sqlite DB on user computer

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related