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

Discuss the database features

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

Postby dreamquartz » Sun Aug 06, 2017 3:27 am

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
Last edited by dreamquartz on Sun Sep 10, 2017 8:09 am, edited 2 times in total.
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am

Re: java.lang.ClassCastException ERROR

Postby Villeroy » Sun Aug 06, 2017 9:24 am

HSQL 2.4? Try 2.3 instead. Exchange the hsqldb.jar file with the one from the older package.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25965
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: java.lang.ClassCastException ERROR

Postby dreamquartz » Sun Aug 06, 2017 11:38 pm

Villeroy wrote: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
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am

Re: java.lang.ClassCastException ERROR

Postby dreamquartz » Tue Aug 08, 2017 7:00 pm

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.
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am

Re: java.lang.ClassCastException ERROR

Postby RoryOF » Tue Aug 08, 2017 7:27 pm

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.
Apache OpenOffice 4.1.6 on Xubuntu 18.04 (mostly 64 bit version) and infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 27676
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: java.lang.ClassCastException ERROR

Postby Villeroy » Tue Aug 08, 2017 7:31 pm

This topic is not a matter of stability. HSQL 2.4 supports new data types that are not suppoted by OpenOffice.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, OpenOffice 4.x & LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 25965
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: java.lang.ClassCastException ERROR

Postby eremmel » Tue Aug 08, 2017 7:45 pm

You might change title to express the version of HSQLDB and mark it as solved.
Is your question answered: edit your initial post add "[Solved]" to the subject and check V
LO4.2.8 for work with ORB; AOO4.1.4,LO5.2.5/6.0.5 on W7E SP1 64bit
It's Microsoft marketing that tells you computers are qualified for non-technicians
User avatar
eremmel
Volunteer
 
Posts: 1016
Joined: Tue Dec 30, 2008 1:15 am
Location: Barneveld, Netherlands

Re: java.lang.ClassCastException ERROR

Postby dreamquartz » Wed Aug 09, 2017 2:29 am

Villeroy wrote: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
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am

Re: java.lang.ClassCastException ERROR

Postby dreamquartz » Wed Aug 09, 2017 2:31 am

eremmel wrote: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
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am

Re: java.lang.ClassCastException ERROR

Postby dreamquartz » Wed Aug 09, 2017 2:37 am

RoryOF wrote: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 :D).

Dream
LO 5.x and OO 4.x on Windows 7 PRO & Ubuntu 16.04 LTS.
dreamquartz
 
Posts: 644
Joined: Mon May 30, 2011 4:02 am


Return to Base

Who is online

Users browsing this forum: No registered users and 1 guest