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!!!
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.
No question in this section please
For any question related to a topic, create a new thread in the relevant section.
- Greengiant224
- Posts: 283
- Joined: Wed Jun 09, 2010 3:50 pm
- Location: All Over The World
Start & Stop HSQL Servers for w32
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)
Re: Start & Stop HSQL Servers for w32
Whatever you tried to code here, it killed my database configuration.
HSQL version is the 2.2.5 on Win7.
The last entry refers to the chargen.* files
No I always get
even when I start my usual script.
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
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
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
- Greengiant224
- Posts: 283
- Joined: Wed Jun 09, 2010 3:50 pm
- Location: All Over The World
Re: Start & Stop HSQL Servers for w32
Villeroy:
It has been tested over 1000 times ( yes, true, by me personally) and various anti virus scanners
all report a clean file.
Glad to see you have no other problems.
There is nothing contained in this simple code to cause any of the problems you experienced.Whatever you tried to code here, it killed my database configuration.
It has been tested over 1000 times ( yes, true, by me personally) and various anti virus scanners
all report a clean file.
Amazing, how a restart can can fix your database configuration?Edit: A complete restart of the machine fixed it. How much I hate Windows administration.
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)