How to get rid of the "Database is locked" problem?

Question

Java

I'm using a wrapper class to work with a database in a normal JavaSE console application. The application is multi-threaded, which, as I think, is the problem when various threads climb into the database to write / read data. What is the optimal solution to this problem?

Answer 1

What's the base? Are we using the Connection pool?!

Answer 2

Data Source=c:\mydb.db;Version=3;Pooling=True;Max Pool Size=100;
More examples here: https://www.connectionstrings.com/sqlite/