Hi everyone, I'm relatively new to SQLite and currently I'm experimenting a little bit with the SQLite database on an embedded system. I want to change the journal mode of a database to WAL. So I did the following:
rc = sqlite3_open(dbPath, &db); rc = sqlite3_exec(db, "PRAGMA journal_mode=WAL;", testCallbackPrint, 0, &zErrMsg); [?] sqlite3_close(db); Unfortunately, after these lines, the journal mode is not changed. The sqlite3_exec function returns SQLITE_OK (0), testCallbackPrint is never called and the error message is empty. Also reading the value of journal mode with ?PRAGMA journal_mode;? leads to the same result (rc=0, callback noch called and error message is empty). It seems as if the pragma is ignored completely, so I tested other pragmas, with the same result. So what am I doing wrong? To compile, I use the following options -DSQLITE_ENABLE_MEMSYS5 -DSQLITE_ENABLE_8_3_NAMES=2 -DSQLITE_THREADSAFE=0 -DSQLITE_OS_OTHER=1 -DSQLITE_ENABLE_API_ARMOR -DSQLITE_DEFAULT_MMAP_SIZE=0 -DSQLITE_TEMP_STORE=0 -DSQLITE_DEFAULT_CACHE_SIZE=500 Thanks. ________________________________ Firma: Capgemini Deutschland GmbH Aufsichtsratsvorsitzender: Antonio Schnieder ? Gesch?ftsf?hrer: Dr. Michael Schulte (Sprecher) ? Jost F?rster ? Dr. Peter Lempp ? Dr. Volkmar Varnhagen Amtsgericht Berlin-Charlottenburg, HRB 98814 This message contains information that may be privileged or confidential and is the property of the Capgemini Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, you are not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message.
