Steps

To install HSQLDB as the XWiki database, you need to:

1. Check if the hsqldb*.jar file is already present in WEB_INF/lib of your XWiki WAR. If the file hsqldb*.jar is missing, download it from the HSQLDB website or from the Maven Central repository.
2. Copy the hsqldb*.jar file to the WEB-INF/lib directory of the expanded XWiki WAR.
3. Configure XWiki to use HSQLDB and tell it where the database files will be created:
   • Edit the WEB-INF/hibernate.cfg.xml file and uncomment the HSQLDB configuration block.
4. Start or restart the application server. The HSQLDB database files are created automatically in the location specified by the connection.url property.
5. Verify that the HSQLDB database files (.data, .script, .properties) are created in the directory you configured.

FAQ

Can I use another HSQLDB setup?

Yes. You can configure a remote HSQLDB database or a container-managed datasource separately.

Can this database be used in production?

Not really. If you intend to use HSQLDB in production you should probably tune it for a production usage. We would suggest using a more production-ready database such as MySQL or PostgreSQL if you can.

More

To find more about the current topic, you can search or use the table below and filter the columns to narrow your choices.