Opening database connection with the SQLITE_OPEN_NOMUTEX flag in Java

Question

After reading the Sqlite documentation I wanted to make sure that by run-time the connection to the database is in the correct mode.

Class.forName("org.sqlite.JDBC");
Connection connection = DriverManager.getConnection("jdbc:sqlite::memory:");

I'm using the Sqlite JDBC driver. How can I add the SQLITE_OPEN_NOMUTEX flag?

Please check this link it asked before at C# stackoverflow.com/questions/7801361/multithreading-in-sqlite — erhun
– erhun, Commented Jul 1, 2014 at 15:08
The conclusion is that the Sqlite database runs in serialized mode by default and I can't change it. :-( — Clueless
– Clueless, Commented Jul 1, 2014 at 16:30

Stephan · Accepted Answer · 2016-06-06 15:38:08Z

4

After I had some doubts why in C it looks so easy and in Java it should not possible, here probably the solution:

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

SQLiteConfig config = new SQLiteConfig();
config.setOpenMode(SQLiteOpenMode.READWRITE);
config.setOpenMode(SQLiteOpenMode.CREATE);
config.setOpenMode(SQLiteOpenMode.NOMUTEX);

Connection connection = DriverManager.getConnection( //
              "jdbc:sqlite::memory:", //
              config.toProperties() //
);

edited Jun 6, 2016 at 15:38

Stephan

43.2k69 gold badges245 silver badges342 bronze badges

answered Jul 2, 2014 at 16:14

Clueless

1931 silver badge16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Opening database connection with the SQLITE_OPEN_NOMUTEX flag in Java

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related