Steps

To configure XWiki to use HSQLDB as the database, which runs embedded in the same JVM as XWiki:

1. Ensure that the hsqldb*.jar driver is available to XWiki:
   • 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 and copy it to the WEB-INF/lib directory of the expanded XWiki WAR.
2. 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.
3. Start or restart the application server. The HSQLDB database files are created automatically in the location specified by the connection.url property.
4. Verify that the HSQLDB database files (e.g., .script, .properties) are created in the directory you configured.

FAQ

Can I use another HSQLDB setup?

Yes. You can configure a remote HSQLDB database .

Can this database be used in production?

Not really, it has some limitations. 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.