Hi Rama! Unfortunatelly I haven't any experience with Linux. But I reproduce situation on my system (Win XP), and have noticed that after kiliing Process A files
~testDb.db3 ~testDb.db3-journal are usable for Process B. Process B just reuse file ~testDb.db3-journal file for own needs, and everything is fine. Maybe you shall check, is Process A and all their libraries really unloaded from memory? Isn't it just a file locking, is it? For example, can you simply move/delete database file after trap Process A, or it will be locked by system. Good luck! Denis -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 21, 2006 6:43 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] SQLite error: Database is locked Hi Denis, Thanks to your reply. Iam using the Linux 2.6.9.34 EL and sqlite version 3.3.6. your solution is good , but in my case the scenario is like this process A opens the connection and begins the transaction A inserts to the database A calls other function that are related to internal operations. Depending on the return value of the function, It commits or rollback's the DB. Thanks, Rama Raju ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
