Search code examples
javasqlitedatabase-locking

"database locked" error on one machine but everything fine on the other


Using SQLite on Java with JDBC connector, I constantly get this "database locked" error on my code. The strange thing is that the jar file into which I have compressed my whole program works fine on my Macbook but gets this error when running on a Windows machine. Additionally:

The program has only one thread so it probably can't be a concurrency issue.

The code does some operations on the db before giving the error, so I don't believe this is a file permission issue either.

I didn't go into the details of my code because I assumed it's not necessary. Ready to do so by the way. Any ideas?


Solution

  • I finally solved it. I uninstalled my up-to-date version of JRE (Java Update 7, which had come along when installing jdk7) and moved back to jre 6 Update 33.