On Fri, Dec 10, 2010 at 9:06 AM, Richard Hipp <d...@sqlite.org> wrote: > On Fri, Dec 10, 2010 at 4:02 AM, Nicklas Larsson > <nirre.lars...@gmail.com>wrote: > >> Hi, >> >> we have been running SQLite (3.6.21) successfully on Windows CE for a >> while. >> When upgrading to version 3.7.3 our intent was to enable WAL. However, we >> ran into problems related to the locking mechanism. >> >> In method winShmSystemLock calls are made to LockFileEx with parameters >> that >> will make 'winceLockFileEx' always return FALSE. >> >> Does anyone know if WAL is expected to work on Windows CE? I can't see how >> if that is the case. >> > > I don't think shared memory works on winCE. Shane can answer that > definitively when he gets online today. > > But with SQLite 3.7.4, there is a work-around. Set PRAGMA > locking_mode=EXCLUSIVE prior to engaging PRAGMA journal_mode=WAL and shared > memory won't be used. See http://www.sqlite.org/wal.html#noshm for details. > > >> >> Best Regards, >> >> Nicklas! >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >> > > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users >
The locking primitives used for WAL are unfortunately not supported on Windows CE. -Shane _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users