Bug#340468: openoffice.org-base: creating tables fails with "libhsqldb2: file not found"

[marcus@better.se]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Package: openoffice.org-base
Version: 2.0.0-2
Severity: important

I cannot create tables in a new, empty database file.

Create a new Base document named Employees using HSQLDB (with only default
options). Then press "Tables" to go to the tables view. This gives a
pop-up error message, translated freely from Swedish: 

  Cannot connect to the data source "Employees"

  libhsqldb2: file not found

If I press OK to get rid of the popup, and try "Tables" again, I get a
different message:

  Cannot connect to the data source "Employees"

  com.sun.star.sdbcx.comp.hsqldb.StorageFileAccess

Any further attempts give this second error message.

There is a fix:
  http://ubuntuforums.org/archive/index.php/t-77087.html

In other words, create a link in /usr/lib/openoffice/program from
libhsqldb2 to libhsqldb2.so. This seems to work for me.

The problem is reproducible on this system, but I have another i386
system with the same version of OpenOffice where I cannot reproduce
it. That system has the Sun JRE instead of Kaffe.

- --- System Information:
Debian Release: 3.1
  APT prefers testing
  APT policy: (600, 'testing'), (500, 'unstable'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.6.12-custom
Locale: LANG=sv_SE.UTF-8, LC_CTYPE=sv_SE.UTF-8 (charmap=UTF-8)

Versions of packages openoffice.org-base depends on:
ii  java-gcj-c 1.0.30-4                      Java runtime environment using GIJ
ii  libc6      2.3.5-6                       GNU C Library: Shared libraries an
ii  libgcc1    1:4.0.2-2                     GCC support library
ii  libglib2.0 2.8.3-1                       The GLib library of C routines
ii  libhsqldb- 1.8.0.2-1                     Java SQL database engine
ii  libmdbtool 0.5.99.0.6pre1.0.20050409-1.2 mdbtools libraries
ii  libstdc++6 4.0.2-4                       The GNU Standard C++ Library v3
ii  libstlport 4.6.2-3                       STLport C++ class library
ii  openoffice 2.0.0-2                       OpenOffice.org office suite archit
ii  openoffice 2.0.0-2                       OpenOffice.org office suite Java s

- --- no debconf information
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Processed by Mailcrypt 3.5.8+ <http://mailcrypt.sourceforge.net/>

iD8DBQFDhJ8PXjXn6TzcAQkRAoSeAJwIlv2uhGstIXUx6/pJgPd3sAWTLgCfVb9Y
pvpTPhcYq9nsTmHM+gTrIYU=
=yeNC
-----END PGP SIGNATURE-----