please backport the fix for upstream bug 50783

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'

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.

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.

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

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.

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

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

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

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.

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)

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

I did an incremental build. Should that be sufficient?

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

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