CODEWITHSUNDEEP
sqliteconnectioncheckpointwal
J.Div
J.Div

Reputation: 1

Sqlite WALmode do not support memory mode?

I create my sqlite DB connection by using memory mode:

connection = DriverManager.getConnection("jdbc:sqlite:file:" + dbName + "?mode=memory&cache=shared")

And then use WAL-mode by excute: "pragma journal_mode=WAL"

I found that the memory size growing all the time when insert/delete operation. And it can not release even i call the wal_checkpoint(TRUNCATE).

Upvotes: 0

Views: 1109

Answers (1)

Shawn
Shawn

Reputation: 52579

A in-memory database only supports memory mode or no journal. Using a journal file for a database that only exists in RAM and goes away when the program that uses it exits doesn't make any sense.

Upvotes: 3

Related Questions