How do I display the HSQLDB Embedded version?

How do I figure out which HSQLDB Embedded version is running inside my LO?

image description

It’s not in Help | About.

Also, is “HSQDB” HyperSQL or Heidi SQL???

I’m running the latest LO version

Here’s what I’ve learned so far…

== I suspect is running an older version of HSQL because Tools | SQL… can’t find this HSQL function:


== There is a way to upgrade HSQL by splitting off the database best described here.

== I looked at this related question, but it fails to return an answer for me. Does this mean I have V 1.8? When I try the suggested solutions with Tools | SQL... here’s what I get:


Executes successfully. But only returns something like this:

,INFORMATION_SCHEMA,SYSTEM_ALIASES,SYSTEM TABLE,the aliases defined within this database,MEMORY,true,
,INFORMATION_SCHEMA,SYSTEM_ALLTYPEINFO,SYSTEM TABLE,a description of all non user-defined data types known to this database and the level of support for them in various capacities,MEMORY,true,
,INFORMATION_SCHEMA,SYSTEM_AUTHORIZATIONS,SYSTEM TABLE,one row for each user and one row for each role ,MEMORY,true,


Executes successfully. But similarity only returns this:



Fails to execute: “Table not found”


Executes successfully. But no results returned. ???

(Due to a bug in where code inside of a bulleted list does not display correctly, I used == rather than * for line prefixes above.)

If you’re using an embedded DB it’s version 1.8.0. That is all that is included in LO. AOO has a newer version. If you want to see for yourself, use the following macro:

Edited 2021-01-21:

Routine modified to display DB Product Name as well as version number. Have tested with a few different DB’s.

Sub dbInfo
 Dim databaseURLOrRegisteredName As String
  ' adjust this string to your needs. It needs to be the name of a registered database,'
  ' or a complete URL'
  Dim databaseContext As Object
 databaseContext = createUnoService( "" )
  Dim databaseDocument As Object
 databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName )
  Dim connection As Object
 connection = databaseDocument.getConnection( "", "" )
 Dim sMessage as String
 sMessage = "Product Name:     " & connection.getMetaData().getDatabaseProductName() & chr(10) _
          & "Product Version: " & connection.getMetaData().getDatabaseProductVersion()
 MsgBox sMessage
End Sub

Hyper. Never heard of Heidi DB! Also, ROW_NUMBER() did work in HSQL v2.X but not v1.8.

Just looked it up - HeidiSQL is a front end to a DB similar to SQL Workbench/J or MySQL workbench. It is NOT a DB.

@Ratslinger, Thanks! So that’s really amazing to me: the newest LO, still uses the old HSQL v: 1.8.0. (BTW, for others: leave the .odb off of your filename to get your registered name above.)

This Sub also runs just fine in FireBird embedded & registered, LO, Windows10_64bit

When copy&pasting Ratzlinger’s [Sub hsqlVersion] into a module of a FireBird embedded & registered DB, it runs just fine, and pops up the following Msgbox:



product version: 3.0.0



Is the displayed product version indeed the FireBird DB version, or some other number, since this is actually HSQL code?

Also, if one would use this code in a LO embedded FireBird DB, would it continue to run over time, or would corresponding libraries over time be phased out with the depreciation of HSQLDB from LO?

Never tried on other DB’s (that is to say other than HSQLDB split & embedded). Firebird embedded is 3.0 and the code would not change IF HSQLDB embedded is deprecated.


Also worked with PostgreSQL. Should work with others.

I use HeidiSQL. It was previously known as MySQL-Front. It is a database management tool for MySQL, Microsoft SQL Server, and PostgreSQL databases. You can connect to local or remote servers.

@Peterwt, thanks! Briefly, how does it compare to LO as a front end?

@EasyTrieve It is only a management tool similar to PHPMyAdmin. See here its free.

You can detect the HSQLDB version using SQL using this query:

select character_value
from information_schema.sql_implementation_info
where implementation_info_name = 'DBMS VERSION'


Doesn’t work for me on HSQLDB embedded:

1: invalid schema name: information_schema in statement [SELECT "character_value" FROM "information_schema"."sql_implementation_info"] /home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/Object.cxx:175

You should remove the quotes or if you can’t remove the quotes, then use upper-case table names

You do not understand. That is the output error message by the system. SQL used:

select character_value
from information_schema.sql_implementation_info
where implementation_info_name = 'DBMS VERSION'


Also note. This does work in a later version of HSQLDB but not the embedded version which is what the question is about.