Ask Your Question

How do I display the HSQLDB Embedded version? [closed]

asked 2017-01-05 19:55:54 +0200

EasyTrieve gravatar image

updated 2020-09-20 14:21:14 +0200

Alex Kemp gravatar image

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

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-20 14:21:31.518757

2 Answers

Sort by » oldest newest most voted

answered 2017-01-05 21:14:30 +0200

Ratslinger gravatar image

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:

Sub hsqlVersion
 Dim databaseURLOrRegisteredName As String
  ' adjust this string to your needs. It needs to be the name of a registered database,'
  ' or a complete URL'
 databaseURLOrRegisteredName = "YOUR-REGISTERED-DB-NAME-HERE"
  Dim databaseContext As Object
 databaseContext = createUnoService( "" )
  Dim databaseDocument As Object
 databaseDocument = databaseContext.getByName( databaseURLOrRegisteredName )
  Dim connection As Object
 connection = databaseDocument.getConnection( "", "" )
  MsgBox "product version: " & connection.getMetaData().getDatabaseProductVersion()
End Sub

The DB must be registered. Also works on split DBs so you can see which version is installed in directory.

edit flag offensive delete link more



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

Ratslinger gravatar imageRatslinger ( 2017-01-05 21:18:34 +0200 )edit

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 gravatar imageRatslinger ( 2017-01-05 23:16:24 +0200 )edit

@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.)

EasyTrieve gravatar imageEasyTrieve ( 2017-01-06 04:06:35 +0200 )edit

answered 2017-01-06 00:08:03 +0200

peterwt gravatar image

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.

edit flag offensive delete link more


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

EasyTrieve gravatar imageEasyTrieve ( 2017-01-06 04:08:33 +0200 )edit

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

peterwt gravatar imagepeterwt ( 2017-01-06 18:09:15 +0200 )edit

Question Tools

1 follower


Asked: 2017-01-05 19:55:54 +0200

Seen: 2,238 times

Last updated: Jan 06 '17