Steps

To use a remote HSQLDB server instead of an embedded HSQLDB instance:

1. Verify that the major version of the hsqldb*.jar on XWiki's classpath matches the major version of the remote HSQLDB server.
2. Configure and start the remote HSQLDB server by following the official HyperSQL documentation: HyperSQL User Guide - Running and Using HyperSQL.
3. In WEB-INF/hibernate.cfg.xml, replace the jdbc:hsqldb:file:... connection URL with a remote server URL. Replace HOSTNAME, PORT, and dbname with the host, port, and database name configured on the HSQLDB server. For example:

   <property name="connection.url">jdbc:hsqldb:hsql://HOSTNAME:PORT/dbname</property>

4. Start or restart XWiki.

FAQ

What is the default HSQLDB server port?

The default HSQLDB server port is 9001.

Where can I find instructions for starting the HSQLDB server?

See the HSQLDB documentation for server startup instructions.