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

From Apache OpenOffice Wiki
< Documentation‎ | FAQ‎ | Databases
Revision as of 16:07, 23 July 2022 by DiGro (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/FAQ/Databases/How_do_I_determine_which_version_of_HSQLDB_is_in_use_with_Base%3F&oldid=250007"
Personal tools