--- Rod Dunne <[EMAIL PROTECTED]> wrote:
> On Jul 11, 12:28 am, Joe Wilson <[EMAIL PROTECTED]> wrote:
> > Even with the Apple patch, make sure that Windows does not access the
> > remote database concurrently to avoid database corruption.
>
> My normal use scenario is 99.9% single user, exclusive usage of the
> database as an application's local save file. That said, it does not
> defend against the possibility of that scenario from happening. Do
> you think setting the SQLite locking_mode EXCLUSIVE pragma, right
> after attaching to the database would be sufficient to prevent this
> corruption?
Nope.
If Windows or Linux is using POSIX advisory file locking and OSX is
using dotlocking you are guaranteed a corrupt database file if modified
simultaneously. This is due to the fact that the POSIX lock and the Mac
dotlock can and will be granted at the same time.
It makes you wonder why Apple put such an incompatible patch out
there instead of fixing OSX. Apple's patch will only work with other
Apple machines.
____________________________________________________________________________________
Building a website is a piece of cake. Yahoo! Small Business gives you all the
tools to get online.
http://smallbusiness.yahoo.com/webhosting
--~--~---------~--~----~------------~-------~--~----~
Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en
To unsubscribe, send email to [EMAIL PROTECTED]
-~----------~----~----~----~------~----~------~--~---
