Issue 93428 - cannot connect to HSQLDB embedded in read-only database document
Summary: cannot connect to HSQLDB embedded in read-only database document
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOO300m3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 3.1
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-09-03 14:07 UTC by Frank Schönheit
Modified: 2008-10-29 11:24 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Frank Schönheit 2008-09-03 14:07:03 UTC 
- copy an arbitrary database document, containing embedded HSQLDB data, to an
  arbitrary temporary location
- make the copy read-only in the file system
- open the copy in OpenOffice.org
- in Base's main window, select "Tables" on the left hand side, this way
  connecting to the embedded HSQLDB data
=> an error pops up saying 
   General Error: org.hsqldb.lib.FileSystemRuntimeException:
   java.io.IOException

While this error message is of no use to the end user who encounters it (and
thus should be improved), the real problem here is that it of course *should* be
possible to open an embedded HSQLDB even when the database document is read-only.
Comment 1 Frank Schönheit 2008-09-03 14:08:47 UTC 
We already fixed such a bug a while ago, we even did this twice, IIRC.

fs->oj: When you fix this issue, please also add a complex test case, which
ensures that we really fix it the last time. Obviously, this area is prone to
breakage ... Thanks.
Comment 2 Frank Schönheit 2008-09-03 14:11:16 UTC 
for the record: the previous incarnations of this bug: issue 45749, issue 67263
Comment 3 ocke.janssen 2008-10-29 10:54:57 UTC 
I tried a OOO300m9 and it works. Could please verify that it works in OOo 3.0?
Thanks.
Comment 4 Frank Schönheit 2008-10-29 11:24:05 UTC 
Indeed, works in OOO300m9. Maybe related to the InputStream problems we had on
early versions of OOO300.