HSQLDB 1.8 documentation not easily reachable

Discuss the database features
Post Reply
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

HSQLDB 1.8 documentation not easily reachable

Post by r4zoli »

OOo until version 3.2 uses HSQLDB 1.8.0.10 database engine, the HSQLDB documentation can be used for creating SQL commands.
In December 2009. the HSQLDB team issued HSQLDB 2.0.0RC7 version (finalized 1.9 development), and consequently changed the documentation of their website.
Now the link on main page of hsqldb.org. http://hsqldb.org/web/hsqlDocsFrame.html , point to HSQLDB 2.0.0 documentation.

The old link to hsqldb 1.8 documentation, today (17. December 2009.) is working from this direct link: http://hsqldb.org/doc/guide/
I don't know how long it will last,I suggest to download hsqldb 1.8 package it contains documentation, too.

Into the OOo 3.3 the HSQLDB 2.0 will not be integrated instead of 1.8.
Edit:
The OOo 3.3 contain HSQLDB 1.8.0.10 version, as earlier 3.x versions.
The HSQLDB 2.0.0 came out in June 2010, too late for integration to OOo 3.3.
I hope it will be in OOo 3.4, but who knows.
 Edit: HSQLDB 2.x integration postponed again, will not happen in OOo 3.4 timeframe. Now we wait for the HSQLDB 2.1 issue, it will too late for OOo 3.4 branch off.

OOo 3.4 will contain HSQLDB 1.8.0.10. 
Last edited by r4zoli on Thu Feb 23, 2012 10:39 pm, edited 4 times in total.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
rudolfo
Volunteer
Posts: 1488
Joined: Wed Mar 19, 2008 11:34 am
Location: Germany

Re: HSQLDB 1.8 documentation not easily reachable

Post by rudolfo »

The above link for the hsqldb 1.8 documentation http://hsqldb.org/doc/guide/ points now to the Version 2.2.
So the only way to get hold of the documentation relevant for the version that is still used in OpenOffice Base (3.3 and 3.4) is the approach through sourceforge and to download the package for 1.8: http://sourceforge.net/projects/hsqldb/ ... ldb_1_8_1/ as r4zoli mentioned above.
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.
User avatar
Sliderule
Volunteer
Posts: 1278
Joined: Thu Nov 29, 2007 9:46 am

Re: HSQLDB 1.8 documentation not easily reachable

Post by Sliderule »

Or, a direct link to HSQL 1.8 documentation
  1. HSQL 1.8 Chapter 9 SQL Syntax:http://www.hsqldb.org/doc/1.8/guide/ch09.html
  2. HSQL 1.8 database functions: http://www.hsqldb.org/doc/1.8/guide/ch09.html#N1251E
  3. Entire 1.8 Guide: http://www.hsqldb.org/doc/1.8/guide/
Sliderule
Post Reply