Preparing the HSQL 1.8.x database file for automatic upgrade

Upgrading Crowd via Automatic Database Upgrade

On this page

Still need help?

The Atlassian Community is here for you.

Ask the community

If you are using Crowd with embedded HSQL database and want to upgrade your instance to version 5.2 or later with keeping the audit log, you can follow the automatic database upgrade procedure, but you should complete some preparation steps beforehand.

Because of a limitation in HSSQL, you can't upgrade the HSQL 1.8.x database file directly to version 2.7.x. You need to manually prepare the file.

Follow these steps before doing an automatic Crowd upgrade:

  1. Download HSQL 2.3.0 driver: hsqldb-2.3.0.jar.
  2. Open HSQL Database Manager: 

    java -cp hsqldb-2.3.0.jar org.hsqldb.util.DatabaseManagerSwing
  3. Specify the URL path to your old database, and connect using the following properties:
  4. Once opened, enter the following SQL query: SHUTDOWN SCRIPT;

  5. Select Execute SQL.
  6. Quit the HSQL Database Manager by selecting File > Exit.
  7. Verify the HSQL database was upgraded. The database .properties file should show 2.3.0 version:


You can now proceed with the automatic upgrade.

Last modified on Apr 15, 2024

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.