[Solved] java.lang.ClassCastException ERROR in HSQL 2.4 & LO

[dreamquartz]

Hi All,

Errors are piling up in a database I use and manage for a client.
It appears the database is really slow.
I have entered many items of data, using different forms, and a few days ago, things started to happen.
For a form fPerson; to fill out personal info;

"SQL Status: S1000"
"Error code: -458"
"The data content could not be loaded."
"java.lang.ClassCastException:java.lang.String cannot be cast to java.lang.Number"

A Form fCertificate:
ERROR 1

The contents of a combo box or a list field could not be determined.
"SQL Status: S1000"
"Error code: -458"
"java.lang.ArrayIndexOutOfBoundsException: 7"

ERROR 2

"The data content could not be loaded"
"SQL Status: S1000"
"Error code: -458"
"java.lang.ClassCastException:java.lang.String cannot be cast to java.lang.Number"

A Form fProject

The contents of a combo box or a list field could not be determined.
"SQL Status: S1000"
"Error code: -458"
"java.lang.ClassCastException:java.lang.String cannot be cast to java.lang.Number"

Sometimes the pop up with a single exclamation mark shows, and the database closes.

Any ideas are much appreciated.

Dream

[Villeroy]

HSQL 2.4? Try 2.3 instead. Exchange the hsqldb.jar file with the one from the older package.

[dreamquartz]

HSQL 2.4? Try 2.3 instead. Exchange the hsqldb.jar file with the one from the older package.

Was able to download. Will test.

Dream

[dreamquartz]

Thanks Villeroy,

You saved the day (AGAIN).

Interesting situation, though..
HSQLDB 2.3.4 is quite stable on Ubuntu 16.04 LTS.
On Windows 7 PRO with LO 5.2.7 and 5.3.5, the split database has problems galore.
It crashes left and right and even these version of LO are considered to be "stable", it is no "fun" to use it.
Seriously considering to remove Windows as daily use on desktop.
Need it however for accounting software.

Dream.

[RoryOF]

I've moved for all daily work to Xubuntu. I keep one old Windows machine for access to archival material - not needed these 10 years.

[Villeroy]

This topic is not a matter of stability. HSQL 2.4 supports new data types that are not suppoted by OpenOffice.

[eremmel]

You might change title to express the version of HSQLDB and mark it as solved.

[dreamquartz]

This topic is not a matter of stability. HSQL 2.4 supports new data types that are not suppoted by OpenOffice.

Indeed,

But having both OS's moved back to HSQL 2.3.4, it is worth mentioning.
The difference is truly significant.

Dream

[dreamquartz]

You might change title to express the version of HSQLDB and mark it as solved.

Well it is partially solved, because with Windows 7 pro, there are still major problems.
I am wondering if there is more going on.

Have adjusted the title, and leave it open for now.

dream

[dreamquartz]

I've moved for all daily work to Xubuntu. I keep one old Windows machine for access to archival material - not needed these 10 years.

Thanks fr your comforting words. I know this for a long time already, and moved away from Windows as much as we can, but our Accountant needs our files in a certain format, because of communication with the national tax person (gender neutral ).

Dream