How do I setup support for 'split' HSQL databases in Base?

How do I setup support for 'split' HSQL databases in Base?

See: Wizard - Portable 'split' HSQL database template or follow the manual steps below. But understand that these two methods are mutually exclusive.

A macro-enhanced Base template (.odb) as offered in the link above is highly recommended for single-user, split-database access. These templates do not require manual Class Path setup as outlined below. The templates use a macro-derived 'session' Class Path as opposed to a manually-setup 'global' Class Path. So unless you're running a split HSQL database in server-mode (multi-user support), there's no good reason to setup the global Class Path manually in Base. In fact, a global Class Path has the potential to corrupt your legacy 'embedded database' (.odb) files, through inadvertent upgrade of the internal database to HSQLDB 2.3.x. Once upgraded, these 'embedded database' files become unusable. So before proceeding with the following Class Path setup steps, make good backups of all your legacy 'embedded database' files (.odb). You've been warned.

To manually setup a global "Class Path" in *Office, such as for server-mode access to a split HSQL database, follow the steps below. Java database engines are typically packaged as a single zip-archive file (.jar extension). This JAR file will normally contain all the necessary components, including a JDBC driver for external connection purposes. Therefore, Base simply needs to know the path to the engine's JAR file. This one-time setup becomes necessary on each computer used to access a 'split HSQL database' without the use of a macro-enhanced Base front-end (.odb) file, such as when running the database in server-mode.

• Open the Tools → Options dialog

• Select the Java dialog

• Press the  Class Path  button

• Press the  Add Archive…  button

• Navigate among your installed programs to locate hsqldb.jar
  • To use the built-in version of HSQLDB 1.8.0.10, look for hsqldb.jar in the *Office installation path:
    • For AOO or OOo navigate to: OpenOffice X\program\classes\hsqldb.jar
    • For LibreOffice navigate to: LibreOffice X.x\program\classes\hsqldb.jar
  • To use an installation of HSQLDB 2.2.8, look in the associated folder ...\lib\hsqldb.jar.
    • Note: Base is incompatible with HSQLDB 2.2.9, so utilize HSQLDB 2.2.8 or the latest HSQLDB 2.3x.

• Click:  OK  twice and re-start OpenOffice while also closing the Quickstarter (taskbar-app) manually as applicable...or simply restart your computer to make sure.