HsqlDBembeddedOOo

Ce document en français.

The use of this software subjects you to our Terms Of Use

version 0.0.4

Introduction:

HsqlDBembeddedOOo is part of a Suite of LibreOffice and/or OpenOffice extensions allowing to offer you innovative services in these office suites.

This extension allows you:

HsqlDBembeddedOOo only works in split mode, with the ability to extract (decompress) the data contained in an odb file when connecting if a folder with the same name and location as the odb file does not exist. This allow conversion of odb files produced by the built-in LibreOffice / OpenOffice driver (Embedded HsqlDB).
If these features do not concern you, then I recommend you to use the driver HsqlDBDriverOOo allowing to exploit all the functionalities offered by HsqlDB.

Being free software I encourage you:

In short, to participate in the development of this extension.
Because it is together that we can make Free Software smarter.

Requirement:

HsqlDB is a database written in Java.
The use of HsqlDB requires the installation and configuration within LibreOffice / OpenOffice of a JRE version 1.8 minimum (ie: Java version 8)
I recommend AdoptOpenJDK as your Java installation source.

If you are using LibreOffice on Linux, then you are subject to bug 139538.
To work around the problem, please uninstall the packages:

OpenOffice and LibreOffice on Windows are not subject to this malfunction.

Installation:

It seems important that the file was not renamed when it was downloaded. If necessary, rename it before installing it.

Restart LibreOffice / OpenOffice after installation.

Use:

How to create a new database:

In LibreOffice / OpenOffice go to File -> New -> Database…:

HsqlDBembeddedOOo screenshot 1

In step: Select database:

HsqlDBembeddedOOo screenshot 2

In step: Save and proceed:

HsqlDBembeddedOOo screenshot 3

Have fun…

How to migrate an embedded database:

If you want to migrate an integrated database (HsqlDB version 1.8.0) to the latest version (for example 2.5.1), follow these steps:

Now you can use the full feature version of the driver HsqlDBDriverOOo, your database is in a folder with the same name and location as your odb file.

Has been tested with:

I encourage you in case of problem :-(
to create an issue
I will try to solve it ;-)

Historical:

What has been done for version 0.0.1:

What has been done for version 0.0.2:

What has been done for version 0.0.3:

What has been done for version 0.0.4:

What remains to be done for version 0.0.4: