B4J Question SQLite (db-shm / db-wal) files. [SOLVED]

[Eme Fibonacci]

I've noticed that every time my project runs these files are created.
If I make any changes in the database (for example a new entry) and delete .db-shm and .db-wal files the changes are lost.

1) How to eliminate dependency on these files?

2) What theses files means?

Thank you.

 

[Eme Fibonacci]

When SQL1.Close is used the changes are committed and the files are deleted. Thank you.

 

[Erel]

The files will not always be deleted. They are part of the database when the journal mode is set to wal.

 

[Eme Fibonacci]

When I was using journal mode the foreign key records were not was deleted on cascade. Now I use only PRAGMA foreign_keys = ON.
The files .db-shm and .db-wal are created quando app run. They are automatic deleted when I use SQL1.Close.