desktop-packages team mailing list archive

Thread
Date
[Bug 1057480] Re: libreoffice fails to recognize jre java installations

To: desktop-packages@xxxxxxxxxxxxxxxxxxx
From: Bug Watch Updater <1057480@xxxxxxxxxxxxxxxxxx>
Date: Sun, 07 Dec 2014 12:31:16 -0000
Reply-to: Bug 1057480 <1057480@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Launchpad has imported 13 comments from the remote bug at
https://bugs.freedesktop.org/show_bug.cgi?id=50783.

If you reply to an imported comment from within Launchpad, your comment
will be sent to the remote bug automatically. Read more about
Launchpad's inter-bugtracker facilities at
https://help.launchpad.net/InterBugTracking.

------------------------------------------------------------------------
On 2012-06-06T04:58:58+00:00 Pmladek-y wrote:

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'

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/0

------------------------------------------------------------------------
On 2012-06-06T05:09:26+00:00 Lionel Elie Mamane wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/1

------------------------------------------------------------------------
On 2012-06-06T06:35:28+00:00 Pmladek-y wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/2

------------------------------------------------------------------------
On 2012-06-06T06:55:08+00:00 Pmladek-y wrote:

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

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/3

------------------------------------------------------------------------
On 2012-06-06T07:10:23+00:00 Pmladek-y wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/4

------------------------------------------------------------------------
On 2012-06-06T07:39:28+00:00 Pmladek-y wrote:

--- 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/

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/5

------------------------------------------------------------------------
On 2012-06-06T07:50:54+00:00 Pmladek-y wrote:

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

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/6

------------------------------------------------------------------------
On 2012-06-06T08:32:36+00:00 Pmladek-y wrote:

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

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/7

------------------------------------------------------------------------
On 2012-06-06T08:32:58+00:00 Libreoffice-bugs wrote:

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.

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/8

------------------------------------------------------------------------
On 2012-06-06T08:33:29+00:00 Libreoffice-bugs wrote:

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)

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/9

------------------------------------------------------------------------
On 2012-06-08T04:45:17+00:00 Lo-bugs wrote:

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

I did an incremental build.  Should that be sufficient?

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/10

------------------------------------------------------------------------
On 2012-06-08T04:52:42+00:00 Pmladek-y wrote:

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

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/11

------------------------------------------------------------------------
On 2012-06-09T04:13:18+00:00 Libreoffice-z wrote:

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"?

Reply at:
https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1057480/comments/12


** Changed in: df-libreoffice
       Status: Unknown => Fix Released

** Changed in: df-libreoffice
   Importance: Unknown => Critical

-- 
You received this bug notification because you are a member of Desktop
Packages, which is subscribed to libreoffice in Ubuntu.
https://bugs.launchpad.net/bugs/1057480

Title:
  libreoffice fails to recognize jre 7 java installations

Status in LibreOffice Productivity Suite:
  Fix Released
Status in libreoffice package in Ubuntu:
  Confirmed

Bug description:
  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)

To manage notifications about this bug go to:
https://bugs.launchpad.net/df-libreoffice/+bug/1057480/+subscriptions