How do I determine which version of HSQLDB is in use with Base?
From Apache OpenOffice Wiki
< Documentation | FAQ | Databases
How do I determine which version of HSQLDB is in use with Base?
In Base, open the SQL console: Tools → SQL…
- If you suspect the default HSQLDB 1.8.0.10 engine, then type-in (copy & paste):
CALL "org.hsqldb.Library.getDatabaseFullProductVersion"()
- If you suspect HSQLDB 2.x, then type-in (copy & paste):
SELECT DISTINCT DATABASE_VERSION() AS "HSQL Version" FROM INFORMATION_SCHEMA.SYSTEM_TABLES