SQLite in memory database shared cache and multiple connections

[Daine Mamacos]

Hi,

I've got the following code:

         Class.forName("org.sqlite.JDBC");

         

         SQLiteConfig config = new SQLiteConfig();

         config.setSharedCache(true);

         

         conn = DriverManager.getConnection("jdbc:sqlite::memory:", config.toProperties());

I can't seem to get multiple connections to the same in memory database. It just seems to make a new one every time. I've done this with the C API, is this possible with Xerial?

Thanks

Daine.

[grace]

Reported issue to https://bitbucket.org/xerial/sqlite-jdbc/issue/34/ 

 

Thanks

Daine.