sqlite journal file location

Curently sqlite is writing 开发者_如何学JAVAjournal file in the same directory where is placed database file. It makes a problem with the directory permission (it has to be writable). Is there any method to force sqlite to write journal files in other directory?

---

No, but you can use PRAGMA journal_mode = PERSIST.

---

Setting the journal_mode to OFF or MEMORY should do the trick.

http://sqlite.org/pragma.html#pragma_journal_mode