[libreoffice-users] Re: Calc and Base problems.

Am 30.09.2011 14:57, Alexander Thurgood wrote:
> Le 30/09/11 09:24, Ian Whitfield a écrit :
>
> Hi Ian,
>
> > On my second machine I have a separate copy of the Database file from
> > machine 1 which is also "Registered" on that machine. If I try to run
> > the database - 'LO Base>Open existing file>Select file>Open' The Base
> > window opens and shows all my Tables, forms etc. But when I select any
> > of these I get the following error...
> >
> > "Connection to 'My DB' couldn't be established.
> > GENERAL ERROR: org.hsqldb.lib.FileSystem RunTime Error:
> > Java.IO Exception:
> > /home/tinderbox/ooobuild/build/libre-3.3.2.2/package/source/xstor/xstorage.cxx:
> > :3323;"
>
> Hmm, you are using a tinderbox build because that's what that message
> seems to imply from the path ???
>
> As the message further says, this is an IO exception :
>
> lines 3319-3323 in xstorage.cxx deal with this and throw an exception if
> the data in the container file can not be accessed.
>
> Is your ODB file writable ?
>
> Are you sure that the paths (and their read/write access) from the first
> machine are the same as the second machine - if not, then your ODB
> container as copied is going to have a problem trying resolve the paths...

The so called "database document" behaves like an extension. Every time 
you "open the document" the office suite extracts the HSQLDB into your 
temporary directory as specified in Tools>Options>Paths. Every time you 
"close the database document" the office suite rebuilds the package. 
Needless to say that this puts your data at more risk, the more data you 
compress and decompress.

I use to declare ~/.libreoffice/3/user/temp/ as temporary directory for 
the office suite. All embedded HSQLDB installs into this directory.


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted