Simon Posnjak <[EMAIL PROTECTED]> wrote:
Is there a way to change the location of the journal file? We would like to have journal in some other directory than the database.
You can't. If your application crashes in the middle of a transaction, whoever next opens the database must be able to detect the presence of the journal file and use it to roll back. Otherwise, it would see a corrupted database.
Hence, everyone must agree where the journal file is located relative to the database file. SQLite ensures this by insisting that the journal be in the same directory.
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
