HSQLDB 2.7.4 malfunction with embedded bases

[Primus]

Hi.

I downloaded the latest version of HSQLDB (2.7.4) to take advantage of the benefits it offers over the embedded version of LibreOffice.

I’ve set the parameters as shown below (found on a tutorial):

Then, to connect to:

JDBC :hsqldb:file:/home/primus/Databases/BaseName;default_schema=true;shutdown=true;hsqldb.default_table_type=cached;get_column_name=false

Classe de pilote : org.hsqldb.jdbcDriver

Everything works fine. But I can no longer open my “standard” databases, with HSQLDB embedded version. This indicates that there is no access to the tables.

Please help me solve this problem.

[Villeroy]

HSQL 2.4.1 was the last version able to convert HSQL 1.8.
If you switch to that version, your embedded databases will be converted automatically. HOWEVER, when you open a converted database a second time, it will not work anymore because Base will use the old driver and there is no way back. In order to use the converted and embedded 2.4.1, you would have to extract it. Since you have used 2.7.4, your embedded HSQLDB remained untouched.
Conclusion: Do not add HSQL to the class path. Instead, you can register the driver path in the Base document. There is no GUI for that.

I have one dedicated directory “hsql” for stand-alone databases with one subdirectory “driver” with a hsqldb.jar of version 2.4.1 and one subdirectory “database” for all the database files.
In order to extract an embedded database and upgrade to 2.4.1, I put the Base document into the “hsql” directory and run this following macro: Apache OpenOffice Community Forum - [Python] Macro to extract and reconnect embedded HSQLDB - (View topic)

[Primus]

Thanks for the information. I haven’t done anything yet. I’ve just noticed the problem and my old bases are as they were. I’ve deleted the class and directory paths until I see what I can do.

[Villeroy]

@Primus

until I see what I can do.

https://sourceforge.net/projects/hsqldb/files/hsqldb/hsqldb_2_4/hsqldb-2.4.1.zip/download

@Villeroy

Apache OpenOffice Community Forum - [Python] Macro to extract and reconnect embedded HSQLDB - (View topic)

mkdir ~/hsql
mv ~/Documents/EmbeddedDB.odb ~/hsql
cd hsql
mkdir driver
unzip -j ~/Downloads/hsqldb-2.4.1.zip hsqldb-2.4.1/hsqldb/lib/hsqldb.jar -d driver