How do I determine which version of HSQLDB is in use with Base?

From Apache OpenOffice Wiki
Jump to: navigation, search


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
Personal tools