how to make executable java app with sqlite

Question

i am working a java app using an sqlite db, with eclipse.

i produce an executable jar with library handling: copy required libraries into a sub-folder next to generated JAR

the problem is that the app runs ok in my computer, but when i try to run it in another computer doesnt connect with the db.

(in code i put url for db E:\\ and i put also the .sqlite file in that location in my and the other computer)

String url = "E:\\"; this.dburl = "jdbc:sqlite:"+url+"\\converted.sqlite";

i want the .sqlite file to be out or jar file, so i can back it up. Any ideas?

noshusan · Accepted Answer · 2016-05-25 18:33:51Z

1

I always like to use unix style forward slashes in path and it also work in windows. you are putting an extra slash in your db url. Try to put these file into C drive because other PC might not have an E drive. Try this:

String url = "E:/";
this.dburl = "jdbc:sqlite:"+url+"converted.sqlite";

answered May 25, 2016 at 18:33

noshusan

3132 silver badges13 bronze badges

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

1 Comment

Jeff Miller Over a year ago

I agree. Always use forward slashes even on Windows.

Collectives™ on Stack Overflow

how to make executable java app with sqlite

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related