All geek questions in one place

Alternative quick switch for HSQLDB file mode (I need simultaneous access now)

I happily worked with HSQLDB, just using my DB address:

jdbc:hsqldb:file:target/testdb;

... and it’s as if I were in any other network database. Then, unexpectedly, one demand hit me right in the head; I need another JVM instance (on the same computer) to connect to the database to create some reports.

I read about Derby and Berkeley DB, but it seems to me that I need to configure some env vars, and my client asked me to program this system without any special configuration (no need to create env vars).

I thought that an independent thread runs HSQL in server mode in parallel, but I would prefer to use a different DB mechanism, which will be as simple as HSQLDB, but with support for simultaneous access to file mode. Hope you guys know about a simple alternative to solve my problem.

+3
source share
3 answers

SQLite may be a good option. See this SO question .

However, I think running HSQL in server mode is probably the easiest option. I used it so many years ago and found it strong enough for basic concurrent access, and you only need to change your URL in existing code.

+1
source

, , proc, HSQL JVM.

+1

JDBC - , , :

  • /

JDBC (.. - JDBC), , №3 №1 . № 2.

, , HSQL JDBC- ? HSQL .

0

Source: https://habr.com/ru/post/1716061/

More articles:


All Articles