[Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Creating tables and queries
Post Reply
Dalke55
Posts: 23
Joined: Sat Jan 19, 2019 11:08 pm

[Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Post by Dalke55 »

I'm looking into if my current Split database ver: 2.3.2 should be upgraded to 2.5.1 version. Can someone point me to documentation that can guide a non expert on if or how to do this?

Thank You!
Last edited by Dalke55 on Sun Sep 26, 2021 7:40 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
User avatar
Villeroy
Volunteer
Posts: 31269
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Upgrade Split_HSQLDB)2.3.2 to 2.5.1

Post by Villeroy »

Shut down any connection to your database.
Replace the old hsqldb.jar with the new one.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Post by UnklDonald418 »

Actually, it may not be quite that simple
With your database open with version 2.3.2
At Tools>SQL execute

Code: Select all

SHUTDOWN SCRIPT
Shutdown you database
Now replace hsqldb.jar in the driver sub directory of your split database with the one found in the zip archive for version 2.5.1

You can verify that the upgrade worked by running this query

Code: Select all

SELECT * FROM "INFORMATION_SCHEMA"."SQL_IMPLEMENTATION_INFO"
for more details see
HSQL Version 2.5.1 Released
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Dalke55
Posts: 23
Joined: Sat Jan 19, 2019 11:08 pm

Re: Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Post by Dalke55 »

Thank You for the information.
I have a question about conflicting results. After running the shutdown script,shutting down, and replacing the hsqldb.jar file from the 2.5 LIB directory and restarting: under Tools / Options/ Base drivers / Embedded HsqlDB Driver: it reports Driver version 2.5.0. How ever when I ran the verification SQL script line ID 18 DBMS VERSION has character value of 2.3.2.

I was running this process on a second test version copied from my production version. I ran the same process on my production version with the verification confirming 2.5.0. So I do not know what I have messed up with my test version.

Thank You!
Apache OpenOffice 4.1.6 Windows 10
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: [Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1

Post by UnklDonald418 »

You may not have copied the new jar file on the test version.
A way to see which version is in the hsqldb.jar file is to double click (or right click then select Open)
Use the defaults and select OK in the Connect dialog.
In the left pane of the HSQL Database Manager expand the Properties tab.
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Post Reply