Libreoffice 24.2.2.2 problem with java

English
#1

Version: 24.2.2.2 (X86_64) / LibreOffice Community
Build ID: d56cc158d8a96260b836f100ef4b4ef25d6f1a01
CPU threads: 2; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-NZ (en_GB.UTF-8); UI: en-US
Calc: threaded

LibreOffice updated itself a few days (week?) ago, and it now prevents me from opening base files. Correction: I can open the base files fine but whenever I try to open one of the forms contained within I get an error message such as:

SQL Status: S1000
Error code: -25

error in script file line: /my_database_file.odb 43 at /home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/Object.cxx:173

With past LibreOffice updates, one typically has to go to Tools → Options → Advanced and select a Java Runtime Environment. I have two listed:
Private Build 18.0.2-ea
Ubuntu 11.0.22

Selecting either of those two and restarting does not resolve the issue. I get the same error message.

I tried uninstalling LibreOffice 24.2.2.2 and reinstalling LibreOffice 24.2.1 but encountered the same problem, meaning I am unable to access any base files, whereas I was able to open them fine with earlier versions of LibreOffice.

#2

Never, never, never.

#3

although ubuntu snap would.
where from can a user know about that ? :wink:

and for a “solution” …
maybe Bug #2052457 “libreoffice latest version not detecting my java i...” : Bugs : libreoffice package : Ubuntu

2 Likes
#4

Thanks, fpy. It does sound related/similar, but also slightly different? If I’ve understood–always a dangerous assumption–that bug was fixed/committed by ricotz on 2024-03-04, so in theory that should mean my more-recent LibreOffice shouldn’t be affected by it, i.e. it should now have access to the java runtime directory?

Where things differ is: the error messages. They’re told LibreOffice requires a java runtime environment (JRE) when they try to view/open a base table, whereas I don’t ever see that message.

A slight amendment to what I posted above: that error message is actually the second one I get. Immediately before it is this one:

The connection to the data source “my_database_file” could not be established. at /home/buildslave/source/libo-core/dbaccess/source/ui/misc/datasourceconnector.cxx:177

Here’s the second error message again:

SQL Status: S1000
Error code: -25

error in script file line: /my_database_file 43 at /home/buildslave/source/libo-core/connectivity/source/drivers/jdbc/Object.cxx:173

I get the same pair of error messages whether I try to view tables or open a form.

So, my dangerous presumption: because there’s no error message about a lack of a JRE, I assume that means LibreOffice can access the directory containing my JREs, and successfully finds one?

Very likely irrelevant, and excuse my ignorance, but I don’t know/understand the path given in those error messages:

/home/buildslave/source/libo-core/dbaccess/source/ui/misc/

Is that home my Ubuntu user home? I think that rather unlikely. I don’t know where (else) to look for a buildslave directory, but that’s probably not important/relevant.

#5

I’ve also just now uninstalled (purged all of) LibreOffice 24.2.2.2 and tried installing LibreOffice 7.6.6.3 from a deb package:

Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 2; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-NZ (en_GB.UTF-8); UI: en-US
Calc: threaded

It gives me the exact same error messages as before/above. Do I need to try installing a different version of Java runtime environment, or is there something askew with LibreOffice’s paths/expectations, or what?

I’m very surprised that I can’t seem to revert to a version of LibreOffice where base access is working, because it was working for me with an earlier version of LO 24.something earlier this year–each of: Jan/Feb/March 2024.

#6

yep, LTS preferably.

1 Like
#7

~$ java -version
openjdk version “18.0.2-ea” 2022-07-19
OpenJDK Runtime Environment (build 18.0.2-ea+9-Ubuntu-222.04)
OpenJDK 64-Bit Server VM (build 18.0.2-ea+9-Ubuntu-222.04, mixed mode, sharing)
~$ sudo apt install default-jre
[sudo] password for xxxx:
Reading package lists… Done
Building dependency tree… Done
Reading state information… Done
default-jre is already the newest version (2:1.11-72build2).
default-jre set to manually installed.
0 to upgrade, 0 to newly install, 0 to remove and 0 not to upgrade.

That’s me following the instructions given here:
https://ubuntu.com/tutorials/install-jre#2-installing-openjdk-jre

So I believe that’s saying that I do already have the current/latest LTS java runtime environment.

#8

for reference :

are you sure your DB is up and running ?

1 Like
#9

Think it is an internal database.
@jbar : Which database do you use? Internal HSQLDB?
Did you install all packages?
Error isn’t “No JRE detected”, so it is a problem with JDBC connection.

1 Like
#10

Hmm, so I just now tried a different database, one that I haven’t touches for months, and it opened fine and showed tables/forms, etc. So that would suggest there’s something wrong or corrupted with my problem database.

Fortunately I had a split database, but I still had to re-create (re-enter) the data. The UI/front end was reusable. Luckily that wasn’t too onerous but I’ll have to take more care to back up/copy the data file on a regular basis.

Many, many thanks for your kind patience with me, fpy.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.