-1

What is the maximum no. of connections that SQLite database can provide?

I'm using SQLite database with Java for the development of small desktop application. After few successful connection I got error message like this:

SQLite database file is locked.

What are the probable reason?

I am expecting helpful answer from you. Thank You in advance!

  • I am expecting sufficient research from you. [What is the maximum connections for sqlite3 database](http://stackoverflow.com/questions/9017762/what-is-the-maximum-connections-for-sqlite3-database) – Jonny Henly Feb 04 '16 at 02:56
  • [1.0 File Locking And Concurrency In SQLite Version 3](https://www.sqlite.org/lockingv3.html) – Jonny Henly Feb 04 '16 at 02:57
  • Thank You @JonnyHenly for your response! I am unable to detect SQLite version, I just tried to create db.sqlite, so I posted this question here. –  Feb 04 '16 at 03:00

1 Answers1

0

You can only have one connection that mutates your data. Close your idling connections or move to MySQL if you need concurrency

alsdkjasdlkja
  • 1,260
  • 2
  • 14
  • 30
  • I think it's better to use SQLite database rather than using MySQL, for small application. –  Feb 04 '16 at 03:47