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