Re: [sqlite] Transaction journal corrupted by antivirus

2007-05-03 Thread John Elrick
Voxen wrote: The problem is my application is used by thousand of customers. I cannot ask them to tweak their antivirus. An observation. Thunderbird uses simple text files to store unencrypted messages. I am not aware of anti-virus programs having trouble with those files. Perhaps a

Re: [sqlite] Transaction journal corrupted by antivirus

2007-05-03 Thread P Kishor
You are in a sticky situation. Read below -- On 5/3/07, Voxen <[EMAIL PROTECTED]> wrote: Hi, My application is storing email messages in a SQLite database (raw email messages as they are downloaded from the mail server). This is done under a transaction. Sometimes I get the SQLITE_MISUSE

Re: [sqlite] Transaction journal corrupted by antivirus

2007-05-03 Thread drh
Voxen <[EMAIL PROTECTED]> wrote: > The problem is my application is used by thousand of customers. > I cannot ask them to tweak their antivirus. > > > > > How can I work around this? > > Do I need to ZIP or encode the email message before storing it in the > > database? > > If the antivirus is

Re: [sqlite] Transaction journal corrupted by antivirus

2007-05-03 Thread Voxen
The problem is my application is used by thousand of customers. I cannot ask them to tweak their antivirus. Most anti-virus software allows you to specify an exception folder and/or file. Tell the anti-virus to ignore sqlite db and the journal. Sam

RE: [sqlite] Transaction journal corrupted by antivirus

2007-05-03 Thread Samuel R. Neff
Most anti-virus software allows you to specify an exception folder and/or file. Tell the anti-virus to ignore sqlite db and the journal. Sam --- We're Hiring! Seeking a passionate developer to join our team building products. Position is in the