is it possible more than one process can access the sqlite3 database at a
time?
I am using sqlite3 database , I have the situation like follows in my
project.
In my project one process(daemon) doing as follows
it is opening the database using sqlite3_open()
preparing sqlite3 insert statement using sqlite3_mprintf() for
inserting values
using sqlite3_exec() executing the sqlite3 insert statement .
finally calling sqlite3_free(), sqlite3_close() API s
The above steps are doing in my process(daemon) for every
one minute.
I am generating reports from different processes like
opening the database usig sqlite3_open()
preparing sqlite3 select statement using sqlite3_mprintf()
using sqlite3_exec() executing the sqlite3 statement
finally calling sqlite3_free(), sqlite3_close() APIS
problem
--------
when i am generating reports at particular time ,at the same time if
that daemon process access
the database by calling sqlite3_exec() the daemon process getting the
error like
sqlite3_exec function error:database is locked.
using sqlite3_step() API instead of sqlite3_exec() API verify the
database whether
database is busy or not using return value of SQLITE_BUSY. if SQLITE_BUSY
i have to wait untill database is not busy. but i donot want to wait at
that time
because if i wait at that time our project would not synchronize with
other
processes, it should insert values at that time if any processes also
using the database at
the same time.
--
View this message in context:
http://www.nabble.com/sqlite3_exec-function-error%3Adatabase-is-locked-tf4612181.html#a13171346
Sent from the SQLite mailing list archive at Nabble.com.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
