For a QNX system Richard suggested to set locking mode EXCLUSIVE before trying to set the WAL journal mode.
When PRAGMA main.journal_mode=WAL is executed, the sqlite code checks whether EXCLUSIVE lock is enabled, or if shared memory is supported. The shared-memory implementation from sqlite is based on POSIX API. The QNX OS is not 100% POSIX compliant even if the company behind says so. If it is not set locking-mode EXCLUSIVE, WAL will not be enabled on a QNX system, since there is not shared memory support. For the SQLITE_OPEN_WAL you are right, it makes no difference. I am starting to believe that WAL is not a viable choice on a QNX system. Regards, Sandu _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users