Hi,

 

I use sqlite3.3.4 on windows.

I have two instances of a program that attempt to simultaneously write to
the same database.db file.  When I run them together, I observe that a
database.db-journal file is created. The programs crash with an exception
thrown. The exception found in the program is :

SQLite3::SQLException: SQL logic error or missing database

 

I would have expected this to be SQLite3::BusyException. What is the
difference between the two? I need to handle the case when one program is
unable to write to the database when another is writing. How do I do it?

 

I have also observed that the -journal file cannot be deleted for some time
after the programs crash. Why is that?

 

Thanks,

Yash


DISCLAIMER
==========
This e-mail may contain privileged and confidential information which is the 
property of Persistent Systems Pvt. Ltd. It is intended only for the use of the 
individual or entity to which it is addressed. If you are not the intended 
recipient, you are not authorized to read, retain, copy, print, distribute or 
use this message. If you have received this communication in error, please 
notify the sender and delete all copies of this message. Persistent Systems 
Pvt. Ltd. does not accept any liability for virus infected mails.

Reply via email to