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!
[Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1
[Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1
Last edited by Dalke55 on Sun Sep 26, 2021 7:40 pm, edited 1 time in total.
Apache OpenOffice 4.1.6 Windows 10
Re: Upgrade Split_HSQLDB)2.3.2 to 2.5.1
Shut down any connection to your database.
Replace the old hsqldb.jar with the new one.
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: Upgrade Split_HSQLDB 2.3.2 to 2.5.1
Actually, it may not be quite that simple
With your database open with version 2.3.2
At Tools>SQL execute
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
for more details see
HSQL Version 2.5.1 Released
With your database open with version 2.3.2
At Tools>SQL execute
Code: Select all
SHUTDOWN SCRIPT
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"
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Re: Upgrade Split_HSQLDB 2.3.2 to 2.5.1
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!
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
-
- Volunteer
- Posts: 1549
- Joined: Wed Jun 24, 2015 12:56 am
- Location: Colorado, USA
Re: [Solved] Upgrade Split_HSQLDB 2.3.2 to 2.5.1
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.
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
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11