[Dropped] Table lost after splitting database

[BasePlayer]

I've followed the recommendations for splitting my database, mainly because I wanted to use some of the date math functions in HSQLDB 2.2.8, but also because there appeared to be benefits relating to data security.

Ironically, I now find I keep losing one of my tables after a save. (This never happened when I was using an "embedded" database!)
The error message is: 'The data content could not be loaded. java.io.EOFException'

The only changes I made before saving were to tick some of my check-boxes (boolean fields), plus I added a calculated date in my query and in my form(which shouldn't be affecting my table at all). No new records added.

What could be causing this? Everything seems to work perfectly until I re-open the database.

Any help appreciated.

[BasePlayer]

Update:

The problem happens consistently - i.e. every time I try to save a change - except that now I'm getting the message:

java lang. OutOfMemoryError: Java heap space.

I have only 215 records in my table - although I notice that my form shows: Record 1 of 40*, until I go to last record. Could this be part of the problem?

Also if I backup my data immediately after saving changes, the backup causes the same error.

[DACM]

...splitting my database...HSQLDB 2.2.8.

The error message is: java.io.EOFException

This is the second Java End-Of-File exception error we've encountered in this forum today! I can't replicate this specific error even as I intentionally corrupt the files of a test database. I get other errors (out-of-memory & script errors), but I can't determine the root cause (whether Base or HSQLDB). A Google search would suggest that this is only happening to Base users (as opposed to Hibernate and other front-end users). I'm sorry that I can't be of more help here. Perhaps try in the HSQLDB forum.

[DACM]

...now I'm getting the message:

java lang. OutOfMemoryError: Java heap space.

• Are you running in 'server mode' or the Quickstarter? It may be that multiple HSQLDB instances are running simultaneously. Try a computer shutdown and restart.

...my form shows: Record 1 of 40*, until I go to last record. Could this be part of the problem?

• No, that's a Base design (flaw).

[BasePlayer]

No. I'm not running in 'server mode'.

I've shut down several times since I first encountered this error.

[DACM]

Update:...OutOfMemoryError: Java heap space...I have only 215 records in my table.

Have you performed a CHECKPOINT DEFRAG; from Tools>SQL...?

[Greengiant224]

BasePlayer posted:
No. I'm not running in 'server mode'.

I've shut down several times since I first encountered this error.

How did you shutdown?
Did you try shutdown compact? from Tools>>SQL

Did you try DACM's checkpoint defrag? First.

then shutdown compact?

Close the .odb file including the QUICKSTARTER (if enabled), then restart.

Does that improve upon your problem?

If not, let us know,

Greengiant224

[syp1977]

Hello,
I am facing the same problem.
If I execute Checkpoint Defrag, I get following message:
1: org.hsqldb.HsqlException: java.lang.OutOfMemoryError: Java heap space in statement [checkpoint defrag]
I am using hsqldb 2.5.1
Can anyone help?
Regards,

[Villeroy]

https://opcodesolutions.com/tech/solve- ... index.html

In the context of your office suite, more heap space can be assigned under Tools>Options>Java ("Advanced" in LibreOffice), button "Parameters". Enter the -Xmx argument.

[syp1977]

Thanks for the reply.
I tried Tools>Options>Java>Parameters, tried with both -Xmx2048m and $ java -Xmx2048m
Still I am getting same error.

[Villeroy]

-Xmx4096m
-Xmx8192m

[syp1977]

Hi,
Tried both...
It gives following error:
"OO required Java runtime environment to perform the task. The selected JRE is defective. Please select another version or install a new JRE and select it undet Tools-Options-OO-Java."
I am using Java 8 update 321...
Regards,

[Villeroy]

That error message indicates that Java does not work at all with Openoffice. Can you open this: download/file.php?id=11250

I tried both settings and with both settings I can open my JDBC databases.

Version: 7.3.2.2 / LibreOffice Community
Build ID: 49f2b1bff42cfccbd8f788c8dc32c1c309559be0
CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: x11
Locale: de-DE (de_DE.UTF-8); UI: en-US
Calc: threaded

[syp1977]

Hi,
Yes I can open this file. Open the tables and all the forms and reports. I downloaded Libre 64bit Windows it show runtime error using 64 bit JRE..

[Villeroy]

OK, you can open my database document. This works without any Java. But can you open any object in it? If my database document shows all of its data objects while yours fails to do so with the same setup, upload your database document without the database. I'll have a look at the connection settings.