Página 1 de 1

Sqlite : Database locked problem

Publicado: Vie Feb 06, 2015 10:44 am
por Milan Mehta
I am using Sqlite datasource.
It seems that while insert / update / deleting a record in any table in the databases, entire database file gets locked. So when concurrent users tries to Save record, we get the error : Database locked.
How can we avoid this error ? How do we detect the problem and keep the user in wait mode till other user finishes its operation ?
TIA
Milan.

Sqlite : Database locked problem

Publicado: Mié Feb 11, 2015 11:37 am
por Milan Mehta
Ultimately following statement solved my problem.
PRAGMA busy_timeout = milliseconds;
oDS:Execute ("PRAGMA busy_timeout = 10000;")
Thanks
Milan.