HSQLDB 1.8 documentation not easily reachable

[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.

[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.

[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