Sqlite : Database locked problem
Publicado: Vie Feb 06, 2015 10:44 am
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.
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.