Start & Stop HSQL Servers for w32

Forum rules
No question in this forum please
For any question related to a topic, create a new thread in the relevant section.

Start & Stop HSQL Servers for w32

Postby Greengiant224 » Sat Jan 21, 2012 11:29 pm

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:

StartJDBCServers.zip (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/forum/viewtopic.php?f=83&t=17567#p162653

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

Enjoy!!!

Linux 2.6.38, KDE 4.9.2, LibreOffice 3.5.* (Java 1.6.0_35) utilising HSQL 1.8.10 & 2.3.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
User avatar
Greengiant224
 
Posts: 276
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World

Re: Start & Stop HSQL Servers for w32

Postby Villeroy » Fri Feb 03, 2012 8:44 pm

Whatever you tried to code here, it killed my database configuration.
Code: Select all   Expand viewCollapse view
[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   Expand viewCollapse view
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, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25952
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Start & Stop HSQL Servers for w32

Postby Greengiant224 » Thu Apr 26, 2012 4:41 pm

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.

Linux 2.6.38, KDE 4.9.2, LibreOffice 3.5.* (Java 1.6.0_35) utilising HSQL 1.8.10 & 2.3.*, MySQL, PostgreSQL, SQLite
+ Blood, Sweat and Tears (Application, Determination and Perseverance)
User avatar
Greengiant224
 
Posts: 276
Joined: Wed Jun 09, 2010 3:50 pm
Location: All Over The World


Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest