On Fri, Dec 10, 2010 at 4:02 AM, Nicklas Larsson <[email protected]>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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
