libreoffice fails to recognize jre 7 java installations

[Matt Price]

Libreoffice cannot "see" the various java installations on my computer If I manually enter a path, like /usr/lib/jvm/java-7-openjdk-amd64/jre, the attempt fails with the message "the folder you have selected does not contain a java runtime environment".

This cripples my installation, since it means I can't use the Zotero extension for citation, so all of my old papers are inaccessible.

ProblemType: Bug
DistroRelease: Ubuntu 12.10
Package: libreoffice 1:3.6.1~rc2-1ubuntu5
Uname: Linux 3.6.0-030600rc6-generic x86_64
ApportVersion: 2.5.1-0ubuntu7
Architecture: amd64
Date: Thu Sep 27 07:40:45 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.04 "Lucid Lynx" - Beta amd64 (20100318)
ProcEnviron:
 TERM=xterm
 PATH=(custom, no user)
 LANG=en_CA.UTF-8
 SHELL=/bin/bash
SourcePackage: libreoffice
UpgradeStatus: Upgraded to quantal on 2012-09-06 (21 days ago)

[Pmladek-y (pmladek-y)]

Created attachment 62669
Test document

Base is almost unusable in 3.6-alpha1 and master. I am unable to create new database. Also I am not able to access table in an older database.

The strange thing is that I am able to access table from ~/.config/libreoffice/3/user/database/biblio.odb. I wonder if this database is created using another driver.

Steps to reproduce (existing database):

1. Open the attached test.odb
2. Click "Tables" button in the left box

Result: Error message:

         'The connection to the data source "test" could not be established.
          org/hsqldb/lib/FileSystemRuntimeException'

Another steps to reproduce (creating new database)

1. Start LibreOffice
2. Select in menu File/New/Database
3. Make sure that "Create new database" is selected and press the button
   "Finish"
4. Enter database name, e.g. "test-new.odb" and press "Enter"

Result: Error message (same as above):

        'The connection to the data source "test" could not be established.
         org/hsqldb/lib/FileSystemRuntimeException'

[Lionel Elie Mamane (lionel-mamane)]

Darn.

All your examples are about embedded HSQLDB; did you try *any* other database driver?

Yes, biblio.odb is not an embedded HSQLDB database, but is a connection to a DBase 3 database; the data is in file biblio.dbf / .dbt

This suggests *only* (embedded) HSQLDB is broken.

Haven't got a 3.6/3.7 build yet, so it will take me some time before I can take a look.

[Pmladek-y (pmladek-y)]

It works in the daily build
http://dev-builds.libreoffice.org/daily/Linux-x86_64_11-Release_Configuration/master/2012-05-23_15.09.58/, so it is relatively new regression.

[Pmladek-y (pmladek-y)]

It was enough to exchange sdbc_hsqldb.jar between the working on non-working build.

[Pmladek-y (pmladek-y)]

One change is that org/hsqldb/lib/FileSystemRuntimeException.class is missing in the broken sdbc_hsqldb.jar. I guess that it is related to gbuildification.

[Pmladek-y (pmladek-y)]

--- a/connectivity/Jar_sdbc_hsqldb.mk
+++ b/connectivity/Jar_sdbc_hsqldb.mk
@@ -39,6 +39,8 @@ endif

 $(eval $(call gb_Jar_set_packageroot,sdbc_hsqldb,com))

+$(eval $(call gb_Jar_add_packagedir,sdbc_hsqldb,org))
+
 $(eval $(call gb_Jar_add_sourcefiles,sdbc_hsqldb,\
        connectivity/com/sun/star/sdbcx/comp/hsqldb/FileSystemRuntimeException \
        connectivity/com/sun/star/sdbcx/comp/hsqldb/NativeInputStreamHelper \

solved the missing org/hsqldb/lib/FileSystemRuntimeException.class.

I am able to create new table now. I am still unable to open the table of the attached test.odb. It fails with the error:

--- cut ---
'The connection to the data source "test" could not be established.

General error: java.lang.UnstatisfiedLinkError:
com.sun.star.sdbcx.hsqldb.StorageFileAccess.isStreamElement(Ljava/lang/String;Ljava/lang/String;)Z
--- cut ---

So, there is another quirk. Also in this case, it helps to use sdbc_hsqldb.jar from http://dev-builds.libreoffice.org/daily/Linux-x86_64_11-Release_Configuration/master/2012-05-23_15.09.58/

[Pmladek-y (pmladek-y)]

The other difference is that "Class-Path: hsqldb.jar .." is missing in MANIFEST.MF. Also this looks related to gbuildification.

[Pmladek-y (pmladek-y)]

It started to work after I added the Class-path into MANIFEST.MF. The fix is in master and 3-6 branch now.

[Libreoffice-bugs (libreoffice-bugs)]

Petr Mladek committed a patch related to this issue.
It has been pushed to "libreoffice-3-6":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=203707c0591021d827b1de855f977cdb4c8cfd47&g=libreoffice-3-6

make hsql database working again (fdo#50783)

It will be available in LibreOffice 3.6.

[Libreoffice-bugs (libreoffice-bugs)]

Petr Mladek committed a patch related to this issue.
It has been pushed to "master":

http://cgit.freedesktop.org/libreoffice/core/commit/?id=7a86071a9cb2c3ceb8f3efc6345889ae4638a91f

make hsql database working again (fdo#50783)

[Lo-bugs (lo-bugs)]

The problem persists for me with master commit 96caa3b on ubuntu-natty (11.04).

I did an incremental build. Should that be sufficient?

[Pmladek-y (pmladek-y)]

Terrence, I am afraid that incremental build is not sufficient. Please, try to rebuild the whole connectivity module. You might use the following two commands from the root build dir:

    make connectivity.clean
    make connectivity

[Libreoffice-z (libreoffice-z)]

Part of problem still visible with WIN 3.6.0Beta, see "Bug 50910 - Impossible to access particular spreadsheet based database table".

This here really "Linux Only"?

[Launchpad Janitor (janitor)]

Status changed to 'Confirmed' because the bug affects multiple users.

[Jim McKean (jimmckean)]

I have both open java and oracle java installed. I want to use openjava 1.6 but it only sees oracle

[kaktux (kaktux)]

same for Kubuntu 12.04.
openjdk can't be detected (same message "does not contain")
So zotero can't be used.

[debora (luzzorru-4)]

same problem. ubuntu 12.04. libreoffice 4.1, java 1.8

[Björn Michaelsen (bjoern-michaelsen)]

@Rolf: How does it make sense to add fdo#50783, which is fixed in upstream LibreOffice 4.0, when this bug is reported against Ubuntu 14.04 (and thus LibreOffice 4.2.x)?

[Rolf Leggewie (r0lf)]

On 08.12.2014 22:20, Björn Michaelsen wrote:
> @Rolf: How does it make sense to add fdo#50783, which is fixed in
> upstream LibreOffice 4.0, when this bug is reported against Ubuntu 14.04
> (and thus LibreOffice 4.2.x)?

Björn, that is what showed up in my research. People were referencing
that ticket about this particular problem even after it was set to
fixed. I am not saying it is the same bug but having a pointer to the
ticket might still provide valuable information for anyone triaging this
problem. My bad, I should have made this clearer.

[Björn Michaelsen (bjoern-michaelsen)]

Cannot reproduce on LibreOffice 4.2.7 on Ubuntu 14.04 -- add a Java path manually works (well it actually realizes this to be one of the existing entries). Thus marking as fix released.