You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2013/01/17 17:38:05 UTC

[Bug 121640] New: Database in odb file cannot be moved with external database

https://issues.apache.org/ooo/show_bug.cgi?id=121640

            Bug ID: 121640
        Issue Type: DEFECT
           Summary: Database in odb file cannot be moved with external
                    database
    Classification: Application
           Product: database access
           Version: AOO 3.4.1
          Hardware: All
                OS: Windows 7
            Status: UNCONFIRMED
          Severity: normal
          Priority: P3
         Component: code
          Assignee: issues@openoffice.apache.org
          Reporter: michael.wegemer@gmail.com
                CC: issues@openoffice.apache.org

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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121640] Database in odb file cannot be moved with external database

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121640

Suchithra <su...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
           Keywords|                            |needmoreinfo
             Latest|---                         |AOO 3.4.1
    Confirmation on|                            |

--- Comment #1 from Suchithra <su...@gmail.com> ---
I need more information on how to reproduce the bug.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121640] Database in odb file cannot be moved with external database

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121640

Rob Weir <ro...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         QA Contact|                            |suchithra75@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121640] Database in odb file cannot be moved with external database

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121640

--- Comment #2 from Michael Wegemer <mi...@gmail.com> ---
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.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121640] Database in odb file cannot be moved with external database

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121640

Fred Toussi <fr...@users.sourceforge.net> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |fredt@users.sourceforge.net

--- Comment #3 from Fred Toussi <fr...@users.sourceforge.net> ---
> 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?

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.

[Bug 121640] Database in odb file cannot be moved with external database

Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=121640

--- Comment #4 from Michael Wegemer <mi...@gmail.com> ---
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

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.