I am using LO7.3.6.2 base with Windows 10 HSQLDB split database. This morning I could not connect to the DB anymore, message says “data content could not be loaded; general error”. I have tryed an older version of this .odb file which worked. Now I am a bit confused of what could be corrupt, I first though it was due to a java update or so but then none would work. Any help or hint would be much appreciated. Thank you!
Compare menu:Edit>Database>Properties… of the two documents.
Try FreeHSQLDB v.0.4
This returns the version of a connected HSQL 2.x database:
SELECT DATABASE_VERSION( ) AS "HSQL_VERSION"
FROM "INFORMATION_SCHEMA"."SYSTEM_TABLES"
WHERE "TABLE_NAME" = 'ROUTINES'thank you very much @Villeroy , the SQL returns version 2.5.0, I compared the 2 paths of both documents and they are identical. Only difference is one document is on another drive.
I do not understand what creates this situation.
and what happens when you copy the failing document to the same drive?
aha then it works! so sdoes that mean I must change some path in content.xml?
now all my dates have changed to 20.01.1970, why would that happen?
Install my little macro suite and run MyMacros>FreeHSQLDB>FreeHSQLDB>Main. It offers a little GUI with file pickers for the necessary changes. There is the absolute path to the database folder and there is the absolute path to the correct hsqldb.jar.
On Windows the drive letters of removable devices may change.
I don’t know. This is worth an extra question. You may also contact the HSQL developers.
Personally, I avoid HSQL 2.5 because there are too many changes, some of them not compatible with Base. I prefer the latest 2.4.x version which works perfectly well with Base.
I will install the HSQLDB.2.4.1.jar in the database folder, thank you for the advice