Start & Stop HSQL Servers for w32

Forum rules
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
Post Reply
User avatar
Greengiant224
Posts: 282
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Start & Stop HSQL Servers for w32

Post by Greengiant224 »

I have made a very simple gui interface to make starting and stopping HSQL JDBC servers. it only runs on windows (sorry linux guys)
There is a readme file included. You only need to configure the relevant paths in the .ini file and away you go.

It is a small portable app that runs in the system tray. I have been using this personally for about twelve months and
have not had any problem with it.

If you don't like messy batch files or shortcuts cluttering up your desktop try this:

not available (426kb)

I know this is not a tutorial as such but it was written with reference to the HSQL DB decription of file/server modes from DACM
http://user.services.openoffice.org/en/ ... 67#p162653

I hope it makes your job of running servers much easier.

Enjoy!!!
Last edited by Greengiant224 on Wed Aug 09, 2023 10:08 pm, edited 2 times in total.

Win 7, Portable AOO 4.1.14, LibreOffice 6.2, 7.4.5 & 7.6.1 (Java 1.7.81 & 1.8.0_281) utilising HSQL 1.8.10 & 2.4.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
User avatar
Villeroy
Volunteer
Posts: 31264
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Start & Stop HSQL Servers for w32

Post by Villeroy »

Whatever you tried to code here, it killed my database configuration.

Code: Select all

[Java]
javapath=C:\Program Files\Java\jre6\bin\java.exe

[JavaJar]
jarpath22=C:\Program Files\hsqldb\lib\hsqldb.jar
sqltool=C:\Program Files\hsqldb\lib\sqltool.jar

[OpenOffice]
LOoPath=C:\Program Files\LibreOffice 3\program\soffice.exe

[Database]
DbPath22=Z:\hsqldbdata\db0\chargen
HSQL version is the 2.2.5 on Win7.
The last entry refers to the chargen.* files

No I always get

Code: Select all

SQL Status: S1000
Error code: -458

General error: database alias does not exist
even when I start my usual script.
 Edit: A complete restart of the machine fixed it. How much I hate Windows administration. 
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
User avatar
Greengiant224
Posts: 282
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Re: Start & Stop HSQL Servers for w32

Post by Greengiant224 »

Villeroy:
Whatever you tried to code here, it killed my database configuration.
There is nothing contained in this simple code to cause any of the problems you experienced.
It has been tested over 1000 times ( yes, true, by me personally) and various anti virus scanners
all report a clean file.

Edit: A complete restart of the machine fixed it. How much I hate Windows administration.
Amazing, how a restart can can fix your database configuration?

Glad to see you have no other problems.

Win 7, Portable AOO 4.1.14, LibreOffice 6.2, 7.4.5 & 7.6.1 (Java 1.7.81 & 1.8.0_281) utilising HSQL 1.8.10 & 2.4.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
Post Reply