Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Creating a shared HSQLDB database

Tags:

In-process HSQLDB database are not expected to be opened by others, even for file-based storage.

The documentation hints that this is possible: Server Modes, Advanced Topics, but I've not yet found a URL for how to activate this behaviour.

Did anyone do this so they can share how to?

like image 845
Robert Munteanu Avatar asked Jun 08 '09 11:06

Robert Munteanu


1 Answers

The following works for me:

  1. Start a server from your code, which is shown in the org.hsqldb.test.TestBase code in the HSQLDB source code. Something like:

    Server server = new Server();
    server.setDatabaseName(0, "test");
    server.setDatabasePath(0, "file:/path/to/db");
    server.start();
    
  2. In the same JVM, open a Connection to the same database the way you would in a normal (non-Server) program, like:

    conn = DriverManager.getConnection("jdbc:hsqldb:file:/path/to/db");
    

Then use conn to execute whatever SQL you want.

In my own experimentation this appears to work, and it works for in-memory and file database.

Other JVMs, of course, will need to connect to the server using TCP. Trying to open the database file directly in another JVM will result in the usual error about the database being locked.

like image 100
cary m Avatar answered Oct 11 '22 15:10

cary m