Ask Your Question

query to get LO Base embedded db version number

asked 2018-07-29 14:29:34 +0200

trueriver gravatar image

updated 2018-07-29 14:31:28 +0200

Reading a recent answer it became apparent that the SQL that is accepted in a DDL query (Tools->SQL) depends on the db engine and on the version of that engine. Obvs when you think of it!

So my new question is whether there is a command that can be put into Tools->SQL that will tell me what the embedded db is, and what it is currently running. Presumably this is HSQLDB-dependent at present (and from LO 6.1 will depend on the forthcoming embedded db which is Firebird)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-07-29 16:16:55 +0200

Ratslinger gravatar image


Don't recall ever finding SQL to actually obtain the embedded version number. However, there is a macro on this post -> How do I display the HSQLDB Embedded version? which will display the version.

Unless you have specifically modified LO, the version will be v1.8 and using another version internally will cause problems with being able to use the created Base file on any other system unless that is also modified.

The manner in which to use a different HSQLDB version is to use a split DB. When using HSQLDB this is the preferred method because the embedded version can result in data loss.

edit flag offensive delete link more


Thanks for the link to the mactro

Clarification: By "split DB" do you mean install the other version of HSQLDB server, and connect to that as an "external" db on localhost?

If not, I don't understand what a split db is, please point me at some relevant docs online, or advise if this should be a separate q

trueriver gravatar imagetrueriver ( 2018-07-29 16:19:58 +0200 )edit

No. A split DB does not refer to using the server mode but rather that the data for the database is no longer retained within the .odb. More information on this can be found here -> [Wizard] Create a new 'split' HSQL 2.x database

Ratslinger gravatar imageRatslinger ( 2018-07-29 16:58:45 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-29 14:29:34 +0200

Seen: 51 times

Last updated: Jul 29 '18