Issue 121640 - Database in odb file cannot be moved with external database
Summary: Database in odb file cannot be moved with external database
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: 3.4.1
Hardware: All Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact: Suchithra
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2013-01-17 16:38 UTC by Michael Wegemer
Modified: 2013-02-06 00:40 UTC (History)
2 users (show)

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


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description Michael Wegemer 2013-01-17 16:38:05 UTC
Because absolute file name is contained in the connection information for an external database, moving the file causes OO to try to read the original file which is no longer there or on another machine. In developing an application I created a directory with the data base files (HSQLDB) and the odb file. When I moved the directory from the development machine to the user machine the application would no longer run. Changing the connection information solved the problem. Would recommend that for an external data base requiring files that OO create the directory so that the path to the files can be relative.
Comment 1 Suchithra 2013-01-30 03:05:05 UTC
I need more information on how to reproduce the bug.
Comment 2 Michael Wegemer 2013-01-30 14:05:12 UTC
To reproduce:

Create any open office base data base with HSQLDB external (not embedded)
Move (not copy) the .obd file to another directory.
Open the .obd file by double clicking on it.

The file will fail to open properly because base is looking for the file in the original directory.
Comment 3 Fred Toussi 2013-02-01 13:01:16 UTC
> Would recommend that for an external data
> base requiring files that OO create the directory so that the path to the
> files can be relative.

What exactly is your recommendation? 

Do you mean OO should create a directory in the folder where your .odb file is located?

What kind of relative URL would you be using to connect to the database?
Comment 4 Michael Wegemer 2013-02-06 00:40:29 UTC
Open office would create the directory for the data base files as a subdirectory of the directory where the odb files exists. The data base reference then could be stored as ./databasedirectory so that the data base file location is relative to the odb file. In this way the complete database could be moved and still function. You would simply move the odb file and the data base directory