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"?
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.