HsqlDBDriverOOo

Ce document en français.

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

version 0.0.4

Introduction:

HsqlDBDriverOOo 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 to use the HsqlDB driver of your choice, with all its features, directly in Base.
It supports all protocols natively managed by HsqlDB, namely: hsql://, hsqls://, http://, https://, mem://, file:// and res://.

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:

If you still want to use the Embedded HsqlDB functionality provided by LibreOffice, then install the HsqlDBembeddedOOo extension.
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…:

HsqlDBDriverOOo screenshot 1

In step: Select database:

HsqlDBDriverOOo screenshot 2

In step: Connection settings:

HsqlDBDriverOOo screenshot 3

In step: Set up user authentication:

HsqlDBDriverOOo screenshot 4

If the connection was successful, you should see this dialog window:

HsqlDBDriverOOo screenshot 5

Have fun…

How to update the HsqlDB driver:

If you want to update the HsqlDB driver (hsqldb.jar) to a newer version, follow these steps:

Now your database is up to date.

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: