0

Host multiple databases in a HSQLDB server

On this post, we’ll host multiple databases in a single HsqlDB server running locally on a Windows machine. The following are additional details about the Software application used.

1. HSQLDB 2.3.3
2. Windows 7 64-bit
3. Java 8 (JRE is enough)
hsqldb_jre8

There are 5 Server Modes – Server, Web Server, Servlet, In-process, and Memory-only. We’ll only use Server and Web Server modes on this post. For more information on these modes, please visit http://hsqldb.org/doc/guide/ch01.html#N10168

The use the server mode, we use runServer.bat. For Web Server mode, we use runWebServer.bat.
hsqldb_bin_directory

Server Mode

Using runServer.bat.

hsqldb_runserver_multidb

Web Server Mode

Using runWebServer.bat.

hsqldb_runwebserver_multidb

List of Databases

We have two databases here. To host all of them, include them in the paramter list of either .bat file.

Database Files

These are the files generated for the databases.

hsqldb_data_directory