[libreoffice-users] Re: Problems importing an OO database into LO

Am 20.04.2012 10:48, Ian Whitfield wrote:
> On 20/04/2012 01:18, Andreas Säger wrote:
> > There are not many users who suffer from the limited capabilities of
> > HSQL 1.8.
> > A high risk of total data loss is the main reason why one must not use
> > the embedded database. Getting an embedded database out of the jail is
> > easy enough.
> OK Andreas (or anyone else) - for those of us not so good at this how
> about a detailed Tutorial on doing this??
>
> Right here....

1) Download and extract the latest HSQLDB to some place. No installation 
required.
2) Point the "Class Path" setting in the LibreOffice Java options to 
hsqldb.jar in your subdirectory "lib".
3) Extract the database folder out of your embedded .odb.
4) Rename the files:
 properties, script, backup, data
to:
 foo.properties, foo.script, foo.backup, foo.data
where "foo" is just an arbitrary name.
5) Connect a new Base document to a JDBC data source with an URL like:
jdbc:hsqldb:file:/path/to/extracted/database/foo;default_schema=true
(the "foo" refers to the same database name I used as file name prefix)
6) Copy queries, forms and reports from the old embedded .odb to the new 
one.

Slightly more details and links in:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=61&t=46324&p=214069&hilit=hsqldb#p214049

For multi-user access you can start the hsqldb.jar in server mode and 
connect the .odb clients with something like
jdbc:hsqldb:hsql://192.168.0.2/foo;default_schema=true




--
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