[Solved] How to tell HSLQDB version in LibreOffice?
[Solved] How to tell HSLQDB version in LibreOffice?
How can one tell which HSLQDB version is being used in LibreOffice?
Last edited by kbellis on Mon Apr 15, 2019 3:42 pm, edited 1 time in total.
LO6222(x64) • AOO416 • Windows 10 Pro, 64-bit
Re: How to tell HSLQDB version in LibreOffice?
This will always be 1.8 for the embedded HSQLDB documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: How to tell HSLQDB version in LibreOffice?
Thanks for clearing that up Villeroy.Villeroy wrote:This will always be 1.8 for the embedded HSQLDB documented here: http://www.hsqldb.org/doc/1.8/guide/ch09.html
I'm still curious why v1.8 isn't clearly listed in LO's about screen, particularly since it's deprecated and so much effort appears to avoid its use? This is all quite new and nuanced for me, and I may have gotten the wrong impression at this early stage of learning LO Base. Man!, I was at first thinking Base would be a simple thing to learn in a few days or even a few hours. Regardless of my false expectations, your guidance and encouragement, and from others here in this community, are heartening - THANK YOU!!
Kind regards,
Kelly
LO6222(x64) • AOO416 • Windows 10 Pro, 64-bit
- MrProgrammer
- Moderator
- Posts: 4907
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: [Solved] How to tell HSLQDB version in LibreOffice?
You can verify the version by creating a new embedded database, unZIPping the ODB file, and viewing the database/properties file.
$ cat database/properties
#HSQL Database Engine 1.8.0.10
#Mon Apr 15 09:08:16 CDT 2019
hsqldb.script_format=0
runtime.gc_interval=0
sql.enforce_strict_size=true
hsqldb.cache_size_scale=8
readonly=false
hsqldb.nio_data_file=false
hsqldb.cache_scale=13
version=1.8.0
hsqldb.default_table_type=cached
hsqldb.cache_file_scale=1
hsqldb.lock_file=true
hsqldb.log_size=10
modified=yes
hsqldb.cache_version=1.7.0
hsqldb.original_version=1.8.0
hsqldb.compatible_version=1.8.0
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
AOO 4.1.7 Build 9800, MacOS 13.6.3, iMac Intel. The locale for any menus or Calc formulas in my posts is English (USA).
Re: [Solved] How to tell HSLQDB version in LibreOffice?
Base is extremely simple (too simple) for anybody who is familiar with databases in general. The whole component weighs no more than 30 MB including various database drivers.
Embedded HSQL 1.8 is fine for demos and education. 10 years ago I implemented a fairly complex project with embedded HSQL and it allowed me to collect dozends MB of data over 2 years without a single problem.
I was aware of the problems with this data format, saved and closed my work properly and I do daily backups of all my data.
Meanwhile I run a little HSQL server with a database for up to 6 clients. HSQL 2.3.4 works pretty well with our office suite and the stand-alone HSQL meets all my expections. I do not feed any web site with this database but even that should be possible.
Others use Base successfully with PostgreSQL or with MySQL. Base is just a set of tools to connect text and spreadsheet documents with databases. The ability to generate databases from scratch and wrap them into one document file has been added in 2005. IMHO, this was a mistake and LibreOffice with embedded Firebird will not change anything to the better.
Embedded HSQL 1.8 is fine for demos and education. 10 years ago I implemented a fairly complex project with embedded HSQL and it allowed me to collect dozends MB of data over 2 years without a single problem.
I was aware of the problems with this data format, saved and closed my work properly and I do daily backups of all my data.
Meanwhile I run a little HSQL server with a database for up to 6 clients. HSQL 2.3.4 works pretty well with our office suite and the stand-alone HSQL meets all my expections. I do not feed any web site with this database but even that should be possible.
Others use Base successfully with PostgreSQL or with MySQL. Base is just a set of tools to connect text and spreadsheet documents with databases. The ability to generate databases from scratch and wrap them into one document file has been added in 2005. IMHO, this was a mistake and LibreOffice with embedded Firebird will not change anything to the better.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice