| Summary: | Can't create database or access table in Base | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Petr Mladek <pmladek> |
| Component: | Base | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED FIXED | ||
| Severity: | blocker | CC: | iplaw67, LibreOffice, lionel, lo_bugs |
| Priority: | medium | ||
| Version: | 3.6.0.0.alpha1 | ||
| Hardware: | All | ||
| OS: | Linux (All) | ||
| Whiteboard: | target:3.6.0.0.beta1 target:3.7.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 44446 | ||
| Attachments: | Test document | ||
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"? |
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'