You would have not closed the database after usage,just check wheather you have closed the database.
-----Original Message----- From: varunkumar [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 09, 2007 9:25 PM To: sqlite-users@sqlite.org Subject: [sqlite] sqlite3_exec function error:database is locked i am using sqlite3 database in our project in my project one daemon process running , in this daemon process i am opening the data base and inserts the data in to sqlite3 database using sqlite3_exec() API . for every one minute i am opening the database and inserts the values in to database using sqlite3_exec() API and closing the database. queryies are doing to database from another processes using sqlite3_exec() API . when query to database from another processes i am getting error "sqlite3_exec function error:database is locked " in above daemon process when this daemon process insert values in to database for that minute. from nextminute onwards this daemon process insert values in to database except when i query the database from another process. -- View this message in context: http://www.nabble.com/sqlite3_exec-function-error%3Adatabase-is-locked-tf459 5055.html#a13118299 Sent from the SQLite mailing list archive at Nabble.com. ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. Contact your Administrator for further information. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
