Created attachment 62669 [details] 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"?