Hi,

I've got a .odb database that was used on a samba share with
OpenOffice.org version 3.2.1 and when i try to open the file i get the
"Filter selection" window.

After digging around on the net i unziped the .odb file and saw errors
that the database/backup file couldn't be opened (it was zero length). I
removed the empty backup file and re-zipped the .odb file. I can now
open the file, but when i click on 'Tables' or any of the Forms i get:

The connection to the data source "fish" could not be established

SQL Status: S1000
Error code: -40

General error:
org.hsqldb.lib.FileSystemRuntimeException: java.io.IOException:
o:/OOO320/src/package/source/xstor/xstorage.cxx: :3331;

I've tried the hsqldb command line tool on the database and I can
connect to it and e.g. \dt shows the right tables, but:

sql> \d Suppliers
Error at 'stdin' line 4:
"\d Suppliers"
Failed to get metadata from database.
Cause: java.sql.SQLException: Table not found in statement [SELECT *
FROM Suppliers]

Does anyone know any way to recover from this?

btw: running strings on the data file shows reasonable content, and
strings | wc -l compared to an older version shows that the newer
version has more content, so it dosn't look like the data has been
truncated.

P.S. There is a commercial product called Kernel for Base from nucleus
technologies that claims to be able to fix things like this, does anyone
know if it actually works?


<<attachment: jasper.vcf>>

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to