SQLite database is locked

Plugins Plugin Development
1

In my plugin, some player report me this error “org.sqlite.SQLiteException: [SQLITE_BUSY] The database file is locked (database is locked)”. But I don’t know how to correct this. This only appears with SQLite

My class to open connection :
https://pastebin.com/urfamNCm

My class with all query:
https://pastebin.com/37UWDq6u

2

First off, even though you’re only doing it with config values, it is a good practice to literally never use string concatenation in an SQL query.
Anyway, if I had to guess, I’d say it’s because you’re not actually disposing of your connection objects. Use a try-with-resources statement to ensure that the connections get properly closed.

3

I’d suggest not to use sqlite at all.

1 Like