SQLite Forum

how to use in-memory with shared cache in mybatis
See https://sqlite.org/inmemorydb.html

You need to specify the URI pathame "file::memory:?cache=shared" and hope it gets to the SQLite API without interference from mybatis or JDBC and provided that the release of the SQLite library used was compiled with URI support enabled.