The problem that I encountered with the sqlite db file created on my java server (jersey) was only related to the path. Some of the docs say that the jdbc connection url should look like "jdbc: sqlite: //path-to-file/sample.db". I thought the double slash was part of the htt protocol style path and displayed correctly during deployment, but it is actually an absolute or relative path. So, when I placed the file in the root of the WebContent folder (tomcat project), this uri worked like "jdbc: sqlite: sample.db".
The only thing that threw me away was that when I was going through the debugger, I got a message saying: "Opening db: ... permission denied". I thought this was a matter of file system permissions or, possibly, sql user rights. Upon learning that SQLite does not have a concept of roles / permissions such as MySQL, etc., I eventually changed the file permissions before I came to what I think was the right solution, but I think that it was just a bad message (i.e. allowed, instead of a file not found).
Hope this helps someone.
Ted_Zactly Jun 22 '17 at 21:17 2017-06-22 21:17
source share