When executing the Poco::Data::SQLite::Utility::fileToMemory method for a SQLite database with an existing hot journal, the method returns successfully, but the resulting in-memory database is corrupted.

I am not sure what the correct solution is, but in https://github.com/pocoproject/poco/blob/27e7e53/Data/SQLite/src/Utility.cpp#L251 the database file is read as read only and this prevents the correct handling of the hot journal.