so two different processes cannot access the database at a time John Stanton-3 wrote: > > You need to handle the SQLITE_BUSY condition in your program. > > varunkumar wrote: >> 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. >> >> > > > ----------------------------------------------------------------------------- > To unsubscribe, send email to [EMAIL PROTECTED] > ----------------------------------------------------------------------------- > > >
-- View this message in context: http://www.nabble.com/sqlite3_exec-function-error%3Adatabase-is-locked-tf4612181.html#a13176997 Sent from the SQLite mailing list archive at Nabble.com. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
