Ce document en français.

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

HyperSQLOOo 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 overcome bug 139538 for users of LibreOffice on Linux.
• To use HyperSQL database in embedded mode, making the database portable (a single odb file).
• To take advantage of the improvements offered by the jdbcDriverOOo extension:
  • The management of users and roles (groups).
  • The management of nanoseconds and time zones.
  • The management of java.sql.Array, java.sql.Blob, java.sql.Clob...
• To replace the integrated HsqlDB 1.8 driver provided by LibreOffice / OpenOffice, a version that will soon be more than 20 years old, with a recent HsqlDB version of your choice.
• To support the ACID properties of the underlying HsqlDB database.

Being free software I encourage you:

• To duplicate its source code.
• To make changes, corrections, improvements.
• To open issue if needed.

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

The HyperSQLOOo extension uses the jdbcDriverOOo extension to work.
It must therefore meet the requirement of the jdbcDriverOOo extension.

This extension cannot be installed together with the SQLiteOOo extension.
It's one or the other, but at the moment they can't work together (see issue #156471).

On Linux and macOS the Python packages used by the extension, if already installed, may come from the system and therefore may not be up to date.
To ensure that your Python packages are up to date it is recommended to use the System Info option in the extension Options accessible by:
Tools -> Options -> Base drivers -> Embedded HsqlDB Driver -> View log -> System Info
If outdated packages appear, you can update them with the command:
pip install --upgrade <package-name>

For more information see: What has been done for version 1.1.0.

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

• Install jdbcDriverOOo.oxt extension

  This extension is necessary to use HsqlDB version 2.7.2 with all its features.

• Install HyperSQLOOo.oxt extension

Restart LibreOffice after installation.
Be careful, restarting LibreOffice may not be enough.

• On Windows to ensure that LibreOffice restarts correctly, use Windows Task Manager to verify that no LibreOffice services are visible after LibreOffice shuts down (and kill it if so).
• Under Linux or macOS you can also ensure that LibreOffice restarts correctly, by launching it from a terminal with the command soffice and using the key combination Ctrl + C if after stopping LibreOffice, the terminal is not active (no command prompt).

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

In step: Select database:

• select: Create a new database
• in: Emdedded database: choose: Embedded HsqlDB Driver
• click on button: Next

In step: Save and proceed:

• adjust the parameters according to your needs...
• click on button: Finish

Have fun...

If you want to migrate an integrated database (HsqlDB version 1.8.0) to a newer version (for example 2.7.2), follow these steps:

1. Make a copy (backup) of your database (odb file).
2. If not already installed, install this extension and the jdbcDriverOOo extension.
3. Update driver archive of the HsqlDB driver in: Tools -> Options -> Base drivers -> JDBC driver -> JDBC drivers settings -> Driver archive -> Update, with a version 1.8.0.10.
4. Restart LibreOffice / OpenOffice after changing the driver (hsqldb.jar).
5. Open the odb file in Base (double click on the odb file).
6. In Base go to: Tools -> SQL and type the SQL command: SHUTDOWN COMPACT or SHUTDOWN SCRIPT.

• Repeat this procedure at step 3 using version 2.4.0 or 2.4.1 or 2.5.0.
• Repeat this procedure at step 3 using version 2.7.2.

HyperSQLOOo is an com.sun.star.sdbc.Driver UNO service written in Python.
It is an overlay to the jdbcDriverOOo extension allowing to store the HyperSQL database in an odb file (which is, in fact, a compressed file).

Its operation is quite basic, namely:

• When requesting a connection, three things are done:

  1. If it does not already exist, a subdirectory with name: . + odb_file_name + .lck is created in the location of the odb file where all HyperSQL files are extracted from the database directory of the odb file (unzip).
  2. A DocumentHandler is added as an com.sun.star.util.XCloseListener and com.sun.star.document.XStorageChangeListener to the odb file.
  3. The jdbcDriverOOo extension is used to get the com.sun.star.sdbc.XConnection interface from the subdirectory path + odb_file_name.

• When closing or renaming (Save as) an odb file the DocumentHandler copy all the files present in the subdirectory into the (new) database directory of the odb file (zip) and then delete the subdirectory.

• OpenOffice 4.1.8 - Ubuntu 20.04 - LxQt 0.14.1

• OpenOffice 4.1.8 - Windows 7 SP1

• LibreOffice 7.0.4.2 - Ubuntu 20.04 - LxQt 0.14.1

• LibreOffice 6.4.4.2 - Windows 7 SP1

• LibreOffice 7.6.0.1 - Windows 10

• LibreOffice 7.6.0.1 - Ubuntu 22.04

I encourage you in case of problem 😕
to create an issue
I will try to solve it 😄

• The writing of this driver was facilitated by a discussion with Villeroy, on the OpenOffice forum, which I would like to thank, because knowledge is only worth if it is shared...

• Using the old version of HsqlDB 1.8.0 (can be easily updated).

• Added a dialog box allowing to update the driver (hsqldb.jar) in: Tools -> Options -> Base drivers -> Embedded HsqlDB driver

• Many other fix...

• Now the driver automatically splits an odb when opened... This allow conversion of odb files produced by the built-in LibreOffice / OpenOffice HsqlDB driver 😉

• Many other fix...

• I especially want to thank fredt at hsqldb.org for:

  • His welcome for this project and his permission to use the HsqlDB logo in the extension.

  • The quality of its HsqlDB database.

• Now works with OpenOffice on Windows.

• When unzipping, a file name clash now displays a precise error.

• Now correctly handles spaces in filenames and paths.

• Many other fix...

• Modification of Driver.py in order to make possible the use of the Uno service: com.sun.star.sdb.RowSet.

• Many other fix...

• Writing a DocumentHandler to allow:

  • The extraction of the database files contained in the odb file on connection.
  • Saving database files to odb file when closing it.

• Rewrote Driver.py to allow:

  • Its operation with the new JDBC driver provided by the extension jdbcDriverOOo version 0.0.4.
  • The support for the new DocumentHandler to make odb files portable as they were in LibreOffice / OpenOffice with version 1.8 of HsqlDB.

• Many other fix...

• Renamed the extension from HsqlDBembeddedOOo to HsqlDriverOOo.

• Integration of HyperSQL version 2.7.2.

• Renamed the extension from HsqlDriverOOo to HyperSQLOOo.

• Fixed bug 156511 occurring when using the com.sun.star.embed.XStorage interface. The workaround is to use the copyElementTo() method instead of moveElementTo(). Versions of LibreOffice 7.6.x and higher become usable.

• The absence or obsolescence of jdbcDriverOOo extension necessary for the proper functioning of HyperSQLOOo now displays an error message.

• Many other things...

• All Python packages necessary for the extension are now recorded in a requirements.txt file following PEP 508.
• Now if you are not on Windows then the Python packages necessary for the extension can be easily installed with the command:
  pip install requirements.txt
• Modification of the Requirement section.

• Support for new features in jdbcDriverOOo 1.1.2.

• Add new language for internationalization...

• Anything welcome...