write to sqlite db packaged inside a jar

Question

I'm trying to use a DB for reading and writing that is contained in a JAR. I can read in it, but can't write throwed exeception :

java.sql.SQLException: path to '/database/scddata.db': 'LocationOfJar/database' does not exist

Is there any way I can bundle the database file inside a JAR?

Thanks in advance.

jeorfevre · Accepted Answer · 2016-05-16 11:36:02Z

4

Jar files does not allows to write.

So :

define a working path (in properties for example). Let's call it : workingPath/file.db.
on init of your program, before opening your db.
- check if db exists in working path
- if does not exists : copy your jar file.db file to workingPath/file.db .
Then you program will use the db from workingPath/file.db for execution.

answered May 15, 2016 at 21:59

jeorfevre

2,3261 gold badge19 silver badges27 bronze badges

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

1 Answer 1